Created by: Guðrún Eydís Jónsdóttir
In this article, you are going to learn about the column designer in exMonDM.
- Getting started
- Column Properties
- Column Types
- Data Types
- Default Views
- Size & Format
- To add, remove or change column properties press the Table Designer button in the desired table.
- To add, remove or rearrange their order press the buttons at the bottom of the columns bar. The order will affect how the columns will be displayed, from left to right in the table itself.
Column properties can be divided into three main parts:
- Column Type,
- Data Types
- Default View
There are four Column Types to choose from the drop-down button.
The default column type is Normal which allows you to select from the available data types mentioned above.
A calculated column is a column where the value is calculated from other columns. In the example above the columns Amount and Price are columns of the number data type. To calculate the total price we multiply Amount with Price.
A column that should have values from a fixed set of items can be made as an ItemList column. In the List Items(1) tab it is possible to add or remove(2) the values that should be available to select from the column in the table. As the items have been added to the list they can be previewed in the items(3) table. The values will be displayed in a drop-down list.
A lookup column is similar to item list columns, the possible values are a list of specific values. The difference is that Lookup columns reference another table to create the selection. Simply fill out all the properties above and exMon Data Management will create a drop-down list containing all unique values from the selected source column (1).
Further details can be found in the article Lookup Column.
Allowed data types:
- Large Number
The default View contains properties that all columns have in common.
- Visible: Specifies whether the column is visible or not.
- Group the data by this column
If we set this attribute of the Product List column as true it will group its values together like the picture above.
- Show as filter
If the show as filter attribute is set to true the selected column will show as a filter in the Table Editor view. The filter is displayed on the right side and when an item is selected the grid view will filter the data based on that selection. For example, by checking the show as filter box for the column ProductList and select Apple as our filter, then the grid in the Table Editor view will look like the picture above.
- Read-only: Values of a read-only column can not be changed.
- Min width: If the column should only contain a value of a max length you can specify it with this property.
- Order by: Either ascending, descending or none.
- Summary Type: Columns can be summarized with either Sum, Average, Count, Max or Min. The summary value will be displayed at the bottom:
- Freeze column: You can freeze the position of columns to either left or right. In this example, the columns Price and Product Id are frozen to the left and Year to the right.
- Default Value: You can choose a default value for a column so that every time you create a New Row the cell value for that row will automatically become the chosen default value. For the default values to appear in the grid, first, add a New Row and then select space for the default values to appear.
In the example below, the string column 'Customer' has the default value 'Some Customer'.
When a New Row is created in the Table Editor the default value will appear for that column.
Size & Format
The Size & Format tab contains properties that not all columns have in common. That tab differs depending on the Data Type selected.
Size & Format: Numeric
Double, Decimal, Number and Large Numbers have very similar Size & Format tabs. It consists of Number Formatting and Column Constraints.
- Number Formatting More detailed formatting for numbers.
- Column Constraints: This allows you to set constraints for the column. You can set the Min Value or Max Value so the user gets a warning if his value does not fit inside the range. You can also set a Pattern for the column which warns the user if he tries to insert a value that does not fit into the pattern. You simply insert the pattern in regex form, to the Pattern input field. For example: "[1-3]*" (matches numbers 1-3 zero or more times)
Size & Format: Strings
- A maximum number of characters: Controls how many characters the user can insert to the cell. When the max value is reached he can not add any more characters.
- Column Constraints: This allows you to set constraints for the column. You can set the Min Text Length or Max Text Length so the user gets a warning if the number of characters in the cell does not fit inside the range. You can also set a Pattern for the column which warns the user if he tries to insert a value that does not fit into the pattern. You simply insert the pattern in regex form, to the Pattern input field. For example: "[a-c]" (range; matches a or b, or c.)
Size & Format: DateTime
- Column Type: Controls if the values in the columns are Date, Date and Time or Time.
- Display Format: This allows you to set more specific formatting to your cell value.