Dynamic Table

The Dynamic Table type lets the user select a row from a dynamic table managed by the administrator (Administration › Integration and Data Management › Dynamic Tables). The user sees the value of the selected column, and the variable stores the whole row. The type is useful for shared code lists such as branches, cost centres, suppliers and currencies. You configure it in the variable editor (Templates › template › Variables › variable). The common part of the editor is described in the article Variables: Overview and Common Settings.

The examples use the table "Office locations" with the columns Code, Name, Address, City and Country and four branches.

Settings

No.FieldPurpose
1TableRequired. The dynamic table whose rows are offered. When you change the table, the column, sorting and filter are cleared.
2ColumnRequired. The column whose value the user sees in the list.
3Sort by columnThe column used to sort the list. If left empty, the order from the table is kept.
4SortingAscending (default) or Descending. Applies only when a sort column is set.
5FilterConditions a row must meet to be offered. Each condition has a column, an operator and a value. Operators: =, <>, >, >=, <, <=, contains, does not contain, is empty, is not empty. For the is empty and is not empty operators, no value is entered. Use the icon on the right of the value field to insert the placeholder #userName# (user name) or #userId# (ID of the logged-in user). Use the bin icon to remove a condition; the last condition is only cleared.
6Add rowAdds another filter condition. All conditions must be met at the same time.
7Parameters (URL)Additional parameters of the table query. Use the icon on the right to insert distinct=true, which removes duplicate values from the list.
8Allow multiple selectionThe user can select multiple rows.
9Display selection as tagsA drop-down selection with tags. Without this option, the field has two lists, the offer and the assignment, plus further options as for a dynamic list: Allow selection of all items, Allow search in assignment and Double height for content.

The Office access variable in the image offers only branches in the Czech Republic (filter Country = Czech Republic), sorted by city, with multiple branches selectable as tags.

Object State and AI Translation

No.FieldPurpose
1Allow AI translationOnly when AI is enabled and only without multiple selection. In a read-only field, the user can have the value translated.
2State variableMarks the variable that holds the object state from an imported state diagram (the Object State section is available only for the dynamic table). Such variables are created and paired with tables by the object state import, see the article Class Diagram, State Import and Alias Candidates.

How It Looks in the Form

Office location is a single-branch selection, Office access is a multiple-branch selection shown as tags. Remove a tag with the cross.

The Office location list shows the Name column sorted in ascending order. The user can type to narrow down the list.

Changes in the table
The list is loaded from the table each time it is opened, so changes to rows take effect immediately. However, if you delete a row that cases have selected, they lose its data. Avoid deleting rows that cases already use.

Related: Variables: Overview and Common Settings, Dynamic Tables, Dynamic List, Code Lists.

Sequence
Syca (opens in a new tab)

Powered by HelpDocs (opens in a new tab)