Help

Airtable Automation: Send an Email 1 Day From Now - What is the time of day?

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1119 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ethang
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there, 

I have an email automation that is set to send an email 1 day prior to an appointment date. 

The date conditions are simply based off of date, not time. 

Do you know what time the email should expect to trigger?

Thanks!

1 Solution

Accepted Solutions
AirOps
7 - App Architect
7 - App Architect

Hi Ethang, 

Your automation should send as soon as Airtable realizes it is a day prior to the appointment. It is likely your email will be send out at around midnight the day before an appointment. For example if the appointment is on July 28th, the email would trigger at roughly 12am on July 27th.

If this is undesired you can modify your trigger conditions to be of the type "At a Scheduled Time" and set it to trigger at a specific time each day. In the second step, you would use the "Find Records" action to search for all appointments that are happening the following day. You can then create a loop to go through all the found records and send individual reminder emails to all recipients.

Your automation would appear roughly as the image below: 

AirOps_0-1690489995891.png

I hope this helps! If you have any questions or need further clarification, please don't hesitate to ask.

Sincerely, 

Chantal 

See Solution in Thread

2 Replies 2
AirOps
7 - App Architect
7 - App Architect

Hi Ethang, 

Your automation should send as soon as Airtable realizes it is a day prior to the appointment. It is likely your email will be send out at around midnight the day before an appointment. For example if the appointment is on July 28th, the email would trigger at roughly 12am on July 27th.

If this is undesired you can modify your trigger conditions to be of the type "At a Scheduled Time" and set it to trigger at a specific time each day. In the second step, you would use the "Find Records" action to search for all appointments that are happening the following day. You can then create a loop to go through all the found records and send individual reminder emails to all recipients.

Your automation would appear roughly as the image below: 

AirOps_0-1690489995891.png

I hope this helps! If you have any questions or need further clarification, please don't hesitate to ask.

Sincerely, 

Chantal 

ethang
5 - Automation Enthusiast
5 - Automation Enthusiast

Great, recommendation! Going to test this one