Google Forms Drop Down Menu. 1 create a google form with a list item and set the form to automatically post the results to a spreadsheet. Identify the sheet where the data resides needed to populate the drop down var ss spreadsheetapp getactive.
Click email this form. Creating a form from a spreadsheet. From the criteria drop down choose either list from a range or list of items.
Click the new button in the top left corner.
1 create a google form with a list item and set the form to automatically post the results to a spreadsheet. The first thing you need to do is open up your google sheets file and select the cell s for which you want to use a drop down list. Click the new button in the top left corner. Var names ss getsheetbyname name of sheet in spreadsheet.
