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.

  • Home
  • Get Help
  • How Do I
  • How do I map TidyCal form fields in Zapier to ensure data matches regardless of question order?
Question

How do I map TidyCal form fields in Zapier to ensure data matches regardless of question order?

  • 11 April 2024
  • 1 reply
  • 21 views
E

We are using https://tidycal.com/ as our online booking calendar. The calendar comes with a form of pre-selected questions. However, it seems that TidyCal is handling this data in the order in which questions are answered - rather than each field having its own ID.

 

This becomes a problem in Zapier when, due to auto-correct and user behaviour, questions are not answered in order. Meaning, that when data is pulled through to Zapier, some of the data does not match up and some of our Zaps are unable to run.

 

I was wondering if there’s a way I can map these fields in Zapier so the correct field and data is called each time, regardless of which order the information is input.

 

Any help is greatly appreciated!

1 reply

ken.a
Userlevel 7
Badge +6

Hi there @Etaoin Shrdlu,

Welcome to the Community! 🎉

It looks like you’ve reached out to our Support Team about this and they replied today with a suggestion. I’ll share details of the suggestion here in case it’s helpful:

I'm taking a closer look here and I see what you mean. This is happening because of how the answers are structured when TidyCal sends it to Zapier. There isn't quite an easy way around this. 

The one potential workaround I can think of would be to have a Loop by Zapier step that goes through every single answer given in the form. In each iteration of the loop, you could check what the question is, and depending on that, have multiple Paths to save that data to either a Google Sheets or Tables by Zapier.

In other words, using either a Google Sheet or Table by Zapier, you can configure each column to be associated with a specific answer. When you iterate through each answer in a loop, you can assign the corresponding answer to the corresponding column. You can potentially create a Sub-Zap for this portion so that it's separate from your main Zap.

At the end, you can reference and use all the answers from the respective columns, using the booking_id field to pull the correct answers in either the Google Sheet or Table by Zapier.

This would be a bit of a complex set up and may take some trial and error. However, I believe it would be possible if you're looking to try it. Please don't hesitate to reach out again if you have any other questions. I'm happy to help as best as possible.

If you’ve got any questions regarding their suggestion it would be best to continue the conversation with them over email. If you can’t locate their reply I’d recommend searching your spam/junk folder or searching your inbox for any emails from zapier.com in case. Sometimes their emails can end up in the spam/junk folder by accident.

Thanks!

Reply


Terms & Conditions