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
+14
Hi
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
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
+14
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
