Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Automation Based On Date

Topic Labels: Automations
519 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

3 Replies 3

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?

The formula would be:

IF({due date}=TODAY(), "this is due today!")

More info for the automation here.

Trigger: “when a record matches conditions
image

Overview of actions here.