Configurable list widget not exporting data into separate columns

  • Profile Image
    McGinnis_Michelle
    Asked on June 01, 2020 at 12:05 PM

    Hello. I am new to Jotform and have searched through your resources and can't find an answer to my question.  

    I have created a registration form and had people test it for me. When I export the data into any of the options you have, the data is not grouped as I expected it to be and want to know what I am doing wrong in my form.  I attached a screenshot as well as the link to my form. 

    Look at columns E, F and G. Those correspond with questions 2, 3 and 4 on my form that were created using a configurable list widget.  In column E for example, this is data for each child a parent is signing up for our program. I expected the data to show up in separate labeled columns and populated the same way, but it lumped all of the info in ONE cell and used the question as the column header. Did I do something wrong in the form creation? What can I do to see the data like I need to? I have the same issue with column F, G and H.

    Thanks,

    Michelle McGinnis

  • Profile Image
    Lorenz_A
    Answered on June 01, 2020 at 02:33 PM

    Unfortunately, the configurable list widget uses a single column by design. It is not possible to separate each configurable widget entries on a separate column in JotForm. 

    You can either separate them manually or use the split function in excel

    https://support.office.com/en-us/article/Split-names-by-using-the-Convert-Text-to-Columns-Wizard-39f7b055-6b39-4cb5-9512-13cc19b3a807

    https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

  • Profile Image
    Michelle McGinnis 
    Answered on June 01, 2020 at 02:39 PM

    Thank you for your quick response! Is there a different form element within Jotform that would do what I want? If so, can you suggest which one?

  • Profile Image
    Lorenz_A
    Answered on June 01, 2020 at 04:01 PM

    You can actually use basic form elements. But based on the form you created, I think using a configurable widget is more ideal since your users will have an option to enter multiple entries. 

    Instead of changing your element, maybe you might want to consider viewing the submissions using a grid report. Configurable list data looks nicer when rendered here. 

    Related guidehttps://www.jotform.com/help/105-How-to-Create-a-Grid-Listing-Report