- April 30, 2016 at 8:14 am #10795Nitish #341
Using formula field in workflow rule action
Using formula field in workflow rule when the value of formula field is changed want to trigger workflow rule but workflow does not fire when the value of field is change. Please help.April 30, 2016 at 9:38 am #10826Ravi #380
Workflow doesn’t fire on formula fields, as the field isn’t stored in the database and so doesn’t get updated. What happens is when you retrieve the record, the value is calculated and the field populated.
There’s a couple of ways around this:
(1) Don’t use a formula field, but use a regular field and a workflow field update that replicates the formula. That way the field will be stored in the database.
(2) Replicate the formula in your workflow rule and fire it every time a record is created or edited.
Please Register to reply to this topic. /