+ Start a Discussion
ppiyushppiyush 

How to detect changes in formula field value?

Hello!

 

I am trying to figure out a way through which I could trigger a workflow based on the value contained inside a formula field. I obviously can create a normal workflow, but that would allow me only to check the value at the instance when a record is created or edited. Is there any way of doing it EVERY time the value of a particular field changes?

 

Look forward to some encouraging solutions.

 

Best,

Pranav

SurekaSureka

Hi,

 

As of now, I could think of doing by Apex Triggers. Below is the sample code:

 

trigger CheckFormual on Account (before insert, before update) 
{
for(Account a:Trigger.new)
{
if(system.trigger.OldMap.get(a.Id).FormulaFeild__c != system.trigger.NewMap.get(a.Id).FormulaFeild__c)
{
a.AnotherFeild__c = a.FormulaFeild__c;
}
}
}

 

In the above code, whenever there is a change in the formula feild I am populating that value to another feild. Likewise you can track.

 

 

Hope this helps.

 

Thanks

AshishGargAshishGarg

hi sureka,

 

 

could you please help me to write the test class for this trigger. thanks