Unable to map the bundle items “Name” & “Phone number” out of my jotform and into a google spread sheet.
I’ve created a Jotform “Get form submission” trigger, and in the configuration prompt for the module I connected it to my Jotform API and chose the correct File ID to the form I went to extract data from. I ran this module only and I can see the data/items from bundle being produced correctly. So far so good. I then created a google spreadsheet on my google drive named the headers in Columns “A” & “B”, as “Name”, & “Number” respectively. went back to the Make scenario builder/editer and created a google spreadsheet “Add a row” Module. I then connected it to the Jotform trigger and mapped the bundle item “Name” from the Jotform module to the header “Name” in the spreadsheet module. I’ve done the same and mapped the “Phone number”. I ran the scenario as intended but unfortunately the items don’t populate in the spreadsheet. Need help to resolve the issue.
Hello @Hany,
Most of the time these things are working fine.
Can you please share a screenshot of your implementation, data and output?
P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution and Need expert help or have questions? Contact or comment below!
In jotform response, inside the Answes collection, each element is a key with field names.
Then in that field name item, there are 2 elements of the array with 1(index) always the field name(used on JotForm) and 2(index) always the value of that field.
Field Type and Value Structure Difference
Different field has different field value structures for different types of fields.
As you can see the name has an array value of 2(index) first & last, but that participantContact has just a phone number in text only.
Current Implementation
Now as per your current field mapping on Google sheet. See this "Total number of bundles " = 2. That means there is more than one
Possible Solution
First, you need to combine those multiple bundles into an array using Array Aggregator.
Then use Iteration Module. Use that combined Array.
After iteration I recommend you to use “Set Multiple Variable Module”, and create each field as a separate variable.
Then use Create Row in Google Sheets and map those variables directly into a specific field.
I hope this will work for you.
P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution and Need expert help or have questions? Contact or comment below!
Sure,
Just share it and also add some of the input bundles in JSON(single or multiple) so that I can directly play around with it and share back my created blueprint.
Thanks for sharing your blueprint.
Please again see this very useful post of @samliew about how to share your scenario details. I appreciate most of the posts about detailing.
Let’s see if I can do it today otherwise do it tomorrow.
This is because the answers are in an array and you are mapping the array itself instead of values. + you do not need array aggregator and iterator here.
Let me describe the two methods of doing this.
If you want to get this automation run everytime the form is submitted and store that data in google sheet, then you can use “watch for submissions” module and can simply map the data from it as it doesn’t give array values.
If you want to run this automation once to get results from all previous submissions, then “get submissions” module is fine.
Here to work this, you need to use get() and map() function (according to need ) over the arrays of each answer.
Her’s an example containg answers where name array contains collection of first name and last name while fileUpload contains array of file urls:
Yes @Msquare_Automation, Thanks for sharing that.
You’re right when there is a direct trigger from a single-form response.
Then we don’t need to use Aggregator or Iterator directly using the Set Multiple Variable OR use Google Sheet module directly.
— P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution and Need expert help or have questions? Contact or comment below!
P.S.: Always search first, Check 
