Mar 09, 2023
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,
Mar 10, 2023
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