Page Summary
-
DestinationTypeis an enum that represents supported types of form-response destinations. -
All forms save a copy of responses in the form's response store, even without an explicitly set destination.
-
Destination types can be accessed from
FormApp.DestinationType. -
An example usage is provided to set a spreadsheet as the response destination for a form.
-
The
SPREADSHEETproperty indicates a Google Sheets spreadsheet as a destination for form responses.
An enum representing the supported types of form-response destinations. All forms, including
those that do not have a destination set explicitly, save a copy of responses in the form's
response store
. Destination types can be accessed from Form
.
To call an enum, you call its parent class, name, and property. For example, FormApp.DestinationType.SPREADSHEET
.
// Open a form by ID and create a new spreadsheet. const form = FormApp . openById ( '1234567890abcdefghijklmnopqrstuvwxyz' ); const ss = SpreadsheetApp . create ( 'Spreadsheet Name' ); // Update the form's response destination. form . setDestination ( FormApp . DestinationType . SPREADSHEET , ss . getId ());
Properties
| Property | Type | Description |
|---|---|---|
SPREADSHEET
|
Enum
|
A Google Sheets spreadsheet as a destination for form responses. |
