Class CheckboxGridValidation
Stay organized with collections
Save and categorize content based on your preferences.
Spark icon
AI-generated Key Takeaways
-
CheckboxGridValidation is a DataValidation specifically for CheckboxGridItems.
-
It allows setting validation rules like requiring one response per column in a checkbox grid item.
-
You can create a CheckboxGridValidation using
FormApp.createCheckboxGridValidation()and apply it to a CheckboxGridItem.
CheckboxGridValidation
A DataValidation for a Checkbox.
// Add a checkbox grid item to a form and require one response per column. constform=FormApp.openById('123abc'); constcheckboxGridItem=form.addCheckboxGridItem(); checkboxGridItem.setTitle('Where did you celebrate New Years?') .setRows(['New York','San Francisco','London']) .setColumns(['2014','2015','2016','2017']); constcheckboxGridValidation=FormApp.createCheckboxGridValidation() .setHelpText('Select one item per column.') .requireLimitOneResponsePerColumn() .build(); checkboxGridItem.setValidation(checkboxGridValidation);