Help

Create Email Automation that goes out at cheduled time

215 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AirtableNoob89
4 - Data Explorer
4 - Data Explorer

Hi All

I am looking to create an email automation where an email is sent out 30 minutes before the schedule meeting time. I have created a Date field that displays the date and time and named it Meeting Time. I'd like the email to be sent out 30 minutes before the Meeting Time. 

So far I have set up the automation to trigger when the record is updated and set the conditions as if Meeting time is Today but I don't know how to set a condition for the time. 

Is this possible?

 

1 Reply 1

Yes,

You can start Automation with "When record enters a view"

Greg_F_0-1673681956361.png



Than create an extra column with formula checking if it is yet the time when to send email? 

Greg_F_2-1673682266474.png

If 1 then yes, if 0 then no, 

Greg_F_3-1673682330854.png

 

Based on the above you can create view that filter out only "1"s . When a new row enters - this will trigger automation.

Note that from empirical testing it is not accurate exactly to a minute, so it might 1-3 min later.

If you really need 100% on time alert -> pushing dates to Google Calendar might be most visible solution.

Let me know if that helps?