formRanger

https://docs.google.com/a/bofcm.org/file/d/0B63NdyMiy2KTNXkwZk1HZHZFUVU/edit?usp=drive_web
Do you use Apps Forms heavily? Are you tired of editing each form when the options for multiple choice, checkbox and list type questions change? Well, help is here. formRanger to the rescue. formRanger is a sweet little script that can be used to auto-populate form options for you. Simply install the script into the Response Sheet for a form. Then, create another worksheet within the Response Sheet to host the option lists for one or more questions. Use formRanger to connect these option lists to the desired form questions and BOOM! Simply edit the sheet and the form updates automagically.

formRanger is the creation of apps scripting guru Andrew Stillman (+Andrew Stillman@astillman) through his work with New Visions for Public Schools.

To learn more about formRanger, visit...