- alejmanAsked 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:
- JotForm SupportKevin_GAnswered 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.
- alejmanAnswered 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.
- JotForm SupportKevin_GAnswered 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:
Feel free to clone it.
Hope this helps.