Class CheckboxGridValidation
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
核取方塊格驗證CheckboxGridItem
的 DataValidation。
// Add a checkbox grid item to a form and require 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);
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
上次更新時間:2025-07-26 (世界標準時間)。
[null,null,["上次更新時間:2025-07-26 (世界標準時間)。"],[[["\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,["# Class CheckboxGridValidation\n\nCheckboxGridValidation\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```"]]