+4Hello 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
+19I would use the 'When Record matches conditions' Trigger, and choose your formula field, stating when the record matches 'Expired' to send the email.
+31Hmm, 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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.