Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 05, 2021 02:53 AM
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
Mar 07, 2021 01:59 AM
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.
Jan 12, 2022 09:59 AM
Thank you for your reply, Databaser.
Could you please elaborate on how to create a formula field to check if a date is due?
Jan 12, 2022 11:56 PM
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.