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.