Welcome to the online conference planner for the 10th annual miGoogle conference! You can use this planner to preview conference sessions and build a custom schedule. To register for the conference, visit miEdTech.com/register.
Back To Schedule
Friday, November 10 • 2:10pm - 3:00pm
Google Sheets + Scripting = Dynamic Form Fields

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Did you know you can update a form field with data in a spreadsheet? Learn how to use an Apps Script within a Google Sheet to set the possible choices in a Google Form multiple choice, checkbox or dropdown question. You will see the script in action, then walk through the simple version of the script to see how it connects the Sheet to the Form. Template versions of each will be available to copy.

Presentation & Folder of Samples/Templates

Document of Scripting Examples with links to blog posts and/or files.
Google Folder with script examples/coding. 

avatar for Melinda Waffle

Melinda Waffle

Professional Learning Coordinator, REMC Association

Friday November 10, 2023 2:10pm - 3:00pm EST