Column Types

A column type is defined by a type of data you want to input to a column. It doesn’t only help to enter and display data accurately; it also defines the data processing such as configuring or calculating.

TeamDesk allows a user to create the most frequently used column types (Text, Numeric, Date, etc) as well as special column types (Formula columns, Summary columns, Lookup columns) and generates System columns.

Assume you or your database users want to enter a Client Name, Phone number or Date of Birth to the created database. Just select the Text type, the Phone number type and the Date type for the columns respectively. If you want to enter a Client Address or another data containing a long description, we recommend you to choose the Text-Multi-line type for this column.

Column Type

Description

Text

This column type allows a user to enter single-line data in a simple text format limited by the width of # characters.

Text – Multi-line

This column type allows a user to enter multi-line data in a simple text format. The column of this type supports basic text formatting; the number of characters is not limited.

Numeric

This column type allows a user to enter numbers in a simple numeric format (integer numbers by default).

Numeric – Currency

This column type allows a user to enter numbers in the currency format, for example, $25.35.

Numeric – Percent

This column type allows a user to enter numbers in a simple numeric format that will be represented as percentage.

Numeric – Rating

This column type allows a user to enter rate value in the predefined range.

Date

This column type allows a user to enter date value in the predefined format. The date in the column can be entered manually or with the help of the Calendar icon located to the right of the field.

Time

This column type allows a user to enter time value in the predefined format.

Duration

This column type allows the user to enter a duration period up to the second, for example, 12.35 h.

Timestamp

This column type allows a user to specify a composite value containing time and date values together, for example: 10/24/2006 5:57 PM. Note that this composite value is stored in timezone independent format and displayed with regard to current user’s timezone.

Checkbox

This column type is represented as a check box; a user should select it if the condition described in the column name is true, and leave it not selected if the condition is false.

Phone Number

This column type allows a user to enter a telephone number.

E-mail Address

This column type allows a user to enter an e-mail. Note that ‘at’ symbol (@) and a top level domain should obligatory be present in this field.

In the E-mail address field the Default Domain option can be used: in this case: the user can enter only the beginning of an e-mail address (up to the ‘at’ symbol (@)); the domain part will be added automatically.

User

This column type allows a user to select an entry from the list of users currently registered in a database.

File Attachment

This column type allows a user to attach a file stored on the computer or in the local area network to a record.

URL

This column type allows a user to enter an URL (a locator of a document in Internet), for example, http://teamdesk.net.

AutoNumber

This column type allows a user to enter a value that will be automatically incremented when a new entry in the table is added.

Barcode

It allows entering specific code via input field on edit form and display it as a QR code or barcode image on views, record preview forms and documents.


Using Formula-Columns you may calculate or generate a combination of some other columns. For example, you want to calculate the Total Price in your invoice or join the First Name column and the Last Name column in one Client Name column.

Column Type

Description

Formula-Text

This column type allows a user to specify a formula configuring a required text value.

Formula-Numeric

This column type allows a user to specify a formula calculating a required numeric value.

Formula-Date

This column type allows a user to specify a formula calculating a required date value.

Formula-Time

This column type allows a user to specify a formula calculating a required time value.

Formula-Duration

This column type allows a user to specify a formula calculating a required duration value.

Formula-Timestamp

This column type allows a user to specify a formula calculating a required timestamp value.

Formula-Checkbox

This column type allows a user to specify a formula configuring a required check box value.

Formula-Phone Number

This column type allows a user to specify a formula configuring a required phone number value.

Formula-E-mail Address

This column type allows a user to specify a formula configuring a required e-mail address value.

Formula-User

This column type allows a user to specify a formula configuring a required user value

Formula-URL

This column type allows a user to specify a formula configuring a required URL value

Formula-Barcode

This column type allows a user to specify a formula, that will generate a barcode or a QR code

Formula-XHTML

This column type provides the way to decorate the value with tags and styles. It is a mixture of limited (X)HTML markup and TeamDesk formula language


There may be times when you want to represent specific data or calculation of specific data from the other tables. TeamDesk comprises special columns for these purposes.

Column Type

Description

Reference Column

This column appears in a detail record and lets users select the master record that the detail is related to.

Summary Column

This is a column in the master table used to represent calculation of specific data from the detail table.

Lookup Column

This is a column in the detail table used to represent a specific data from the master table.

System Column

This column is generated automatically as an essential attribute of your table.

Next: Creating New Columns