Custom reminder trigger

Hi all, wondering if anyone can help me out here.

I am tracking some data which is time-sensitive and set up a trigger following Airtable’s recommended steps but I would like to customize it further by having the reminders triggered within 30 days before the due date.

For example - if the item is due on 1 May, I would like the reminder to be triggered in April.

How could I modify the formula?

For reference, this is the existing formula as recommended by Airtable:

IF(
AND(
{Due Date},
NOW() >= {Due Date}
),
“Trigger Reminder”
)

Thank you! Any help would be greatly appreciated.

MODIFY FORMULA to read
NOW()>= {Due Date}-14
for 2 weeks earlier

Thank you so much!! This is great, works perfect!

Welcome to the community, @Ron_Clark! :smiley: Unfortunately subtracting a number from a date as you indicated doesn’t produce a valid date.

Screen Shot 2021-04-03 at 6.13.01 AM

Screen Shot 2021-04-03 at 6.19.49 AM

The correct way to modify dates is by using the DATEADD() function. The original formula altered to use this would be:

IF(
  AND(
    {Due Date},
    NOW() >= DATEADD({Due Date}, -14, "days")
  ),
  "Trigger Reminder"
)

Unfortunately this will still produce an error if the {Due Date} field is empty.

Screen Shot 2021-04-03 at 6.21.44 AM

You’ll need to check for a date first, then do the date comparison only if that date exists.

IF(
  {Due Date},
  IF(
    NOW() >= DATEADD({Due Date}, -14, "days"),
    "Trigger Reminder"
  )
)

Screen Shot 2021-04-03 at 6.23.07 AM

1 Like

Thanks Justin! I found this really insightful. I took Ron’s original suggestion and used it with Date Add so it worked great for me.

I like what you showed and plan to use it!

1 Like