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

    Excel report disposition

    Asked by jaures on August 25, 2013 at 06:57 AM

    In my form , i have ten lines with the same fields name. but when I pull out th report i get in excel sheet one column for one form field. this not easy for my stats.

    is it possible to have all data related to the same field name (ex. BL) under one column in excel?

     

    or how should i set my form to have the report like this?

     

    best regards

    Page URL:
    http://form.jotform.co/form/31734441549860

    Screenshot
    excel name form field one form
  • Profile Image
    JotForm Support

    Answered by jonathan on August 25, 2013 at 07:45 AM

    Hi,

    The submission data will always determine the uniqueness of the field base on its field id number.

    So, even if you have 10 fields of the same label/name, the submission data result for fields will be 10 times also. Since the fields are unique the Reports will be able to reflect this.

    You may want to try my suggested workaround.

    1. Use a repeating form instead of repeating the fields 10x. Test this form to see what I meant

    http://www.jotformpro.com/form/32363082982962

    When you submit this form, there is a link in the Thank you page that will allow the re-submission of the form with same value for TRANSITAIRE.

    2. You need to give unique label/name to the BL fields, and just use auto filter funciton in your Excel reader.

    Hope this help. Inform us if you need further assistance.

    Thanks.

     

     

  • Profile Image

    Answered by jaures on August 25, 2013 at 11:48 AM
    FAIR.
    but the issue here is that the clients can submit 8 documents informations in the form. If I aplly what you describe, he will be obliged to get 8 ticket numbers instead of one
  • Profile Image
    JotForm Support

    Answered by Welvin on August 25, 2013 at 03:44 PM

    Hi,

    You may want to consider disabling the other BL fields so that they cannot put any entries. Right Click to the field > Find "Read Only" section and set to "YES":

    This should prevent BL Numbers to be submitted multiple times from a single person for his/her single submission. But still, it has the same output when exporting to Excel - columns will be created.

    This should work for your purpose, unless one single person will submit to your form multiple times. Let us know if you need any further assistance.

    Thanks