1

I need to send a email notification when a formula field changes except for the first time.

I have a workflow rule setup to evaluate every time the record is changed and setup rule criteria "ISCHANGED(field name).

what is the best way i can implement to avoid the first time email alert.

Improve this question

1 Answer 1

Reset to default
1

This is not possible. Formula fields have no stored value - their values are calculated at the time of accessing the data. There is no change event to which you can react for formula fields.

You'd need to build your automation to react to changes to the fields that themselves drive the value of your formula field.

You could potentially implement "ignoring the first change" by setting a checkbox field on the object the first time your automation is invoked. Then, send your notifications only when the field is true.

Improve this answer
1
  • Instead i used a Workflow rule to update the total on the field. Now its just a Number field.
    – Samuel Jackson
    Jan 6, 2020 at 20:38

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .