Unbound Column
- Last UpdatedFeb 19, 2023
- 2 minute read
If you add a new column to a View in the Designer, then this new column can be bound to a database field, after which the database field will be shown in that column. Another option is to define unbound data for that column, i.e. not binding the column to a database field, but adding data that is unrelated to a database field, such as a formula.
Create an unbound column
To create an 'unbound column', follow these steps:
-
Create a new column in the View Designer, using the button 'Add column'. A new column will appear in the View design
-
In the property pane on the right side of the screen, change the property 'UnboundType' from 'Bound' to a desired data type, e.g. String or Integer
-
Now select the property field 'UnboundExpression', and invoke the Expression editor by clicking the button ´...´
-
In the Expression editor, create an expression using the operators, formulas and possible references to database fields
-
Save the expression by clicking the OK button.
Tip: More information about the formulas offered in the Expression editor is displayed when a formula is clicked.
Tip: Unbound columns created in the Designer will appear in the View. They can also be used in a report created with the Design report.