Help

Re: Email or text reminders as deadlines approach

1283 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sharyn_Bergman
4 - Data Explorer
4 - Data Explorer

Being very new to Airtable, I was wondering if there is a way to set up email or text alerts as deadlines are approaching. Thanks

2 Replies 2

Hi @Sharyn_Bergman - you can do with a combination of Airtable and Zapier.

In your base have a “Due Soon” field with a formula like this:

IF(DATETIME_DIFF({Due Date}, TODAY(), 'days') < 5, 'Due soon!')

i.e. if the difference between the due date and today is less than 5, show “Due soon!”:

Screenshot 2019-07-05 at 19.12.03.png

On the same table, create a view which shows just the due soon records (using a filter):

Screenshot 2019-07-05 at 19.13.36.png

Then, in Zapier, create send an email when a record is added to this view, i.e. when its due date is less than 5 days away.

Appreciate you are new to AT, so this might seem a bit involved at first glance (and uses another tool, Zapier), but have a look at this article in the help docs to guide you:

JB

Thanks Jonathan. I’m excited to explore!