For context, I am building an email automation that is sent every work day (Monday-Friday). The email would display any of the task records that are due on that particular day that the email is sent out.
My problem is that Airtable's scheduling timing trigger is limited to posting every single day. I would not like to send out an email on the weekend.
I cannot use "When a record is updated" as a trigger as it would send an email for every single task record that is due today, whereas I am trying to send only one email a day.
I would appreciate any suggestions, thanks!