+ Start a Discussion

History Tracking a Formula Field Workaround

Hello All,


I created a custom field (formula) in my opportunity layout that essentially captures the value of the opportunity products.  I want to track the history of this field every time a sales rep updates the opportunity product's quantity or price.  Unfortunately, history tracking does not support formula fields.  Is there a way to create a static custom field (number) and have a trigger populate this field every time a rep updates this field?  Any suggestions would be greatly appreciated!




You need to create a custom text field and a workflow rule as well. Workflow will update this field every time when a record is created or updated.


Hope this helps.