Help

Re: Automate if last modified is after another date field

1170 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Yaakov_Zehnwirt
4 - Data Explorer
4 - Data Explorer

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?

4 Replies 4
Per_Carlen
7 - App Architect
7 - App Architect

Could you please give me the name of the two date fields?

Per_Carlen
7 - App Architect
7 - App Architect

Thanks! And you want to send an e-mail if Last Modified was after last visit date?

Per_Carlen
7 - App Architect
7 - App Architect

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.

Yaakov_Zehnwirt
4 - Data Explorer
4 - Data Explorer

Thank you for your help!