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


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. 



Column Types


There are four Column Types to choose from the drop-down button. 


Normal


The default column type is Normal which allows you to select from the available data types mentioned above. 


Calculated



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



Item List



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. 



Lookup



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.


Data Types


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.


Default View 

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 gr


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.



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 Number have very similar Size & Format tab. It consists of Number Formatting and Column Constraints.  






Number Formatting(1): More detailed formatting for numbers. 


Column Constraints(2): 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 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



Maximum number of characters(1): 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(2): 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 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(1): Controls if the values in the columns are Date, Date and Time or Time. 


Display Format(2): This allows you to set more specific formatting to your cell value.