google-forms
Supposing I have 2 multiple-choice questions concerning:
Country students are from: ….. (choices include USA, UK, China ….)
States where they are from: then if they selected USA in the first question, the options shown will be LA, Cali or somewhere in the US but not somewhere in UK or Russia
Can we do this in Google forms?
To get Radio Buttons on a Google Docs Form, you need set the Question Type to Multiple Choice
You should be able to do it with something like
// Change these three values to match your own spreadsheet
var OPTIONS_SPREADSHEET_ID = "0Avea1NXBTibYdEY4XzBvSk84MjB2RENiOFljSkVaY0E";
var OPTIONS_SHEET_NAME = "Sheet 1";
var OPTIONS_RANGE = "A1:A4"; // We have 4 options, listed in column A
// This returns a 2D array of the values of the range, e.g. [["A1value", "B1Value"], ["A2Value", "B2Value"], ["A3Value", "B3Value"]];
var options2DArr = SpreadsheetApp.openById(OPTIONS_SPREADSHEET_ID).getSheetByName(OPTIONS_SHEET_NAME).getRange(OPTIONS_RANGE).getValues();
var options = [];
for (var i = 0; i < options2DArr.length; i++) { // Now iterate through the 2D array and extract values from the first column only
options.push(options2DArr[i][0]); // 0 is the index of the first column
}
form.addMultipleChoiceItem()
.setTitle('Do you prefer cats or dogs?')
.setChoiceValues(options) // <-- Uses the spreadsheet values as choice options
.showOtherOption(true);
Best Answer
Yes.
The easiest path is to create a section for each choice which will hold the specific questions for each country.
Then make your initial question around which country.
You then make that question
go to section based on answerby clicking on the three dots in the corner.You'll then have additional options for each answer and can set it up accordingly.
The screenshot below asks which country and based on the answer jumps to a section where there is a country specific option for cities.