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
, Selector])
Arguments
Name | Description |
---|---|
Streamsheet | Name of Streamsheet to trigger. (Put the name of the Streamsheet in quotes e.g. "S1") |
Repeat | Optional. Number of repetitions. If larger than 1 (Default), the execute function will be executed multiple times |
JSON | Optional. JSON to use as message data to process, when executing. |
Selector | Optional. Selector to use when selecting a message from the inbox for processing. |
Return Value
NOTE: if the execution of the triggered StreamSheet is stopped via the RETURN function, its result is returned instead.
Example
Function | Result | Comment |
---|---|---|
=EXECUTE("S2") | TRUE | Triggers the calculation of a second Streamsheet, called "S2". |