Help

Sending Meeting Reminders to Clients

Topic Labels: Formulas
823 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeana_Rushton
4 - Data Explorer
4 - Data Explorer

Hello! On my website we offer consultations and have just switched to booking those through airtable to get exactly the information we need in the initial form imported directly to a base. What I would like to do is have a date field that is set up to calculate what 1 hour prior to the meeting is so I can have Zapier send an email reminder to my clients. Is this possible?

1 Reply 1
Chen_Pro
6 - Interface Innovator
6 - Interface Innovator

Hi there,

You can do it by using this formula to calculate the time till the meeting:
DATETIME_DIFF(NOW(),{Date})/3600

And then you can trigger Zapier like so - “if [formula 1] = 1, send email”

date