Sep 17, 2021 10:33 AM
I am using my base to manage inspections. I would like to create an automation that if a record was modified after my last inspection than I get an email sent etc. Both dates are part of one table. I am trying to use a condition if the record is on or after… My choices are only a static date but I don’t see how to use a dynamic option. Any workarounds?
Sep 17, 2021 01:01 PM
Could you please give me the name of the two date fields?
Sep 17, 2021 01:18 PM
Thanks! And you want to send an e-mail if Last Modified
was after last visit date
?
Sep 17, 2021 01:25 PM
Since the automation doesn’t seem to allow dynamic dates, I’d add a new formula field with:
IF(IS_AFTER({Last Modified}, {Last visit date}), "Yes", "No")
Then you can base the automation on that.
Sep 30, 2021 09:41 AM
Thank you for your help!