Configurable list widget data format

Hi Guys,

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.

 

Thanks 

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.

 

=SPLIT(join(",",SPLIT(substitute(J14," ",""),Char(10))),",")

 

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:

=ARRAYFORMULA(IFERROR(REGEXEXTRACT(","&REGEXREPLACE(A2:A,"\n",","),"^"&REPT("\,[^,]*",COLUMN(OFFSET(A1,,,1,6))-1)&"\,([^,]*)")))

 

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. :)