
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 07, 2022 08:56 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 07, 2022 09:39 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 07, 2022 09:39 PM
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.
