Posts

Showing posts from December, 2020

Google Script - Create a Multiple Choice Quiz from Questions in a Spreadsheet

Image
Recently I was asked if there was a way to create a multiple choice quiz from a spreadsheet which had the questions and answers already in it.  A colleague (thank you Andy Mann !) found a script created by Jason Jurotich which we were able to simplify and adapt for our own purposes with the  REMC project  21Things4Students .  Our modified script creates a Google Form multiple choice quiz from the active sheet (the one you are currently looking at) in a Google Spreadsheet.  If you have multiple sheets with questions (say 1 sheet for each chapter), you can create a new quiz just by running the script again on a different sheet!  Below is how to add the script, what it does, and what you may want to modify -   Adding the script 1. First, while in the spreadsheet you are going to use (whether the questions are set up or not), go to the Tools Menu - Script Editor 2. Delete out the code that is there. Copy and paste in the script found in the document  Script - SS to Quiz .  Ge sure to cop

Google Script: Sending an Approval Email from Form/Spreadsheet Data

Image
I was asked to create a script that would send an approval email once a request was approved - for 2 separate groups, and to be used for 2 different reasons!  The example below is being used for building access approval (RE: the work-at-home requirements due to COVID-19).  The other way this was used was for approval of spending requests.  These utilize an additional column that is marked (in these cases) with a Yes that will trigger the email, then if an email is sent it makes that notation in the final column.  Note - the script will break (stop running) if someone submits a non-working email from a form, so I recommend having the form auto-collect the email. Here are the directions for using the script -  Creating and Sending the Email 1. Create the spreadsheet  You can either do this with a New Spreadsheet, adding the data fields you want  OR Create a form with the data you are collecting and have it create the companion spreadsheet Important :  Be sure to include email address! Yo