- sborovayAsked 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?
- SvenAnswered 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.
- sborovayAnswered on May 15, 2017 at 10:43 AMHere 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?
- JotForm SupportKevin_GAnswered 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.