Drop Down Google Form. You only need a predefined list of the required items. Once done get ready to link the dropdown.
Select all of them with ctrl a and paste them in the form using ctrl v. Google forms is the best to pick when comes to creating forms for free but unfortunately it left users to hang dry for auto fill functionality based on dropdown choices. Grab the values in the first column of the sheet use 2 to skip header row.
Keeping this in mind i would like to suggest pabbly form builder that allows us to create a dynamic auto populated form without any trouble.
Identify the sheet where the data resides needed to populate the drop down var ss spreadsheetapp getactive. Keeping this in mind i would like to suggest pabbly form builder that allows us to create a dynamic auto populated form without any trouble. You only need a predefined list of the required items. Identify the sheet where the data resides needed to populate the drop down var ss spreadsheetapp getactive.