I have an automation that conditionally sends a Slack message when a record enters a view and matches a particular datetime field. The conditional action editor only allows me to select a date to match, but I need it to be more granular, such as the datetime field is prior to 6 hours ago. Is there a reason Airtable is so klunky and only allows to match on the date?
Conditional automations can only match datetime fields on date, not time!
+35I would create a formula in your database that results in a value “Yes” or “1” if the date time field is prior to 6 hours ago. Then use that formula field for your condition.
I would create a formula in your database that results in a value “Yes” or “1” if the date time field is prior to 6 hours ago. Then use that formula field for your condition.
@ScottWorld BRILLIANT! Thanks.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.