Feb 08, 2024 05:47 AM
Hello Everyone,
Basically I have got a table with documents sign date and expiry date, and created a formula when it shows that the document is "Active" or "Expired" if the date is in the past.
The question is how to create an automation so whenever formula changes to expired it will send an email telling a person that the document is now expired.
Hope that makes sense.
Thanks
Feb 08, 2024 07:10 AM
I would use the 'When Record matches conditions' Trigger, and choose your formula field, stating when the record matches 'Expired' to send the email.
Feb 08, 2024 07:11 AM
Hmm, what issues did you face attempting to use the "When record matches conditions" trigger? It seems like if you set it to look for records where the formula field is "Expired", it would trigger as expected, and you could add an email action to it afterwards?