Enum DestinationType Stay organized with collections Save and categorize content based on your preferences.
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, includingthose that do not have a destination set explicitly,save a copy of responses in the form'sresponse store. Destination types can be accessed fromForm.
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.constform=FormApp.openById('1234567890abcdefghijklmnopqrstuvwxyz');constss=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. |
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.