Class GridValidationBuilder

  • GridValidationBuilder facilitates 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 GridValidationBuilder to tailor validation logic, ensuring responses meet specified criteria.

GridValidationBuilder

A DataValidationBuilder for a GridValidation.

// 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

MethodReturn typeBrief description
requireLimitOneResponsePerColumn()GridValidationBuilderRequires 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

GridValidationBuilder — this validation builder, for chaining