I'm using configurable list and the way data is inputted into excel isn't working for my reporting. Is there another way to get this data to export?

  • alejman
    Asked on April 26, 2017 at 4:36 PM

    Im using configurable list and the way data is inputted into excel isnt working for my reporting Screenshot 20

    The above snapshot is what my form looks like.  When I have multiple lines, the information gets put into one cell in excel.  I can text to column this but multiple lines get lost.  Is there a way that I can export the data differently so that I can have each row above go into it's own row in excel?

  • Kevin Support Team Lead
    Replied on April 26, 2017 at 6:10 PM

    Unfortunately, there is not way to get the info from the widget to be split in different cells. 

    Also, due to the widget's nature, will not be possible to have such feature implemented at the time, widgets work in a different way compared to basic fields, they basically are loaded on their own page inside the JotForm form. 

    If you would like to split the info in different cells, then you would need to replace the widget with basic fields, you could ask your user if a new record will be entered and then show the needed set of fields. 

    This guide will help you to show/hide fields based on user's answers: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer 

    Hope this helps. 

  • alejman
    Replied on April 26, 2017 at 7:03 PM

    Thanks for the response.  I'm using this to track items on orders.  The number of lines can vary by order.  Is there a clean way to ask "how many lines are being received".  Depending on the answer, I will duplicate the basic questions that many times.

  • Kevin Support Team Lead
    Replied on April 26, 2017 at 7:52 PM

    Yes, but you will need to add the questions in the form builder, then you could ask the submitter if a new line will be added, based on the answer you show then the next line of fields. 

    The guide I shared above will also help you to achieve it. 

    Here's an example about how it would work: 

    https://form.jotformpro.com/71157115580957 

    Feel free to clone it.

    How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.