Sending Meeting Reminders to Clients

[Jeana_Rushton]

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?

[Chen_Pro]

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”