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...

This is totally a revisit of the post I did on made on October 31, 2016 about " Google Script - Create a Drop-Down List from Spreadsheet Column " I had another use for this today.  I wanted educators completing a form to fill in their district.  Yet the thought of all the different spelling/acronyms I might give was going to make the data analysis crazy.  For people from my organization alone in the first 5 minutes I got Calhoun ISD, Calhoun, Calhoun Intermediate School District, CISD.  Seriously. I remembered this script I used before to create a drop-down from a spreadsheet, and figured I could revamp it for use with a Multiple Choice item - one where people could input their district if it was not there yet using the 'other' option. Viola!  Here it is modified for a multiple choice - much is the same as before, but there are some differences. To do this yourself - 1.  Create your form.   Really important step.  Make sure to cre...