Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder below:

Class SpreadsheetTriggerBuilder | Apps Script

Stay organized with collections Save and categorize content based on your preferences.

Builder for spreadsheet triggers.

Creates the trigger and returns it.

Trigger — The created trigger.

Specifies a trigger that will fire when the spreadsheet's content or structure is changed.

const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onChange().create();

SpreadsheetTriggerBuilder — a builder for chaining

Specifies a trigger that will fire when the spreadsheet is edited.

const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onEdit().create();

SpreadsheetTriggerBuilder — a builder for chaining

Specifies a trigger that will fire when the spreadsheet has a form submitted to it.

const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction')
    .forSpreadsheet(sheet)
    .onFormSubmit()
    .create();

SpreadsheetTriggerBuilder — A builder for chaining.

Specifies a trigger that will fire when the spreadsheet is opened.

const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onOpen().create();

SpreadsheetTriggerBuilder — a builder for chaining

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."],[[["SpreadsheetTriggerBuilder facilitates the creation and customization of triggers specific to Google Spreadsheets."],["It offers methods to set triggers for various events, such as changes in content or structure (`onChange()`), edits (`onEdit()`), form submissions (`onFormSubmit()`), and spreadsheet opening (`onOpen()`)."],["Each trigger specification method returns a builder object, enabling chained configurations for flexibility and conciseness in trigger setup."],["The `create()` method finalizes the trigger definition and returns a Trigger object, instantiating the trigger for execution based on the specified event."]]],[]]

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