Today in this post i will explain you how you can get last modified value or previous value without using trigger
- Creating aText Field: Create aTEXT (255) field on the Object and name it say: Old Value
2. Setting up the Workflow Rule + Field Update
- Go toSetup | Create | Workflows & Approvals | Workflow Rules
- New Rule
- Select theObject
- ClickNext
- Evaluation Criteria:created and every time it’s edited
- Rule Criteria:formula evaluates tor true
- Fomula:
AND(ISCHANGED(Picklist_Field_c),NOT(ISBLANK(TEXT(Picklist_Field_c))))
OR
IF(ISCHANGED(Picklist_Field_c),True,False)
8. Click Save & Next
9. From underImmediate Workflow Actions, click Add Workflow Action to select Field Update
10. Select the Field to Update: Old Value
11. Select Use a Formula to Set the New Value
12. Formula:
TEXT(PRIORVALUE(Picklist_Field_C))
- Click Save
- Click Done
- Click Activate