Tuesday, April 18, 2017

Choose a Random Person from a Google Form

If you have people fill out a Google form and you want to select a random person from this form you can do that easily with the script that Alice Keeler wrote. Don’t worry, you don’t need to know anything about coding or script writing to use this. Alice Keeler made a template that you start with. You can access it by clicking here. Start off with this form and edit it to make it the way you want it to look. Distribute it and collect your responses. After you have collected the response click on the puzzle piece icon in the Google Form and run the add on “Choose Random Responder.” A random response will be selected and a pop up will tell you who it is. Each time you run this add-on a spreadsheet is created with the winner and all the (up to 19) runner ups. You will receive a link to that spreadsheet in your e-mail. If you already have a form that you want to use, the script is provided for you if you want to add it into your form. You can find more details on that and this whole process by visiting Alice Keeler’s blog directly.


No comments:

Post a Comment