Skip to main content
Best answer

How to trigger a Zap to run based on date/time in Zapier tables?


I have a Zap that creates records for individual meetings from a booking platform. These are populated with a date/time when a reminder should be sent. This date/time can be changed, or the sending of the reminder can be cancelled, if the meeting is rescheduled or cancelled. 

 

I would like a separate Zap that triggers when the current date/time is equal to the date/time in my send time field.

Solutions I have considered

  • Meetings can be scheduled more than 30 days in advance, so the delay until step doesn’t work well.
  • Scheduled runs only run at minimum ever hour, and this is a 1 hour before reminder text, meaning every hour doesn’t work well.
  • Triggering off a code step that runs ~every minute that outputs the current date/time, and checks if any records on my table have send times in the past. This works well, but ran ~5000 times over 3 days, which is very run intensive and expensive.

Is there a better solution out there?

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi ​@bberntsen 

Have you tried using a View with filter conditions in Zapier Tables?

Views can be used to trigger Zaps.

Help: https://help.zapier.com/hc/en-us/articles/19097922477453-Create-views-in-Zapier-Tables

View original
Did this topic help you find an answer to your question?

3 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30887 replies
  • Answer
  • February 18, 2025

Hi ​@bberntsen 

Have you tried using a View with filter conditions in Zapier Tables?

Views can be used to trigger Zaps.

Help: https://help.zapier.com/hc/en-us/articles/19097922477453-Create-views-in-Zapier-Tables


  • Author
  • Beginner
  • 1 reply
  • February 21, 2025

Hey Troy,

 

That’s what I ended up going with. I had the view condition filter it in, and then set a delay step as my first step in the Zap. Appreciate your input!


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7414 replies
  • February 24, 2025

Sounds like a great approach, ​@bberntsen! 🎉 Glad you were able to get it sorted. And big thanks to ​@Troy Tessalone for the helpful suggestion! 🙌

Seems like you’re all set for now, but if you need help with anything else, feel free to reach out!