Customizing Table Properties

Say you have created a lot of tables and want to mark out some of them or rename.

To customize properties of an existing table:

Click the Setup link in the top right corner of the window.

Select the Database tab.

From the setup menu select Tables > Customize existing tables.

Choose the necessary table from the list; click Edit in a corresponding row.

The following table properties will appear:

General properties



Singular Name

A table name entered in the Singular Name field is displayed in the Setup Mode as a headline, when you customize table objects like views, columns, documents etc.

In the User Mode the Singular Name value is displayed on a record form as a header and in the New Record adding dropdown.

Plural Name

A table name entered in the Plural Name field is shown as a tab name and in the list of tables displayed in the Setup Mode left menu.

In the User Mode the Plural Name value is displayed as a tab name.

Name Column

From the Name Column list select the column which values will be used to represent table records as a short text. For example, the “Full Name” formula-text column is chosen as the Name Column . As a result, by default the Full Name value is displayed on the form title :

Also, by default the Name Column value is displayed in the recycle bin:

Moreover, by default the Name Column is chosen in the Record Picker settings. If in the default record picker the Custom Columns are specified, the values of these columns are displayed in a form title and in the recycle bin.

Tab Color

Click on the Color icon, if you want to change a predefined table tab color to another one. Select a color on the palette opened in the new window. As a result, a table header and headers of all Table views created in this table will be colored.

Please note, that the Tab colorization is applied to the User Mode only.


This option allows to select icons for table headers (tabs). You have a choice of 900+ icons covering various subjects – actions, brands, file types, symbols, animals and a lot more. The Search box above will help you to narrow down the list of choices.

The icon will appear to the left of the table name. Moreover, you can activate the Hide text option, if the table name should be hidden in the User mode.

For example, this is the tab with the name and the icon:

This the tab where the Hide text option is checked:


The Notes field can hold any developer’s comments that need to be kept for this table. The comments will be visible in the Setup mode only.

Default Record Picker Options

When Custom Columns are selected, their values are displayed as a record title on the form and in the recycle bin listing.

Furthermore, the Default Record Picker options define how table records look and act in reference columns created in the other tables.

Search Options

You can specify what columns will be displayed as search results, just activate the Allow Search checkbox in the Search Options. When it is checked, the Custom Columns option is available. Using this option you can add columns, which data will be displayed as table search results.

In case you want to exclude a table from search results, disable the Allow Search checkbox and none search results will be displayed in this table.

Advanced Properties

TeamDesk allows coloring for particular records or areas. The Row Colorization option is included into Table Properties and into View options. If you specify a row colorization formula in Table Properties, it will be applied to all views created in this table. In case you want to apply colorization in a certain view, just edit view settings and add formulas to the row colorization field.

Mark the Row Colorization Formula check box if you want to apply a special colorization formula to certain rows in a table. The system will expand the Row Colorization section. Here you can insert colors, variables, functions and operators to the formula. For example, to highlight green all records that were added by the user, insert the formula: If(UserToEmail([Created By]) = "", "#54C254").

User Interface

Table properties include the User Interface section. It controls user interface appearance. If a table should be hidden for users with a certain role, use the Hide Tab checkbox. As a result a tab will not be displayed in the list at the top of the page. Additionally, visibility of New, Edit and Add Similar buttons is controlled there.

The ability to hide New and Edit buttons can be used when you want to prevent users from creating/editing records via default interface and intend to do it with the help of workflow actions or custom buttons.

Also there is the ability to hide Print/Export/Send buttons on views. While it can’t protect data from stealing, hiding these buttons may help to complicate it.

You may also configure user interface settings from a particular role screen – just click on a role name link. In that case you’ll be able to configure role’s user interface settings for all tables in one click.

Next: Managing Access for Table Records