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.
Checkbox
Grid
Validation
A DataValidation for a Checkbox
.
// Add a checkbox grid item to a form and require one response per column. const form = FormApp . openById ( '123abc' ); const checkboxGridItem = form . addCheckboxGridItem (); checkboxGridItem . setTitle ( 'Where did you celebrate New Years?' ) . setRows ([ 'New York' , 'San Francisco' , 'London' ]) . setColumns ([ '2014' , '2015' , '2016' , '2017' ]); const checkboxGridValidation = FormApp . createCheckboxGridValidation () . setHelpText ( 'Select one item per column.' ) . requireLimitOneResponsePerColumn () . build (); checkboxGridItem . setValidation ( checkboxGridValidation );

