Configurable list widget data format

  • Profile Image
    aspirebrokers
    Asked on April 12, 2016 at 07:00 AM

    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 

  • Profile Image
    Jan
    Answered 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.

  • Profile Image
    aspirebrokers
    Answered on April 12, 2016 at 03:45 PM
    Yes I know that. The data that comes out is in a particular format. What is
    this format called?
    ...
  • Profile Image
    BJoanna
    Answered 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/ 

  • Profile Image
    aspirebrokers
    Answered 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.

     

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

     

  • Profile Image
    BJoanna
    Answered 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. 

  • Profile Image
    aspirebrokers
    Answered on April 14, 2016 at 05:39 PM

    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

  • Profile Image
    Chriistian
    Answered 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. :)