Skip to main content

Hi all,

I have an automations question that I hope someone can help me with.

My company provides a programming service for clients. As we process the information received, Airtable sends an automatic email to the client letting them know what information we have and what we still need.

When record is updated, send email to client.

This is fairly simple and works well, however, we have employees who work at night or over weekends and do not  want emails going out to clients at funny times. Setting up the automation to trigger at a schedule time does not work because then I do not have the option of formatting the email based on specific record conditions. I would love to be able to have something check if it's during regular work hours, if so send the email, and if not, wait until the next regular business day and then send the email.

Any advice on how to implement this?

Hm, what if you created a new field called "Email sent" or something, and the automation setup would be:
1. Trigger at a scheduled time 
2. "Find Record" step that meets the conditions you want and also "Email sent" is empty
3. Repeating group that sends an email per found record and updates the "Email sent" field to be "Done"  

Hey @at-com 

Sounds like the goal is to delay email notifications from Airtable until regular work hours to prevent late or weekend emails to clients. Here’s how I'd approach it:

Using a combination of Airtable’s automation with a Make.com scenario, I’d set a “buffer” that checks if it’s business hours. If the condition isn’t met, the email automation is paused until the next workday. This allows you to retain email formatting based on specific record conditions while automating the timing to avoid off-hour emails.

Hm, what if you created a new field called "Email sent" or something, and the automation setup would be:
1. Trigger at a scheduled time 
2. "Find Record" step that meets the conditions you want and also "Email sent" is empty
3. Repeating group that sends an email per found record and updates the "Email sent" field to be "Done"  


Depending on whether multiple emails need to be sent, it might be better to reverse the flag. Instead of "Email sent" it could be "Send Email" so that if ✅ then send email and then uncheck after email has been sent.

Hi all,

Thank you for all the replies. In the end I created a field 'send email on next business day' that automatically gets checked when the requirements for the email are sent. I then did a scheduled email for every morning to email the clients whose checkboxes are checked off. The last step of the automation is to uncheck the box so they don't get the email again the next day.

And just think, all it would take is one simple function between, for example, "When a record is created" to add a "Delay" option symbolized by a clock, and then "Send email". And all our problems with sending delayed messages or SMS would be solved.

1. When a record is created
2. Delay (for example 10 minutes)
3. Send email / run script / Twilio 

 

Reply


Terms & Conditions