Automation Based On Date

[aalbadah]

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

[Databaser]

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.

[Amelia_Waters]

Thank you for your reply, Databaser.

Could you please elaborate on how to create a formula field to check if a date is due?

[Databaser]

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.