EXECUTE
Triggers the recalculation of another Streamsheet. The executed Sheet will only be executed if Streamsheet settings of executed Sheet allow execution. Calculate Streamsheet "On Execute".
Syntax
=EXECUTE(Streamsheet, [Repeat], [JSON], [Delay])
Arguments
| Name | Type | Description |
|---|---|---|
| Streamsheet | Sheet | Name of Streamsheet to trigger. Options: |
| Repeat (optional) | Number | Number of repetitions. If larger than 1, the execute function will be executed multiple times Default value: 1 |
| JSON (optional) | JSON | JSON to use as message data to process, when executing. |
| Delay (optional) | Number | The delay in seconds before repeat next execute. |
Return
| Type | Description |
|---|---|
| Boolean | NOTE: if the execution of the triggered StreamSheet is stopped via the RETURN function, its result is returned instead. |
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Triggers the calculation of a second Streamsheet, called "Sheet2". |