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

    sort submissions based on field

    Asked by sborovay on May 14, 2017 at 09:08 PM

    I made a template with groups to choose, but when it imports as an excel spreadsheet, it has the name and everything that they chose.

    I need it to list the categories, and then the names of the people that chose them.

    Is there a template like that?

  • Profile Image

    Answered by Sven on May 15, 2017 at 01:01 AM



    I'm not sure I understand your question correctly. Do you want to sort your submissions in order of categories? Or do you want to create a form that only shows categories and names?


    If you want to just sort your submissions, you can do so by clicking on the header of that column in the submission page, also please note that columns will appear in the order you add them in your form, so if you have the name as the first field in your form, the first column in the submission page will be name.


    Hope this helps! Let us know if you need any further help.


    Thank you!

  • Profile Image

    Answered by sborovay on May 15, 2017 at 10:43 AM
    Here is a screen shot of how the form looks when entered into excel,
    I need to be able to tally up how many people want each of these activities, so I need the activities on separate lines with the persons name, email address and phone number.
    Is that possible?
  • Profile Image
    JotForm Support

    Answered by Kevin_G on May 15, 2017 at 11:07 AM

    Unfortunately, your screenshot did not reach this post, you could try upload it by following this guide: How-to-add-screenshots-images-to-questions-in-support-forum

    Also, I have checked your forms and I can see you have check boxes on them, here's an example: 

    Do note that the options will be included in a single column on the Excel report, so if your users select more than 2 options they will be listed in the same column, example: 

    The other submitted information will be also included in the same row. 

    If you would need to get each selected option in a different column then you will need to separate your options in field, so one option would need to be a check box field. 

    We also have a report that will help you to know how many times an option has been selected, please take a look on this guide in order to get more info about it: https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions 

    Hope this helps.