Skip to main content
Best answer

Send SMS 12 hours before time in Airtable Field

  • July 3, 2023
  • 1 reply
  • 16 views

Hello,
I need help with a zap.
There is a date/time field in an airtable table. 12 hours before the time of the field occurs, an SMS is to be sent with TextMagic.

How do I create the trigger that 12 hours before the time in the field the SMS will be sent?

Thanks! 

Kevin

Best answer by Troy Tessalone

Hi @KevinDax 

Good question.

Try this…

Add a formula field to Airtable to do the calculation between now and the timestamp.

Then use a Table View with Filter conditions as part of the Zap trigger step.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • July 3, 2023

Hi @KevinDax 

Good question.

Try this…

Add a formula field to Airtable to do the calculation between now and the timestamp.

Then use a Table View with Filter conditions as part of the Zap trigger step.