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: Generated report format

    Asked by rempe9925 on December 05, 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

    Page URL:
    https://form.jotform.com/63354079149159

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Jan on December 05, 2016 at 03: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:

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

     

    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.

  • Profile Image

    Answered by rempe9925 on December 05, 2016 at 03:52 PM

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

  • Profile Image
    JotForm Support

    Answered by Jan on December 05, 2016 at 05:21 PM

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