Enum DestinationType

  • DestinationType is 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 SPREADSHEET property 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 FormApp.DestinationType.

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

PropertyTypeDescription
SPREADSHEETEnumA Google Sheets spreadsheet as a destination for form responses.

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 2025-12-11 UTC.