Hello - I have a stakeholder asking for survey that allows team members to nominate other team members for our annual awards. We have 10k team members so having a dropdown list is not going to work. In the past we’ve tried loop and merge with free text box but that made the export beyond rough.
As a respondent I could nominate 1 person or 20 people or even 100 if I really wanted too. Thoughts on the best way to structure the survey so that when we export the results it’s not difficult to compile?
TIA, I appreciate the assistance!
Page 1 / 1
Either, Question can be more specific in terms of name, department and other unique items.
Or you can load everyone in the directory and respondents can select anyone from here. How I’m saying is low level view. This has more if you wish to stick with this method
I have QSFs that can do this. The attached surveys use Select2 (loaded in the header) to allow searchable dropdowns and multiple selections. The first uses Drilldown questions because I think it is the easiest way to import large amounts of answer options (vs Supplemental Data, external database, or Multiple choice question). Selections are saved to Embedded Data fields, separated by a comma. If you have more than 10,000 names, you would need to use a second Drilldown question. Compiling the votes would be a little tricky/manual, since each name will need to be counted from within the Embedded Data fields (Excel formula to search for names within a string).
I think the easiest way to compile votes would be where each candidate is a Multiple Choice answer option (second attachment). However, you would need several Multiple Choice questions to do this as each one can only hold 1000 choices. Maybe split the questions up by department?
This might not be a better solution or helpful, but I built a similar form. The nominator has to select which awards they want to nominate for, to show/hide each block, then the questions within those blocks are required. I’m using the autocomplete text input to search the list of employees, but that list is less than 1,000 so I’m not sure it would work in your case with a larger number of names and wanting to multi-select. You could force people to submit the form multiple times for each award if they want to nominate more than one person for an award category which is what we did.
Then on our results dashboard I broke them out in each category.
