Sending Meeting Reminders to Clients

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?

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