That is what I did here - adding a sheet called Student Names: Create the spreadsheet where your list will reside.Ī: You can create the spreadsheet for your form responses and add a second sheet to it. 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).Ģ. And.discovered that this task is not too hard! Not finding an add-on for this (why recreate the wheel? :-) I explored creating a script. 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. I guess it was only a matter of time before I ended up dabbling with Google Scripts. ( 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.)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |