// Add a grid item to a form and require one response per column.constform=FormApp.create('My Form');constgridItem=form.addGridItem();gridItem.setTitle('Rate your interests').setRows(['Cars','Computers','Celebrities']).setColumns(['Boring','So-so','Interesting']);constgridValidation=FormApp.createGridValidation().setHelpText('Select one item per column.').requireLimitOneResponsePerColumn().build();gridItem.setValidation(gridValidation);
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["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"]]
