Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jan 13, 2020 09:28 PM
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?
Jan 14, 2020 03:58 AM
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”