Hello,
I have a parent table called projects and a field called "status." The status field updates based on if the project is on track and can change from on-time to late.
I want to generate an e-mail notification when the formula field changes the status to late. Is that possible?
I've tried to use the modified action but it only seems to work when someone manually changes the field vs a formula handling it.
Notifications only trigger when the record is updated. When a formula changes, the record is not technically updated. To make this work correctly, trigger the email based on the same thing the formula uses - ie whatever is changed in the project that triggers the status field to update (perhaps it is a date that is put in?).
The user must be doing something that ultimately changes the status formula, so trigger it off whatever that thing is the user does.
If it becomes late because it's a certain day (todays date is after date due), one option is to run a pipeline at say, 1am every morning and have it look for say 'Status = late and Due Date=Yesterday', and have it check a box that says 'Trigger Late Email Notification'. Then use that late box trigger. Or simply set up a reminder email.
