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.
Im having problems with the data once downloaded.Asked by felmiranda on August 28, 2014 at 10:52 AM
Im having problems with the data once downloaded. Very hard to work out to do some analysis. Each entry stays within a column, including titles. Is there any way to fix this?. It would be very valuable.
This is a re-post of a comment on How to Set Up the Configurable List Widget
I am unsure what you are having trouble with. I looked for a configurable list widget in your most recent form and was unable to find one. If you are trying to line up the fields in your form to rows instead of columns:
If you are trying to accomplish something else, please let us know a bit more detail and we will be happy to help.
Thank you for using JotForm!
I guess i did not explain myself correctly. Kindly take a look at this report and look the "N" Column called "Cantidades por local".
All the entries coming from the configurable list at this form http://form.jotformz.com/form/42386710124651 are store in the N column, different from other multiple fields widgets.
The configurable list is the only one the allows me to add within a line a dropdown and a text field. am i correct? Because thats what i need plus being able to have a bit ordered the data on the excel reports.
Thanks and regards,
I checked your Excel report, and yes, I am pretty sure this how all the entries coming from the Configurable List widget should be stored(In the same column):
I have noticed you have removed the Configurable List widget from the form you shared, since I cloned your form ,and did a test submission, so this is how it will be stored when downloaded as Excel:
So, I am guessing you sorted it out aligning the DropDown with the TextBox fields using Field Positioning.
You are right, i did align the dropdown and textbox fields using field positioning. It works fine, but it has the constraint that i only can add as many items as i have in the form, different from the configurable list that allows me to keep adding items which is what i need, but if the reports shows me the items within one column will not work for me.
Is there any workarround regarding the report format using configurable list?
Now i added it again in the form, to test.
Unfortunately the configurable list is treated as a single field when it comes to reports. It is not possible to separate out the data from individual fields within the widget. In reports it will always treat the widget data as one large entry.
I have found the reporting of configurable forms a problem too. They are a great widget apart from this weakness. I would recommend it as an improvement if possible.possible I would suggest that it would be useful to explain this limitation on the notes about using the widget so others don't also get disappointed.
If this is not
I have moved your concern to a new thread that you may be able to follow via this link: http://www.jotform.com/answers/568314