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

[TechSupport]

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

[TheTimeSavingCo]

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