Add Options in Dropdown Lists & Multiple Choice QuestionsĬreate a Google Spreadsheet and add the question titles in the first row of the sheet, one per column.
#WHY CAN'T I TYPE ANSWERS FOR SHORT ANSWER QUESTIONS ON GOOGLE FORMS ON A MAC DESKTOP UPDATE#
You can even create a time-trigger that runs every hour, day or month to dynamically update your form using the most current data available in the spreadsheet. The app will read the data from this Google Sheet and auto-populate the choices in the form with one click. We’ll have a Google Sheet that will be the data source and have all the answer choices for various questions in the Google Form. In the previous example, some teachers may move out, new teachers may join in and the drop-down list in the form has to be updated manually every time there’s a change in the staff.Īuto-Populate Questions in Google Forms with Google SheetsĪs with everything else in the world of Google Forms and Google Sheets, we can easily automate the process of adding question choices in Google Forms in bulk with the help of, you guessed it right, Google Apps Script.
The form would have a drop-down of countries, the names of class teachers as a multiple choice question and a checkbox style question where students can pick one or more subjects. A school is trying to create a Google Form where students can register their details.
0 kommentar(er)
