- hoosiercuseAsked on August 09, 2016 at 10:07 PM
I run a weekly poll for coaches to rank the top 10 teams in the league. They have 50 teams to choose from. I want to present the list and have them pick the top 10. They can't vote for the same team twice.
A first-place vote gets 10 points, second place gets 9, third gets 8, etc. I want to be able to get a spreadsheet that ranks the top 10 based on the points.
I can't figure out which tool would be the best to get this done. Any help would be really appreciated.
- JotForm SupportChriistianAnswered on August 10, 2016 at 12:21 AM
I believe the Orderable List Widget is suitable for your requirement. With this widget, the coaches can accurately rank the 50 teams simply by dragging and dropping the teams to each position. To add the widget to your form, please follow this guide: How to Add a Widget to your Form?
You can check out this demo form with 20 team that can be ranked from first place to bottom. https://form.jotform.com/62220661358957
To integrate them to a google spreadsheet, simply follow this guide: How to Integrate Form with Google Spreadsheet.
You can also try out this alternate widget that you can use to rank the teams: Dual Listbox Widget
If you need further assistance, please let us know.
- hoosiercuseAnswered on August 10, 2016 at 09:25 AM
The Dual Listbox Widget would be perfect because the coaches could easily see the teams selected. However, the right hand column doesn't maintain the order in which a team is selected, and they can't be moved around.
I'll try the Orderable List Widget. I just need to figure out how to assign a numerical value for each place. I'm very new to this.
Thanks for the help.
- BorisAnswered on August 10, 2016 at 10:54 AM
I'm afraid numerical values cannot get assigned to options of our Orderable List widget, but the output from this widget will automatically contain the position number where the team was positioned within the Orderable List.
So, the first team will be presented by "1: Name of first selected team", second will start with "2:", third one with "3:". etc. You can see the following image of the output from the Orderable List widget:
I hope this helps.