function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
dxfilo@mac.comdxfilo@mac.com 

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!

 

Thanks

Pradeep_NavatarPradeep_Navatar

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.