- felmirandaAsked 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
- JotForm SupportdavidAnswered on August 28, 2014 at 12:04 PM
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!
- felmirandaAnswered on August 28, 2014 at 12:11 PM
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,
- JotForm SupportBDAVIDAnswered on August 28, 2014 at 01:42 PM
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.
- felmirandaAnswered on August 28, 2014 at 02:13 PM
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.
- JotForm SupportdavidAnswered on August 28, 2014 at 02:19 PM
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.
- organicarableAnswered on May 12, 2015 at 04:53 AM
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
- JotForm SupportMike_GAnswered on May 12, 2015 at 10:02 AM
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