To add, remove or change column properties press the Table Designer(1) 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(1), Data Types(2) and Default View(3). In this article, we will walk through these parts and explain how these properties can be helpful when working with data.
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: String, Number, Decimal, DateTime, Number, Large Number and Checkbox. For all data types, except for checkbox, a Formatting tab will appear next to the Default View tab. The Formatting tab will give you control of how your values are displayed in exTables.
The default View contains properties that all columns have in common.
Visible(1): Specifies whether the column is visible or not.
Group the data by this column(2):
If we set this attribute of the Product List column as true it will group it's values together like the picture above.
Show as filter(3):
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(4): Values of a read only column can not be changed. Their cells become green.
Min width(5): If the column should only contain a value of a max length you can specify it with this property.
Order by(6): Either ascending, descending or none.
Summary Type(7): Columns can be summarized with either Sum, Average, Count, Max or Min. The summary value will be displayed at the bottom:
Freeze column(8): 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 (9): 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.