Columns

TeamDesk tables are divided into columns. Every column contains a value of a specific attribute of a table record, for example, First Name, Last Name, Company and so on:

In the Setup mode Columns are listed on the Columns form, where a user can add New columns, create New Reference columns, Lookup Columns, Summary Columns. Also a user can Edit or Delete existing columns, set Key Columns and specify Columns Access rights.

To go to the Columns form, click Setup link at the top right corner of the window.

Select a table you need.

From the setup menu select Columns > Customize existing columns. The system will display a list of columns comprised in a table.

Table column list is grouped by type and sorted in alphabetic order.

Firstly, you can see all updatable columns:

Next, formula columns are displayed with formula preview:

Then, relations including reference columns and corresponding lookup columns are listed:

Next go all selections/details with all summary columns and recordset columns:

And at last all system columns are displayed: