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.


  • Profile Image

    Configurable list widget data format

    Asked by aspirebrokers 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 

    configurable list list widget configurable jpg format
  • Profile Image
    JotForm Support

    Answered by Jan 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

    Answered by aspirebrokers 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
    JotForm Support

    Answered by BJoanna 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

    Answered by aspirebrokers 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
    JotForm Support

    Answered by BJoanna 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

    Answered by aspirebrokers 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
    JotForm Support

    Answered by Chriistian 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. :)