I am using airtable as CRM with all leads being managed and assigned via airtable.
One of the main challenge I have is that a lot of the Sales team are missing their appointments (Whenever a lead come to the system, it comes with the best date and time to call)
I want to create a reminder and email notification to be send to the sales team 10 minutes before each appointment so they can call the customer on time
How can i create such column with 0 or 1
Whenever the time of appointment is 10 minutes earlier to the current time it turns into 1
then i can create a view with filter for all the value of (1)
And finally i can create a zap for each new record on that particular view (I can take care of it afterward)
Is that possible?
If yes, then how?
Thanks in advance for your support and collaboration.