-
alejmanAsked on April 26, 2017 at 4: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 -
Kevin Support Team LeadReplied 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.
-
alejmanReplied 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 LeadReplied 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.