Choose “Script editor.” You will want to paste (Control V) the code into the script editor. In the Google Form, click on the 3 dots icon in the upper right. Open the code and use Control A to select all. If you used my template you do NOT need to do these directions. If you already have a Google Form, you will need to copy and paste the code into your Form. (There may be duplicates, the formula does not take into consideration if someone has already been chosen.) Use the spreadsheet to view the 19 runner ups. The Add-on chooses one random winner and 19 runner ups. You will receive an email with the link to the winner spreadsheet. You can type in the winner’s response number and press enter to jump to that person’s response.Įach time you use the Add-on a spreadsheet is created. There is a spot to arrow to each of the individual responses. In the Google Form, click on “Responses” and then click on “Individual” to see the individual responses.
The pop-up will also tell you the response number. A pop-up will indicate who won, by email address. The Add-on will randomly select a winner from all form responses. Choose a Random ResponderĪt any point after collecting responses, use the puzzle piece icon in the Google Form to run the Add-on “Choose Random Responder.”
Just as you normally would, have people fill out the form. Create your form questions just as you normally would. The link above will prompt you to make a copy of my Google Form template. Note: Your form MUST automatically collect responses in order for this code to work. In order to use this template you must use the above link to create your Google Form or copy and paste my code from the script editor into the script editor of your existing Google Form. Randomly select a student in class to share about their work. If you are having participants at an event fill out an evaluation form you can use this Add-on to randomly select people for a drawing. Choose a random winner from those who fill out your Google Form. Use this Add-on I coded in Google Apps Script to automatically select a winner, create a spreadsheet listing the winner and 19 runner ups and receive an email with the winner and links to the Form and spreadsheet.
0 kommentar(er)
