A generic builder for script triggers.
Methods
| Method | Return type | Brief description |
|---|---|---|
forForm(form) | FormTriggerBuilder | Creates and returns a FormTriggerBuilder tied to the given form. |
forForm(key) | FormTriggerBuilder | Creates and returns a FormTriggerBuilder tied to the form with the given ID. |
forSpreadsheet(sheet) | SpreadsheetTriggerBuilder | Creates and returns a SpreadsheetTriggerBuilder tied to the given spreadsheet. |
forSpreadsheet(key) | SpreadsheetTriggerBuilder | Creates and returns a SpreadsheetTriggerBuilder tied to the spreadsheet with the given
ID. |
timeBased() | ClockTriggerBuilder | Creates and returns a ClockTriggerBuilder for building time-based triggers. |
Detailed documentation
forForm(form)
Creates and returns a FormTriggerBuilder tied to the given form.
ScriptApp.newTrigger('myFunction')
.forForm(FormApp.getActiveForm())
.onFormSubmit()
.create();
Parameters
| Name | Type | Description |
|---|---|---|
form | Form | the form |
Return
FormTriggerBuilder — the new FormTriggerBuilder
forForm(key)
Creates and returns a FormTriggerBuilder tied to the form with the given ID.
ScriptApp.newTrigger('myFunction')
.forForm('1234567890abcdefghijklmnopqrstuvwxyz')
.onFormSubmit()
.create();
Parameters
| Name | Type | Description |
|---|---|---|
key | String | the ID for the form |
Return
FormTriggerBuilder — the new FormTriggerBuilder
forSpreadsheet(sheet)
Creates and returns a SpreadsheetTriggerBuilder tied to the given spreadsheet.
ScriptApp.newTrigger('myFunction')
.forSpreadsheet(SpreadsheetApp.getActive())
.onEdit()
.create();
Parameters
| Name | Type | Description |
|---|---|---|
sheet | Spreadsheet | the spreadsheet |
Return
SpreadsheetTriggerBuilder — the new SpreadsheetTriggerBuilder
forSpreadsheet(key)
Creates and returns a SpreadsheetTriggerBuilder tied to the spreadsheet with the given
ID.
ScriptApp.newTrigger('myFunction')
.forSpreadsheet('1234567890abcdefghijklmnopqrstuvwxyz')
.onEdit()
.create();
Parameters
| Name | Type | Description |
|---|---|---|
key | String | the ID for the spreadsheet |
Return
SpreadsheetTriggerBuilder — the new SpreadsheetTriggerBuilder
timeBased()
Creates and returns a ClockTriggerBuilder for building time-based triggers.
ScriptApp.newTrigger('myFunction')
.timeBased()
.atDate(2013, 10, 31)
.create();
Return
ClockTriggerBuilder — the new ClockTriggerBuilder