Actions
Formulas are assigned to actions like On click, On switch or On input. If a user performs an action, the according formula is executed.
The available actions depend on the widget type. So an "On click” action is available for a button widget, but not for a menu widget. The following actions are available:
On open - executed when a page is opened.
On close - executed when a page is closed.
On click - executed after the user clicks on the widget, e.g. a button, a table cell or an element of a chart. This action is executed as well if the selection of a table cell is changed with cursor keys.
On input - executed after the user enters a new value into a cell widget or a table cell.
On switch - executed after the user switches a menu.