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
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 "S2". |