[SalesForce] Create a formula text field to display prior value or text field

I'm wondering if it is possible to create a formula field that will display the previous value of a text field.

Example:
If an account name is changed, display that previous value in the formula field. I tried: PRIORVALUE(Name) but received an error of "PRIORVALUE may not be used in this type of formula"

Best Answer

No, there is no formula for this; formula functions like ISCHANGED and PRIORVALUE only work in the context when a field value is transitioning from one value to another (i.e. during a DML update). Old values are not stored in the database (other than field history, which can't be used in a formula anyways).

The best you could do is create a text field called something like "Field Previous Value," then set a Process Builder/Workflow Rule that copies the prior value of the field to this second text field when the field changes. As a workflow example: "Evaluate when the following formula is true: ISCHANGED(FieldName)" with a workflow field update "Previous Field Value set to formula PRIORVALUE(FieldName).

Related Solutions

[SalesForce] How to get the all prior field value in textearea field or formula field

Field History tracking is the right way to track field value changes. especially if you are changing the priority field value everyday. (you can never be sure about the text lenght you need to store the entire history)

but if you still need to get all the previous values in a field, you can try the below

Create a Custom Long Text Area field in your object (say its name is PriorityHistory__c)
Create a New Workflow Rule on your custom object
Select rule criteria as formula evaluates to true and use a formula like ISCHANGED(YourPriorityField)
Select workflow action as field update and select the custom field PriorityHistory__c as the field to be updated
enter the new value as a formula

PriorityHistory__c & '-' & PRIORVALUE(YourPriorityField)

[SalesForce] Concatenating address field in formula

Try using

Account__r.Name + BR()+ Account__r.BillingStreet+ BR() + Account__r.BillingCity + BR() +....

to build up the full address.

Address fields are a special case in Salesforce and are a concatenation of the underlying data fields. Selecting each individually can get around errors like this.

Best Answer

Related Solutions

[SalesForce] How to get the all prior field value in textearea field or formula field

[SalesForce] Concatenating address field in formula

Related Topic