Class CheckboxGridItem

  • CheckboxGridItem is a form question item presented as a grid allowing multiple selections per row via checkboxes.

  • You can access or create CheckboxGridItem instances from a Form object.

  • Key methods include setting/getting columns and rows, managing validation, and duplicating the item.

CheckboxGridItem

A question item, presented as a grid of columns and rows, that allows the respondent to selectmultiple choices per row from a sequence of checkboxes. Items can be accessed or created from aForm.

// Open a form by ID and add a new checkbox grid item.constform=FormApp.openById('1234567890abcdefghijklmnopqrstuvwxyz');constitem=form.addCheckboxGridItem();item.setTitle('Where did you celebrate New Years?').setRows(['New York','San Francisco','London']).setColumns(['2014','2015','2016','2017']);

Methods

MethodReturn typeBrief description
clearValidation()CheckboxGridItemRemoves any data validation for this grid item.
createResponse(responses)ItemResponseCreates a newItemResponse for this checkbox grid item.
duplicate()CheckboxGridItemCreates a copy of this item and appends it to the end of the form.
getColumns()String[]Gets the values for every column in the grid.
getHelpText()StringGets the item's help text (sometimes called description text for layout items likeImageItems,PageBreakItems, andSectionHeaderItems).
getId()IntegerGets the item's unique identifier.
getIndex()IntegerGets the index of the item among all the items in the form.
getRows()String[]Gets the values for every row in the grid.
getTitle()StringGets the item's title (sometimes called header text, in the case of aSectionHeaderItem).
getType()ItemTypeGets the item's type, represented as anItemType.
isRequired()BooleanDetermines whether the respondent must answer the question.
setColumns(columns)CheckboxGridItemSets the columns of the grid based on an array of values.
setHelpText(text)CheckboxGridItemSets the item's help text (sometimes called description text for layout items likeImageItems,PageBreakItems, andSectionHeaderItems).
setRequired(enabled)CheckboxGridItemSets whether the respondent must answer the question.
setRows(rows)CheckboxGridItemSets the rows of the grid based on an array of values.
setTitle(title)CheckboxGridItemSets the item's title (sometimes called header text, in the case of aSectionHeaderItem).
setValidation(validation)CheckboxGridItemSets the data validation for this checkbox grid item.

Detailed documentation

clearValidation()

Removes any data validation for this grid item.

Return

CheckboxGridItem — this item, for chaining

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

createResponse(responses)

Creates a newItemResponse for this checkbox grid item. The argumentresponsesmust be aString[][] array of arrays containing as many values as the number of inputsin the checkbox grid. Anull element for a non-required checkbox grid questionindicates no response to that row. Throws an exception if any of the values does not match avalid choice.

Parameters

NameTypeDescription
responsesString[][]an array of arrays of valid answers for this checkbox grid item

Return

ItemResponse — the item response

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

duplicate()

Creates a copy of this item and appends it to the end of the form.

Return

CheckboxGridItem — a duplicate of thisCheckboxGridItem, for chaining

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

getColumns()

Gets the values for every column in the grid.

Return

String[] — an array of column values, which respondents see as labels when viewing the form

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

getHelpText()

Gets the item's help text (sometimes called description text for layout items likeImageItems,PageBreakItems, andSectionHeaderItems).

Return

String — the item's help text or description text

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

getId()

Gets the item's unique identifier.

Return

Integer — the item's ID

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

getIndex()

Gets the index of the item among all the items in the form.

Return

Integer — the index of the item

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

getRows()

Gets the values for every row in the grid.

Return

String[] — an array of row values, which respondents see as labels when viewing the form

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

getTitle()

Gets the item's title (sometimes called header text, in the case of aSectionHeaderItem).

Return

String — the item's title or header text

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

getType()

Gets the item's type, represented as anItemType.

Return

ItemType — the item's type

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

isRequired()

Determines whether the respondent must answer the question.

Return

Boolean — whether the respondent must answer the question

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

setColumns(columns)

Sets the columns of the grid based on an array of values. Throws an exception if the givenarray is empty.

Parameters

NameTypeDescription
columnsString[]an array of column values, which respondents see as labels when viewing the form

Return

CheckboxGridItem — this item, for chaining

Throws

Error — if the given array isnull or empty

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

setHelpText(text)

Sets the item's help text (sometimes called description text for layout items likeImageItems,PageBreakItems, andSectionHeaderItems).

Parameters

NameTypeDescription
textStringthe new help text

Return

CheckboxGridItem — thisCheckboxGridItem, for chaining

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

setRequired(enabled)

Sets whether the respondent must answer the question.

Parameters

NameTypeDescription
enabledBooleanwhether the respondent must answer the question

Return

CheckboxGridItem — the current item (for chaining)

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

setRows(rows)

Sets the rows of the grid based on an array of values. Throws an exception if the given arrayis empty.

Parameters

NameTypeDescription
rowsString[]an array of row values, which respondents see as labels when viewing the form

Return

CheckboxGridItem — this item, for chaining

Throws

Error — if the given array isnull or empty

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

setTitle(title)

Sets the item's title (sometimes called header text, in the case of aSectionHeaderItem).

Parameters

NameTypeDescription
titleStringthe new title or header text

Return

CheckboxGridItem — thisCheckboxGridItem, for chaining

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

setValidation(validation)

Sets the data validation for this checkbox grid item. Passing in null or a validation withoutany require functions called will remove any prior validation.

Parameters

NameTypeDescription
validationCheckboxGridValidationa CheckboxGridValidation to apply to this item.

Return

CheckboxGridItem — thisCheckboxGridItem, for chaining

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/forms.currentonly
  • https://www.googleapis.com/auth/forms

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-11 UTC.