Help

Re: Repeating Follow-Up Emails

Solved
Jump to Solution
423 0
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.