Columns

TeamDesk tables are organized into columns. Each column contains a value corresponding to a specific attribute of a table record, such as First Name, Last Name, Company, and so on:

Table Columns

In Setup mode, Columns are listed on the Columns form, where users can add new columns, create new Reference columns, Lookup Columns, and Summary Columns. Users can also edit or delete existing columns, set Key Columns, and specify Column Access rights.

To access the Columns form, click the Setup link in the top right corner of the window.

Select the table you need.

From the setup menu, choose Columns > Customize existing columns. The system will display a list of columns within the table.

The table column list is grouped by type and sorted alphabetically.

Firstly, you can see all updatable columns:

Columns list

Next, formula columns are displayed with a formula preview:

Formula Columns

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

Lookup Columns

Next, you’ll find all selections/details with all summary columns and recordset columns:

Summary & RecordSet

Finally, all system columns are displayed:

System Columns