Jot form to spreadsheet mapping issue

How To
4

Hello @Hany,
Read this very carefully.

JotForm Response Structure

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.
  • Check for the get() function should be used there to get specific values from the array. https://www.make.com/en/help/functions/general-functions#get--object-or-array--path-
  • Then use Create Row in Google Sheets and map those variables directly into a specific field.

I hope this will work for you.

:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution and :+1:
Need expert help or have questions? Contact or comment below! :point_down: