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.

  • Home
  • Get Help
  • How Do I
  • How can I create a Zap to link a completed JotForm to a specific Google Sheets cell?

Morning all!

i would like to create a zap that links a JotForm that a client complete to an entry in a gsheet cell.

 

i am a dogminder and walker. Owner complete form for little Poppy to be walked 4 April.

A Zap will add the name Poppy in the next available cell in the tow for the 4 April. (Green one)

i can book up to 4 dogs.

 

hope the image helps 😁

 

JOTFORM that client completes is here: https://form.jotform.com/233300649556861


thanks for your time and help! R

Hi @Resi 

There are some limitations to be aware of.

Column A in the GSheet must can NOT be hidden.

Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

You would have to add logic in the Zap to find the existing row, then determine how many spots are currently filled (0-4), to then determine which column to fill in.

 

You would also need to build in logic if there are already 4 spots filled for a day, and how you want to handle that.

Thank you @Troy Tessalone 

great advice. Not a problem to unhide ColumnA.

i looked at the link you shared and I am a bit confused as I can’t find what I think I am looking  for. 
 

i don’t get huge numbers of bookings so at this stage I won’t worry if we get more then 4 entries.

would you be able to suggest a way forward on the logic I might need to incorporate in the zap? Ian not sure how to proceed from here.

thanks! R 

@Resi 

The logic likely would involve Code or a complex formula to determine which column to fill.

If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts

 

An alternative approach is to use Airtable and create a relational database with availability slots and logic that won’t let someone select an availability slot if it is full.

Terms & Conditions