Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Zapier tables not finding the correct line

G
Forum|alt.badge.img

I’m trying to do a search of line items in my table, when a new booking is created , then look for a previous booking that matches either the same start, or end time (therefore flagging it as a back to back booking)

For example, if there is Booking A 9:30pm to 10pm, and another Booking B at 10:30 - 11PM EST. 

Then suddenly a new booking C is created in between these 2 time slots of 10:00 - 10:30 EST.

 

My trigger is 

  1. when a new booking (booking C) is recorded on the table, 

Then

  1. search for record (output at line items)
  2. where the Start time of C is exactly the end time
  3. the output SHOULD be A, but it keeps showing both A & B, which in the line output becomes a mix of results and I cant parse it. 

 

How can I fix this??

Best answer by garyluk7Best answer by garyluk7

Nevermind! Tooks like making the tables column into a Text column rather than a date/time column was the fix.. 

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

2 replies

G
Forum|alt.badge.img
  • garyluk7Beginner
  • Author
  • Beginner
  • 1 reply
  • Answer
  • February 1, 2024

Nevermind! Tooks like making the tables column into a Text column rather than a date/time column was the fix.. 

ken.a
1 person likes this
  • ken.a
    ken.a
ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6491 replies
  • February 2, 2024

That’s awesome @garyluk7! I’m glad to hear you were able to get it sorted!

Also, thank you for sharing the solution here. This will be helpful to our other awesome Community members who might have a similar issue.

Happy Zapping! ⚡️

Reply


Terms & Conditions