What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Configurable list widget data formatAsked by aspirebrokers on April 12, 2016 at 07:00 AM
The data that comes out of the configurable list widget looks like this - http://snag.gy/i39pg.jpg
What is this data format called? I ask because I wan't to do a google search on how to work with it but don't know what to search for.
You are referring to the Configurable List widget. This widget allows you to define the various field types per column on the list in a matrix-type of layout. Here's an screen capture:
We have a guide on how to setup the widget, please refer to this link: How-to-Set-Up-the-Configurable-List-Widget
Let us know if you if you need further assistance. Thank you.
Yes I know that. The data that comes out is in a particular format. What is
this format called?
I do not know what is the name of that format. I am also not sure if that format has a name.
Data from configurable list will be shown in submissions, in multiple rows and columns, depending on number of fields and rows that are filled.
I am also not sure how to google search for this. I would suggest you to ask your question on Stack Overflow: http://stackoverflow.com/
Thanks. FYI I came up with a solution that works for what I want in Google Sheets.
I am glad to hear that you found solution, for your issue. Also thank you for sharing with us your solution.
Feel free to contact us if you have any other questions.
This formula will work as an array in google sheets:
REGEXREPLACE(A2:A is the column you are referencing
OFFSET(A1,,,1,6) = The last number identifies the number of columns that you want, in this case 6
Thank you for sharing this information with us. I will make sure to keep this in mind in case another user requires your formula. Cheers. :)