Drop Down In Google Forms. In this video i am going to show you how to add a dropdown menu in google docs forms. Identify the sheet where the data resides needed to populate the drop down var ss spreadsheetapp getactive.
Next open the data menu and select the data validation command. Grab the values in the first column of the sheet use 2 to skip header row. 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.
Next open the data menu and select the data validation command.
Var nameslist form getitembyid the drop down list id aslistitem. There are more than 200 countries and it doesn t make sense to retype them one by one. Next open the data menu and select the data validation command. Call your form and connect to the drop down item var form formapp openbyid your form id.
