- aspirebrokersAsked 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.
- JotForm SupportJanAnswered on April 12, 2016 at 09:17 AM
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.
- aspirebrokersAnswered on April 12, 2016 at 03:45 PMYes I know that. The data that comes out is in a particular format. What is
this format called?
- JotForm SupportBJoannaAnswered on April 12, 2016 at 04:20 PM
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/
- aspirebrokersAnswered on April 12, 2016 at 04:54 PM
Thanks. FYI I came up with a solution that works for what I want in Google Sheets.
- JotForm SupportBJoannaAnswered on April 12, 2016 at 04:58 PM
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.
- aspirebrokersAnswered on April 14, 2016 at 05:39 PM
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
- JotForm SupportChriistianAnswered on April 14, 2016 at 10:17 PM
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. :)