AI-generated Key Takeaways
-
GridValidationBuilderfacilitates the creation of validation rules for grid items within Google Forms. -
It offers the functionality to enforce a single response per column in grid questions, enhancing data integrity.
-
The
requireLimitOneResponsePerColumn()method is central to establishing this constraint, streamlining response collection. -
Developers can leverage the
GridValidationBuilderto tailor validation logic, ensuring responses meet specified criteria.
A DataValidationBuilder for a Grid.
// 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);
Methods
| Method | Return type | Brief description |
|---|---|---|
require | Grid | Requires limit of one response per column for a grid item. |
Detailed documentation
requireLimitOneResponsePerColumn()
Requires limit of one response per column for a grid item.
Return
Grid — this validation builder, for chaining