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?
Page 1 / 1
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 fformula 1] = 1, send email”
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.