As many of you know, Google Forms is a powerful tool to use in a wide variety of situations. One popular application is using it as a sign-up form or scheduling appointments. Users would simply choose from a list of options, and the answers are recorded in a spreadsheet.
Here’s an example of a form we used for students to sign up for shifts for our Multicultural Fair:
Since we wanted to evenly distribute the 50 groups among the shifts, I used an add-on called Choice Eliminator. When you use this, you set the number of responses you’ll accept for each choice, and as someone selects it, one spot is eliminated. Once all of the spots are taken, that option will disappear from your Google Form. It’s genius and works very well if you set it up correctly.
Setting it up
Get the Add-on
1. While in your Google Form, the three vertical dogs beside your picture or initials. Then select “Add-ons.”
2. You’ll most likely find Choice Eliminator 2 in the top row due to its popularity. If not, just type it in the “Search Add-ons” box. When you see it, click on the blue “+Free” button to select it.
3. Choice Eliminator 2 is now one of your add-ons and can be accessed by clicking on the puzzle piece on the top menu.
Using Choice Eliminator
- In your Google Form, create a question with a dropdown option (multiple choice and checkboxes don’t always work).
- Click on the “Add-ons” puzzle piece icon.
- Select “Choice Eliminator 2” and then “Configure.”
- You will see a note from the author stating that dropdown questions work better with this add-on. I have found this to be true and highly suggest it. Close out after reading the note.
- In the mini box to the right, click on your first question. Then select “Eliminate Choices.” It will take a few seconds to process.
- Click on the cog to the right for “Choice Options.”
7. Another window will open. This is where you will set the answer limit for each choice. When you’re done, hover your mouse over the green circle, and then click on the red X.
Test it out
1. At the top of your Google Form, go to “Send” and then click on the “Link” icon in the middle. Copy the link and paste it in a new tab or window.
2. Claim one of the spots by completing the form. I usually go into the again and claim that same spot multiple times.
3. After you’ve claimed all of the spots, that choice should no longer appear on the next attempt. For example, if I only have two spots for option 1, then on the third time I complete the form, option 1 will not appear.
4. If you follow steps 2-7 above, you will be led back to the popup where you set the limit for your choices. It will indicate that one spot is taken.
Look at your responses
- Go back to your Google Form. You should see a number beside “Responses.” Click on it.
- You will have the option to see a summary or individual responses. If you click on the green rectangle to the right, a spreadsheet with your responses will appear.
Resetting your options
- Now that you’ve tested it out, you need to reset your options back to zero.
- At the top of your form, click on the “Add-ons” puzzle piece icon.
- Select “Choice Eliminator 2” and then “Configure”
- You will see a note from the author. Close out of the window.
- In the popup window to the right, click on your first question. The select “Eliminate Choices.” It will take a few seconds to process.
- Click on the cog to the right “Choice Options.”
- Another window will open. This is where you originally set the limit for the number of choices available. To reset it, hover your mouse over the green circle, and then click on the box with the arrow. You will see “Restore Choices.”
- Your counts are now set to zero. Hover your mouse over the green circle and click on the red X.
Possible uses for this:
- As mentioned above, setting appointments, especially for parent or in-class conferences
- Signing up for spots on the bus (for a field trip), group to be in, or shifts
- Signing up for project topics so that you don’t have 175 of the SAME topic (like which amendment to do a presentation on, which author or country to study, etc.)
- If you’re holding an Educon, you can limit the number of participants in a session to allow for more individualized attention
To make it easier to use this the first time, I’ve included a cheat sheet for you to print out. Just click on the link below for access!
Like what you've read? There's more where that came from!
Sign up for my weekly newsletter and get instant access to my free educational resources and downloads!