-
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.
-
1 Reply
-
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.
Log In to reply.
