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 is not displaying all questions.

    Asked by sisters7 on June 13, 2016 at 10:33 PM

    The last submission (June 13) contained 6 registrants. Since these 6 registrations were grouped together and submitted together, Only the first person showed up on the Excel report. I do need the other 5 on the spreadsheet too. What shall I do? The purpose for this group registration is for each family to send in one check. Please help. I spent a lot of time setting up these 6 forms with lots of conditional logic; I hate to just delete 5. Help!

    Submissions excel check and family
  • Profile Image
    JotForm Support

    Answered by ashwin_d on June 13, 2016 at 11:37 PM

    Hello sisters7,

    I did check the "Excel Report" you have added and found that only few columns are selected. Please check the screenshot below:

     

    I would suggest you to edit your excel report (as displayed in screenshot above) and then click on "Uncheck ALL and then Check ALL" button. This will ensure that all questions are displayed in excel report.

    Alternatively, you can also add a new excel report and ensure all checkboxes are checked.

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by Chriistian on June 14, 2016 at 01:13 AM

    I checked the submission you were referring to and the excel file you have linked. It seems that all the 6 people who submitted can be seen on the excel file. 

    Please note that since all of these are in one form submission, they will all be displayed in a single row on the excel file. Unfortunately we cannot put some code to separate these 6 submissions into new rows.

    A possible workaround I could suggest would be to transpose the data into new rows on excel, however, you will need to do this whenever you receive multiple submissions on your form. Here's a guide that can help: http://www.howtogeek.com/howto/12366/convert-a-row-to-a-column-in-excel-the-easy-way/

  • Profile Image
    JotForm Support

    Answered by ashwin_d on June 14, 2016 at 08:08 AM

    On behalf of my colleague, you are welcome.

    Do get back to us if you have any questions.

    Thank you!