sort submissions based on field

  • Profile Image
    sborovay
    Asked 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
    Sven
    Answered on May 15, 2017 at 01:01 AM

    Hi, 

     

    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
    sborovay
    Answered 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
    Kevin_G
    Answered 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.