Any help from the group would be super helpful. I'm sure there is an easy solution here that I'm simply overlooking. Time-based triggers don't seem to help either. I've also changed the triggers to update on open, change, and edit with no success.

However, it is not updating as I add to the linked column.Įx: One question is what product are we making today? The options at the time I wrote the script were, let's say:Īs a test, I added Pencils to the list after the script was written and it's not populating in the form no matter how many times I refresh either document, save or debug the code, or open or close either document. When I initially wrote this script, my form populated perfectly with the options I made available in the linked spreadsheet. I'm having an issue with this that I hope someone can shed some light on. You can get this from the URL of your form when you are editing it - it is the part between the backslashes as marked here Replace the text Your Form ID with your actual form id. populate the drop-down with the array data convert the array ignoring empty cellsįor(var i = 0 i < namesValues.length i++) Var namesValues = names.getRange(2, 1, names.getMaxRows() - 1).getValues() grab the values in the first column of the sheet - use 2 to skip header row Var names = ss.getSheetByName(' Name of Sheet in Spreadsheet') identify the sheet where the data resides needed to populate the drop-down Var namesList = form.getItemById(' The Drop-Down List ID').asListItem() Var form = FormApp.openById(' Your Form ID') call your form and connect to the drop-down item

With this - (all the text highlighted in gray include the final bracket) 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.)

Membuat dropdown label blogger