Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do I make a trigger I created repeat daily?

Topic Labels: Automations
278 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello AT community,

I create a trigger to email relevant parties when a record’s date is overdue but can’t seem to find how I can make the trigger repeat daily - that is, as long as the overdue date is unchanged and remains before today, I’d like to continue receiving email notifications on a daily basis.

Your help would be greatly appreciated.

Big thanks,
Roy

2 Replies 2
  1. Add a formula field that just gives today’s date: TODAY()
  2. Add a date field named {Date Last Email Sent} (or whatever)
  3. Adjust the condition of your Automation to also check for {Date Last Email Sent} is not “today”
  4. Add an Update Record action step to copy the value of the formula field into the {Date Last Email Sent} field.

how were you able to create a Trigger to email relevant parties when a record’s date is overdue?