Help

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.

Sending Meeting Reminders to Clients

Topic Labels: Formulas
403 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 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 [formula 1] = 1, send email”

date