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.

Help Setting up Email Reminder Automations

Topic Labels: Automations
157 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Ultimately what I am trying to do is to have airtable generate an email reminder both 5 and 3 days before a task is due that has been created within a field in a base. For example, I have a TO DO field within a base in which tasks are entered along with DUE DATES. I’d like for REMINDERS to be able to be TRIGGERED to send out both 5 and 3 days BEFORE the DUE DATE for each entry as needed.

So far, I have tried to follow the directions in the link below:

but am not able to get past the “Add a formula/Configure an automation/Choose a trigger” portion of the tutorial.

1 Reply 1

Hi @Regaye_Fulcher, I would use a DATETIME_DIFF() formula which is comparing between the due date and NOW() in days. If the number equals 5 or 3, it triggers a certain automation.

DATETIME_DIFF({DueDate}, NOW(), 'days')