Hello all,
Is there a way in automation to set the trigger based on a date in a field?
I’m trying to set Airtable to send a message to Slack when a Date in a field is due.
Thanks
Automation Based On Date
+25Hi @aalbadah and welcome to the community!
You can use a date field in the trigger “when a record matches conditions”, but in your case, since the trigger won’t be a specific date but the fact that it is due today, I would use a formula field that checks if a date is due. You could use that field to trigger your automation.
Hi @aalbadah and welcome to the community!
You can use a date field in the trigger “when a record matches conditions”, but in your case, since the trigger won’t be a specific date but the fact that it is due today, I would use a formula field that checks if a date is due. You could use that field to trigger your automation.
Thank you for your reply, Databaser.
Could you please elaborate on how to create a formula field to check if a date is due?
+25Thank you for your reply, Databaser.
Could you please elaborate on how to create a formula field to check if a date is due?
The formula would be:
IF({due date}=TODAY(), "this is due today!")
More info for the automation here.
Trigger: “when a record matches conditions”
Overview of actions here.
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.