Class GridValidation

  • GridValidation is used to apply validation rules specifically to grid items within Google Forms.

  • It allows you to enforce restrictions like requiring one response per column within the grid, enhancing data quality.

  • Developers can set custom help text to guide users on how to interact with the grid and meet validation criteria.
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);