Setup Actions & Advanced filters

Setup Actions feature allows you to setup certain behavior on some data change in the table.

Setup Actions feature allows you to set certain behavior on some data change in the table. This feature is available in panels:

Setup Actions consists of two options:

  1. Filters — where you can set up filters for different columns

  2. Actions — where you can set up multiple actions, based on data in rows & columns.

Actions

Currently, Quantower tables support four types of actions:

  • Show message

  • Play sound

  • Color row

  • Color cell

The Table actions functionality can be found under the panel’s context menu option “Setup Actions” and once launched, it opens an “Actions screen”, where you can manage your Actions. The process of Action creation is not complicated.

  1. Create an Action item

  2. Set conditions (“OR” & “AND”)

  3. Set tasks (Show message, Play sound, Color row, Color cell)

  4. Save Action

  5. Enable Action

Table actions tasks

Once some condition is met, action will execute the corresponding tasks. Each task will be executed as many times, as the condition was met.

Show message

Displays a popup box with the user-specified message

Play sound

Plays some user-selected sound file

Color row

Changes the styling of the whole row, where the condition was met. Allows changing the background and/or text colors.

Color cell

Changes the styling of the specified cell(s) of the row, where the condition was met. Allows changing the background and/or text colors.

Be careful with the frequently occurring conditions. Some may be met several times per second, so tasks like “Play sound” can become disturbing. The “Show message” task, fired several times, will be shown as one message box.

Table filters

Rows in the table can be filtered by some data values in their column. There are two ways to apply the filtering:

  • Quick filtering can be accessed by clicking the “Filter” icon in any table column’s header.

Once you select some option — the table rows will be filtered to those ones, containing the selected value. Quick filter can be canceled by pressing “Cancel filtering” option.

Quick filtering can be applied only to one column of the table. For filtering multiple columns, we recommend using “Setup actions”.

  • Advanced filtering, for applying more complex filtering (multi-filtering). Select in the panel's context menu option “Setup actions”.

This screen has two tabs on the left side, where the first one is an Advanced filter.

This screen allows you to Enable/disable filtering as well as set up filtering Conditions. These conditions are set up as:

IF(condition1ANDcondition2...)OR(conditionN...)IF (condition1AND condition2 ...) OR (conditionN...) …

You can setup as many conditions as you like. Due to the possible complex logic of filtering, you are required to apply the changes once you finished the filter set up.

Last updated