I have one text field like priority and I will change every day the priority. now I would like to store the prior values in the text area field or formula field. how to do?

Temporary i am viewing the activity track history. so how to display all prior value(all last changed) in the formula text 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

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

    PriorityHistory__c & '-' & PRIORVALUE(YourPriorityField)

  • the field update can even datestamp each entry and you can put BR() after each entry so it looks like a proper log. Note in V31, you can have long text fields of 128K but at some point, you'll blow up the field and stop the logging – cropredy Sep 16 '14 at 1:27
  • This is a great way to keep basic history without blowing up data storage. Another drawback is that you can't run a report on this information. – Jeremy Nottingham Oct 14 '14 at 12:49

Use trigger and make a string variable . each priority value concatenate with previous value and update in text area field .

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.