Class GridValidationBuilder
Stay organized with collections
Save and categorize content based on your preferences.
GridValidationBuilder
A DataValidationBuilder for a GridValidation
.
// Add a grid item to a form and require one response per column.
const form = FormApp.create('My Form');
const gridItem = form.addGridItem();
gridItem.setTitle('Rate your interests')
.setRows(['Cars', 'Computers', 'Celebrities'])
.setColumns(['Boring', 'So-so', 'Interesting']);
const gridValidation = FormApp.createGridValidation()
.setHelpText('Select one item per column.')
.requireLimitOneResponsePerColumn()
.build();
gridItem.setValidation(gridValidation);
Detailed documentation
requireLimitOneResponsePerColumn()
Requires limit of one response per column for a grid item.
Return
GridValidationBuilder
— this validation builder, for chaining
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\u003eGridValidationBuilder\u003c/code\u003e facilitates the creation of validation rules for grid items within Google Forms.\u003c/p\u003e\n"],["\u003cp\u003eIt offers the functionality to enforce a single response per column in grid questions, enhancing data integrity.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003erequireLimitOneResponsePerColumn()\u003c/code\u003e method is central to establishing this constraint, streamlining response collection.\u003c/p\u003e\n"],["\u003cp\u003eDevelopers can leverage the \u003ccode\u003eGridValidationBuilder\u003c/code\u003e to tailor validation logic, ensuring responses meet specified criteria.\u003c/p\u003e\n"]]],[],null,["# Class GridValidationBuilder\n\nGridValidationBuilder\n\nA DataValidationBuilder for a [GridValidation](/apps-script/reference/forms/grid-validation).\n\n```javascript\n// Add a grid item to a form and require one response per column.\nconst form = FormApp.create('My Form');\nconst gridItem = form.addGridItem();\ngridItem.setTitle('Rate your interests')\n .setRows(['Cars', 'Computers', 'Celebrities'])\n .setColumns(['Boring', 'So-so', 'Interesting']);\nconst gridValidation = FormApp.createGridValidation()\n .setHelpText('Select one item per column.')\n .requireLimitOneResponsePerColumn()\n .build();\ngridItem.setValidation(gridValidation);\n``` \n\n### Methods\n\n| Method | Return type | Brief description |\n|---------------------------------------------------------------------------|----------------------------|------------------------------------------------------------|\n| [requireLimitOneResponsePerColumn()](#requireLimitOneResponsePerColumn()) | [GridValidationBuilder](#) | 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[GridValidationBuilder](#) --- this validation builder, for chaining"]]