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?
You can do it by using this formula to calculate the time till the meeting:
And then you can trigger Zapier like so - “if [formula 1] = 1, send email”