Help

Send an email when a record has not been updated for x amount of time.

574 1
cancel
Showing results for 
Search instead for 
Did you mean: 
TechSupport
4 - Data Explorer
4 - Data Explorer

Hi guys,

Hope you are well.

I am trying to create an automation where I can get a notification when a record has not been updated for x amount of time.

Is this something I can do in Airtable? I need to keep a list of items up to date, and I am not sure if this is something I can do.

Hope it makes sense,

Thanks,

TS

1 Reply 1

Yeap it is.  There's a "Last Modified Time" field you can use, and you can add a formula field that can calculate how long it's been since it was updated with `DATETIME_DIFF()` and `NOW()`.

After that, you'll just need to use `IF()` to set up how long is too long, and output something like "Send email" once it's too long.

You'd then have an automation that'd trigger whenever a record had "Send email" in the previously mentioned field