Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Repeating Follow-Up Emails

Topic Labels: Automations
Solved
Jump to Solution
924 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Drew_Nemer
8 - Airtable Astronomer
8 - Airtable Astronomer

On my AirTable, it sends out an email when a view updates because the view in question is made to track employee records that are past their respected due dates.

I would like an email to be sent out every Monday and Wednesday to the specific employee/collaborator, alerting them to follow-up on the past dues–until they no longer appear on the list.

How can I do that?

Drew

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Drew_Nemer ,

You have to add a formula field and make the view filter on this field as well if not empty. The formula would be something like this

IF(OR(WEEKDAY(TODAY())=1,WEEKDAY(TODAY())=3),“Trigger”)

Weekday 1 is Monday and Weekday 3 is Wednesday (Sunday is Zero)

Hope this helps.

See Solution in Thread

1 Reply 1
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Drew_Nemer ,

You have to add a formula field and make the view filter on this field as well if not empty. The formula would be something like this

IF(OR(WEEKDAY(TODAY())=1,WEEKDAY(TODAY())=3),“Trigger”)

Weekday 1 is Monday and Weekday 3 is Wednesday (Sunday is Zero)

Hope this helps.