Class CheckboxGridValidationBuilder
Stay organized with collections
Save and categorize content based on your preferences.
CheckboxGridValidationBuilder
A DataValidationBuilder for a CheckboxGridValidation
.
// Add a checkbox grid item to a form and restrict it to 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);
Detailed documentation
requireLimitOneResponsePerColumn()
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[null,null,["Last updated 2024-12-02 UTC."],[[["\u003cp\u003e\u003ccode\u003eCheckboxGridValidationBuilder\u003c/code\u003e helps create validations for checkbox grid items in Google Forms.\u003c/p\u003e\n"],["\u003cp\u003eIt allows setting restrictions like limiting responses to one per column.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003erequireLimitOneResponsePerColumn()\u003c/code\u003e method enforces this single response restriction.\u003c/p\u003e\n"],["\u003cp\u003eThis builder is used with \u003ccode\u003esetValidation()\u003c/code\u003e on a checkbox grid item to apply validation rules.\u003c/p\u003e\n"]]],[],null,["# Class CheckboxGridValidationBuilder\n\nCheckboxGridValidationBuilder\n\nA DataValidationBuilder for a [CheckboxGridValidation](/apps-script/reference/forms/checkbox-grid-validation).\n\n```javascript\n// Add a checkbox grid item to a form and restrict it to one response per\n// column.\nconst form = FormApp.openById('123abc');\nconst checkboxGridItem = form.addCheckboxGridItem();\ncheckboxGridItem.setTitle('Where did you celebrate New Years?')\n .setRows(['New York', 'San Francisco', 'London'])\n .setColumns(['2014', '2015', '2016', '2017']);\nconst checkboxGridValidation = FormApp.createcheckboxGridValidation()\n .setHelpText('Select one item per column.')\n .requireLimitOneResponsePerColumn()\n .build();\ncheckboxGridItem.setValidation(checkboxGridValidation);\n``` \n\n### Methods\n\n| Method | Return type | Brief description |\n|---------------------------------------------------------------------------|------------------------------------|------------------------------------------------------------|\n| [requireLimitOneResponsePerColumn()](#requireLimitOneResponsePerColumn()) | [CheckboxGridValidationBuilder](#) | Requires limit of one response per column for a grid item. |\n\nDetailed documentation\n----------------------\n\n### `require``Limit``One``Response``Per``Column()`\n\nRequires limit of one response per column for a grid item.\n\n#### Return\n\n\n[CheckboxGridValidationBuilder](#) --- this validation builder, for chaining"]]