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

    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?

    Asked by alejman on April 26, 2017 at 04:36 PM

    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?

    Page URL:
    https://form.jotform.us/70029013009139

  • Profile Image
    JotForm Support

    Answered by Kevin_G on April 26, 2017 at 06: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. 

  • Profile Image

    Answered by alejman on April 26, 2017 at 07: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.

  • Profile Image
    JotForm Support

    Answered by Kevin_G on April 26, 2017 at 07: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.