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);