Stay organized with collections Save and categorize content based on your preferences.
GridItemA question item, presented as a grid of columns and rows, that allows the respondent to select one choice per row from a sequence of radio buttons. Items can be accessed or created from a Form
.
// Open a form by ID and add a new grid item. const form = FormApp.openById('1234567890abcdefghijklmnopqrstuvwxyz'); const item = form.addGridItem(); item.setTitle('Rate your interests') .setRows(['Cars', 'Computers', 'Celebrities']) .setColumns(['Boring', 'So-so', 'Interesting']);Detailed documentation
clearValidation()
Removes any data validation for this grid item.
ReturnGridItem
— this item, for chaining
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/forms.currentonly
https://www.googleapis.com/auth/forms
createResponse(responses)
Creates a new ItemResponse
for this grid item. The argument responses
must be a String[]
array containing as many values as the number of rows in the grid. A null
element for a non-required grid question indicates no response to that row. Throws an exception if any of the values does not match a valid choice.
responses
String[]
an array of valid answers for this grid item Return
ItemResponse
— the item response
Scripts that use this method require authorization with one or more of the following scopes:
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.
ReturnGridItem
— a duplicate of this GridItem
, for chaining
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/forms.currentonly
https://www.googleapis.com/auth/forms
getColumns()
Gets the values for every column in the grid.
ReturnString[]
— an array of column values, which respondents see as labels when viewing the form
Scripts that use this method require authorization with one or more of the following scopes:
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 like ImageItems
, PageBreakItems
, and SectionHeaderItems
).
String
— the item's help text or description text
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/forms.currentonly
https://www.googleapis.com/auth/forms
getId()
Gets the item's unique identifier.
ReturnInteger
— the item's ID
Scripts that use this method require authorization with one or more of the following scopes:
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.
ReturnInteger
— the index of the item
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/forms.currentonly
https://www.googleapis.com/auth/forms
getRows()
Gets the values for every row in the grid.
ReturnString[]
— an array of row values, which respondents see as labels when viewing the form
Scripts that use this method require authorization with one or more of the following scopes:
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 a SectionHeaderItem
).
String
— the item's title or header text
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/forms.currentonly
https://www.googleapis.com/auth/forms
getType()
Gets the item's type, represented as an ItemType
.
ItemType
— the item's type
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/forms.currentonly
https://www.googleapis.com/auth/forms
isRequired()
Determines whether the respondent must answer the question.
ReturnBoolean
— whether the respondent must answer the question
Scripts that use this method require authorization with one or more of the following scopes:
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 given array is empty.
Parameters Name Type Descriptioncolumns
String[]
an array of column values, which respondents see as labels when viewing the form Return
GridItem
— this item, for chaining
Error
— if the given array is null
or empty
Scripts that use this method require authorization with one or more of the following scopes:
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 like ImageItems
, PageBreakItems
, and SectionHeaderItems
).
text
String
the new help text Return
GridItem
— this GridItem
, for chaining
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/forms.currentonly
https://www.googleapis.com/auth/forms
setRequired(enabled)
Sets whether the respondent must answer the question.
Parameters Name Type Descriptionenabled
Boolean
whether the respondent must answer the question Return
GridItem
— the current item (for chaining)
Scripts that use this method require authorization with one or more of the following scopes:
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 array is empty.
Parameters Name Type Descriptionrows
String[]
an array of row values, which respondents see as labels when viewing the form Return
GridItem
— this item, for chaining
Error
— if the given array is null
or empty
Scripts that use this method require authorization with one or more of the following scopes:
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 a SectionHeaderItem
).
title
String
the new title or header text Return
GridItem
— this GridItem
, for chaining
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/forms.currentonly
https://www.googleapis.com/auth/forms
setValidation(validation)
Sets the data validation for this grid item. Passing in null or a validation without any require functions called will remove any prior validation.
Parameters Name Type Descriptionvalidation
GridValidation
a GridValidation to apply to this item. Return
GridItem
— this GridItem
, for chaining
Scripts that use this method require authorization with one or more of the following scopes:
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 the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["A GridItem is a question type in Google Forms that presents a grid of rows and columns, allowing respondents to select one choice per row."],["You can customize GridItems by setting the title, rows, columns, help text, and whether a response is required."],["GridItems provide methods to manage data validation, create responses programmatically, and duplicate the item within the form."],["Using Google Apps Script, you can access and manipulate GridItems within a form, including retrieving item properties and modifying its settings."],["Each GridItem has a unique identifier and an index reflecting its position among other items in the form."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4