Hi Lindsey. I don’t really do what you’re trying to do in my bases because the mods to the table to do it seem so clunky to me. I’ve tried to describe how I would attempt at the end. However, I like to have more control over emails going out, so I use a shortcut someone here came up with. You create a single select field that you use as a switch to send the email when you’re ready. For example, you have a “Send Email” selection that acts as your trigger for your automation. You need to add another action after the email action that resets your single select field to be empty. So that’s not so bad an option in the scheme of things.
Fully automated way:
You can do this with a formula field that calculates the difference between NOW() and last modified times (on the fields you’re currently watching in the automation). The formula will use IF(MIN(DATETIME_DIFF(NOW(),LAST_MODIFIED_TIME({Status}),‘m’), and so on for the other two fields)>some number of minutes,‘Email update’)
Then, you need a new view that filters on the formula field = ‘Email update’. Then your auto trigger becomes when record enters that view. The hard part is that some number of minutes threshold. Airtable doesn’t update formulas with NOW() as frequently as you think. Also, once the record enters the trigger view, you need it to be able to leave (formula field detects updates but still less minutes than threshold) as well. You might have to try something like 5-10 minutes.
