UI Attributes
search

Matrix

The "Matrix" UI Attribute is used to reposition initialisation variables on the screen. Furthermore you can use formulas to use calculations between variables.

A Table that contains a Matrix UI-attribute needs to have at least one initialisation variable or it will not be shown on the screen.

 

Used on Table
Possible values Strings
Possible domains n/a
Allow html Yes

How to use

  1. Open the Properties of the table and click the tab "UI Attributes".
  2. Click on "Add".
  3. Select the option "Matrix" from the dropdown menu.
  4. Click on the "Matrix" button to open the Matrix Editor.
  5. Press the "Ok" and then the "Add" button to add the to the UI Attributes list.
  6. Click on "Save Changes".

Insert and deleting columns and rows

When opening a new Matrix you will see a 2-column matrix with 2 rows.

Insert row

To insert a new row, perform the following steps:

  1. Select the cell you want the new row to appear.
  2. Right-click the selected cell.
  3. Choose from the dropdown list the option "Insert Row above" or "Insert Row below" depending on whether you want the row to be added above or below the selected cell.
  4. The new row will appear above/below the selected cell.

Insert column

To insert a new column, perform the following steps:

  1. Select the cell you want the new column to appear.
  2. Right-click the selected cell.
  3. Choose from the dropdown list the option "Insert Column before" or "Insert Column after" depending on whether you want the column to be added before or after the selected cell.
  4. The new column will appear before/after the selected cell.

Cell basics

Each cell in the Matrix can contain different types of content, including text, variables, value references and formulas.

Text

Cells can contain text, such as letters, numbers and html. To insert text in a cell, double-click a cell. A new window will open where you can type the content you want.

Make sure that the HTML is properly formatted, else it can result to unwanted behaviour.

Variables

Each cell can contain a single variable. To insert a variable, right-click on the cell you want to insert the variable and click "Insert new variable" when you want to create a new variable or click on "Insert existing variable" to choose a variable in the Knowledge Base.

Each variable in the Matrix will automatically be added to the initialisation list of the table.

 

Value reference

Value references can be added to the Matrix for displaying purposes or to be added to the formulas. To insert a value reference, double-click on the cell you want to insert the value reference. A new window will open. Use the "Value" keyword to insert the value reference.

Formulas

Formulas in Matrix are used to perform live calculations on the screen.