Configurable List widget: Generated report format

  • rempe9925
    Asked on December 5, 2016 at 10:15 AM

    Hi

    I create a form that works really well but now need to find a way to create a report on some specific fields and need to know how to do that. 

    As you will see in the attached screenshot and URL, the "order details" section is what i'm after. It's critical that i am able to sort my order details data by "language", as well as "device type". How can i go about that? currently, it mashes all the data together in a continuous cell, but i need to find a way to do it in a clean reporting format. 


    Thanks

    Jotform Thread 1003898 Screenshot
  • Jan
    Replied on December 5, 2016 at 3:46 PM

    Unfortunately, the Grid Report or the HTML Table Listing report will show the data of the Configurable List widget in one column only. Inside the column, there's another table that divides the data properly.

    If you integrate the form to Google Spreadsheet, here's how it looks like:

    Configurable List widget: Generated report format Image 1 Screenshot 30

    If you exported the submissions in Excel file, here's how it looks like:

    Configurable List widget: Generated report format Image 2 Screenshot 41

     

    If you want to split it up into multiple columns/cell, please try using the Text-to-Columns function in MS Excel. Here's a related link: https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7.

    Hope that helps. Thank you.

  • rempe9925
    Replied on December 5, 2016 at 3:52 PM

    thank you very much. The link for excel will help!!

  • Jan
    Replied on December 5, 2016 at 5:21 PM

    Glad to hear that. Let us know if you need further assistance. Thank you.