I have a multiple checkbox question that needs to have exactly the same number of ticked checkboxes as given in a multiple choice question. So if a user chooses the option 2 in the multiple choice question, I want to require that they choose exactly 2 options in the following checkbox question.
Google Forms – Requiring Exact Number of Checkboxes Based on Multiple Choice Response
google-forms
Related Solutions
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);
Related Topic
- Google-drive – Google Forms – Checkboxes – Edit Option
- Google-forms – Simple sum of checkboxes
- Google Forms – How ‘Other’ Field Works in Multiple Choice Questions
- Google Forms – How to Set Up Conditional Branching with Checkboxes
- Google Forms – How to Add ‘None of the Above’ Checkbox
- Google-forms – Google Forms – two required questions – accept with at least one of them
Best Answer
Google Forms lets you use a validation rule like
select exactly 2 checkboxes. In your scenario, the2will vary. The rule, however, cannot read the2dynamically, so the value will have to be hardcoded.There is a way to vary the number, though:
2.go to section based on answeroption.To make sure the user only ever sees one copy of the checkbox question, you would have to use the
go to section based on answeragain to skip any remaining checkbox sections. This may require that you add another multiple choice or dropdown question at the end of each checkbox section.All this adds complexity to the form, and I am not sure if it is worth the effort in your use case. It may be simpler to just add text to the form to emphasize to the user that they can only tick as many checkboxes as the multiple choice indicates.
You may also want to consider using another forms package. There are many such packages out there that support writing their responses directly to Google Sheets.
Yet another option is to write your own custom HTML form and deploy it as a web app. See the Web App Demo for sample code.