top menu gradient

Run cells based on an interval

By using the DO_EVERY() function, you can run one or more action cells every time period (in milliseconds).

The example below just shows how the DO_EVERY() function works in principle. In practice, this function is used to define the behavior of your application, which also requires linking a user action, such as a mouse click or a keystroke, to running an action cell with the DO_EVERY() function.

As an example, in cell B2, create an action cell with the RANDOM() function, like so:

=?RANDOM()
Copy to clipboard

In cell B1, use the following formula to run RANDOM() in cell B2 every second:

=?DO_EVERY(B2,1000)
Copy to clipboard

When you click on cell B1, the timer starts, and the value in cell B2 starts changing every second.

Try it now

Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
Contents