Waffle Bytes

There are a variety of types of questions that can be used on a Google Form.  Sometimes it is hard to know which one is best, even with the Google "smarts" trying to pick the right one for you based on what you type.  I am creating several posts that provide a run down of the (current) types of questions you can set up, along with some of the small differences between the types.  First up is the Multiple choice, Checkboxes, and Dropdown options. Second will be the Short answer and Paragraph options. Third will be the Linear grid, Multiple choice grid and Checkbox grid. Forth will be Date and Time. Last will be the file upload.  The Multiple choice, checkbox and dropdown question types are all similar to each other.  There are some small differences that make each one advantageous in different situations.  First up - Multiple choice.  You don't even have to select this one, as it is the default question - Once you have typed in your que...

(Updated on 3/21/2017 - triggers have been moved!) ( I just created a new related post on how to create a multiple choice  question on the form that a bit simplified - takes the "other" answers in a multiple choice question on a form, and updates the multiple choice options with those as options.) I guess it was only a matter of time before I ended up dabbling with Google Scripts.  Today I was asked by a teacher how he could populate a drop-down list on his Google Form from data on a spreadsheet - and have it update as he changed the data.  Not finding an add-on for this (why recreate the wheel? :-)  I explored creating a script.  And...discovered that this task is not too hard! To do this yourself - 1. Create your form.   Really important step.  Make sure to create your drop-down item and give it a title, but you do not need to add any options to it (because later you will populate it from the spreadsheet). 2. Create the spreadsheet whe...