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

    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.

    Thanks.



    This is a re-post of a comment on How to Set Up the Configurable List Widget

    thanks
  • Profile Image
    JotForm Support

    Answered by david on August 28, 2014 at 12:04 PM

    Hi,

    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:

    http://www.jotform.com/help/90-Form-Field-Positioning

    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!

  • Profile Image

    Answered by felmiranda on August 28, 2014 at 12:11 PM

    Hi, 

    I guess i did not explain myself correctly. Kindly take a look at this report and look the "N" Column called "Cantidades por local".

    http://www.jotform.com/excel/42386568884069

     

    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, 

  • Profile Image
    JotForm Support

    Answered by BDAVID 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.

  • Profile Image

    Answered by felmiranda 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.

    http://form.jotformz.com/form/42386710124651

     

    Regards, 

  • Profile Image
    JotForm Support

    Answered by david on August 28, 2014 at 02:19 PM

    Hi,

    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.  

  • Profile Image

    Answered by organicarable on May 12, 2015 at 04:53 AM

    I h

    ave 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.

    If this is not

    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.

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by Mike_G on May 12, 2015 at 10:02 AM

    @organicarable

    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

    Thank you.