// Add a checkbox grid item to a form and require one response per column.constform=FormApp.openById('123abc');constcheckboxGridItem=form.addCheckboxGridItem();checkboxGridItem.setTitle('Where did you celebrate New Years?').setRows(['New York','San Francisco','London']).setColumns(['2014','2015','2016','2017']);constcheckboxGridValidation=FormApp.createCheckboxGridValidation().setHelpText('Select one item per column.').requireLimitOneResponsePerColumn().build();checkboxGridItem.setValidation(checkboxGridValidation);
Sauf indication contraire, le contenu de cette page est régi par une licence Creative Commons Attribution 4.0, et les échantillons de code sont régis par une licence Apache 2.0. Pour en savoir plus, consultez les Règles du site Google Developers. Java est une marque déposée d'Oracle et/ou de ses sociétés affiliées.
Dernière mise à jour le 2025/07/26 (UTC).
[[["Facile à comprendre","easyToUnderstand","thumb-up"],["J'ai pu résoudre mon problème","solvedMyProblem","thumb-up"],["Autre","otherUp","thumb-up"]],[["Il n'y a pas l'information dont j'ai besoin","missingTheInformationINeed","thumb-down"],["Trop compliqué/Trop d'étapes","tooComplicatedTooManySteps","thumb-down"],["Obsolète","outOfDate","thumb-down"],["Problème de traduction","translationIssue","thumb-down"],["Mauvais exemple/Erreur de code","samplesCodeIssue","thumb-down"],["Autre","otherDown","thumb-down"]],["Dernière mise à jour le 2025/07/26 (UTC)."],[[["\u003cp\u003e\u003ccode\u003eCheckboxGridValidation\u003c/code\u003e is used to set validation rules specifically for \u003ccode\u003eCheckboxGridItem\u003c/code\u003e within Google Forms.\u003c/p\u003e\n"],["\u003cp\u003eIt allows you to enforce constraints like requiring exactly one response per column in a checkbox grid, enhancing data integrity and user experience.\u003c/p\u003e\n"],["\u003cp\u003eYou can customize the validation with help text to guide users on expected input.\u003c/p\u003e\n"]]],["This content demonstrates creating and validating a checkbox grid item within a form. It outlines adding a checkbox grid with titles, rows (e.g., \"New York\"), and columns (e.g., \"2014\"). The example then builds a `CheckboxGridValidation` to enforce a limit of one response per column, including setting custom help text. Finally, it applies this validation to the checkbox grid, ensuring responses adhere to the set criteria.\n"],null,["CheckboxGridValidation\n\nA DataValidation for a [CheckboxGridItem](/apps-script/reference/forms/checkbox-grid-item).\n\n```javascript\n// Add a checkbox grid item to a form and require one response per 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```"]]
