Class GridValidation
Stay organized with collections
Save and categorize content based on your preferences.
GridValidation
A DataValidation for a GridItem
.
// 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);
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\u003eGridValidation\u003c/code\u003e is used to apply validation rules specifically to grid items within Google Forms.\u003c/p\u003e\n"],["\u003cp\u003eIt allows you to enforce restrictions like requiring one response per column within the grid, enhancing data quality.\u003c/p\u003e\n"],["\u003cp\u003eDevelopers can set custom help text to guide users on how to interact with the grid and meet validation criteria.\u003c/p\u003e\n"]]],[],null,["# Class GridValidation\n\nGridValidation\n\nA DataValidation for a [GridItem](/apps-script/reference/forms/grid-item).\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```"]]