Hey all! I have a question. I am building a ZAP that goes from JotForm to Google Sheet. It’s for a client who owns a ski rental company. The JotForm allows for up to 10 users (renters). When the ZAP is triggered is provides all the info in one row of a spreadsheet. The client needs the info to be delivered so that each user has their own row. How do I tell Zapier to seperate each user and create a new row for each user?
Question
How do I split Jotform responses into separate rows in Google Sheets?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
That depends on how the data is returned from Jotform for each of the 10 users (renters).
Can you post screenshots showing how the data is returned from the Jotform Zap trigger step for the users info?
Hi
That depends on how the data is returned from Jotform for each of the 10 users (renters).
Can you post screenshots showing how the data is returned from the Jotform Zap trigger step for the users info?
Hey
Sorry, can you please explain “returned” for me? I am not sure what you are looking for?
+14- Zapier Orchestrator & Solution Partner
Test the Zap trigger step.
Show screenshots of the returned data.
This is what the client wants:
RES is the primary contact info for the reservation holder and user are the various people in their group.
+14- Zapier Orchestrator & Solution Partner
From the Jotfrom Zap step DATA OUT, it appears that each User has their own set of fields. (e.g. User 1)
One approach is to use a separate GSheet Create Row step for each User via Paths.
Each Path has a Filter that you can set conditions to make sure a User’s info exists from Jotform.
So you would have 10 Paths in your case, 1 for each possible User.
+14- Zapier Orchestrator & Solution Partner
If you need help, consider hiring a Certified Zapier Expert (like myself): https://zapier.com/experts
If I go the paths route vs line item route, will users who do not exist still get flooded over to Sheet? For example, if I create 10 paths, and the client only enters 4 users (renters) will the Sheet still fill the remaining rows with blank info?
+14- Zapier Orchestrator & Solution Partner
Not if the Zap step logic is configured correctly.
e.g. Path 5 should only proceed if there is Data for User 5, which those conditions can be set to check in the Path 5 Filter.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.