About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

  • 1 February 2024
  • 3 replies
  • 31 views
G
Userlevel 1

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??

icon

Best answer by garyluk7 1 February 2024, 22:05

View original

3 replies

G
Userlevel 1

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

ken.a
Userlevel 7
Badge +6

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! ⚡️

J

Temukan RTP tertinggi dan sensasi kemenangan yang luar biasa hanya di Jos77! Di sini, Anda akan menemukan koleksi slot dengan tingkat pengembalian (RTP) tertinggi yang siap memberikan pengalaman bermain yang memuaskan. Jangan ragu lagi, gaskan dan coba sendiri keseruan bermain di Jos77 sekarang!
 

Reply


Terms & Conditions