I love me some Add-Ons. One of my favorites is FormRanger from New Visions Cloud Lab. It can be used to pull in a column of information from a Google Sheet as multiple choice or dropdown options.
This is nice for quickly creating a lot of options for a multiple choice or dropdown question, but what takes it from nice to awesome is . . . you can set it to automatically update based on changes made to the spreadsheet. Whaaaaat!? I know, right?
There are two main cases for use:
- When you will be adding things to the list (i.e., students moving into your school). Update the Sheet (or have an Administrative Assistant update it) and the Form will update too.
- When you will be removing things from the list (i.e., a list of upcoming PD Dates). Remove things from the Sheet (like past PD Dates) and the Form will update too.