function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JohnTaylorUKJohnTaylorUK 

Workflow or Formula ideas for Last chnaged field

Hi,

 

I am trying to build a formula or workflow on my object that will look at all the fields on the object and let me know which one was edited last.

 

History is enabled and does some on this work for me , but I have more than 20 fields that need tracking to let me know which one was changed.

 

Any ideas ?

 

Thanks guy

Ritesh AswaneyRitesh Aswaney

Probably have a field called LastChangedField of type text on your object of interest.


Have a workflow rule to fire on 'Each time a record is created/edited'.

 

In the field Updates, based on the ISCHANGED(field), set a value to the name of the changing field.  You could have as many field updates as fields tracked or just try and build the update into a formula in a single workflow field update

 

Logically, the value of the field we've created, at any time should tell you which field changed most recently.