To add, remove or change your column properties open the table designer by clicking the Designer button in the upper right corner of your open table.

You can add and remove columns in the bar on top as well as rearrange their order. The order will affect how the columns will be displayed, from left to right in the table itself.



Column Properties


Data Types

Allowed data types: String, Number, Decimal, DateTime 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.


Column Types

Normal

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


Calculated

Calculated column is a column where the value is calculated from other columns. In our example the columns Amount and Price are columns of the number data type. To calculate the total price we multiply Amount with Price

Another example would be to set the Total Price columns data type to String and the Expression as 'Total Price' + [Amount]*[Price].


Item List

Columns that should have values from a fixed set of items can be made as item list columns. In the List Items tab you can add the values that should be available to select in the table. These items will be displayed in a drop down on cells in this column.


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. 


Further details can be found under Lookup Column.


Default View

Visible: Specifies weather the column is visible or not.


Group the data by this column: If we set this attribute of the Year column as true it will group the values of it together and be displayed like this:



Show as filter: Columns that are selected to show as filters will be displayed on the right of the table and you can filter your data by selecting items in the lists. For example, by going back and selecting our Year column as filter it will look like this:


Read only: Values of a read only column can not be changed.


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.