Phone Number Columns

Phone Number columns can comprise Work Phones, Home Phones, Cell/Mobile Phones or Fax Numbers. TeamDesk ignores alphabetic characters you enter in this column type.

TeamDesk parses data from Phone and Formula-Phone columns. The system decorates them as Skype links on desktops and tablets and as links to invoke phone dialer on mobile phones.

Skype requires phone numbers to contain a country code. If the column data is missing a country code, TeamDesk infers the code from database Language and Location settings.

When a text is entered and stored in the Phone Number column, it is decorated as a link. Also, there is the tooltip that displays the phone number formatted according to your country rules.

If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.

Properties defined by the column type:

Phone columns are also extended with pattern validation options.

The system allows phone formatting – using the same Google’s phone formatting library that powers Android-based phones.

Phone Number Options

Column Property


Format Phone

Possible phone formatting options:


turns off validation and formatting.

On View

keeps user’s input as-is, formats phone on the fly prior to display.

On Edit

attempts to validate and format user’s input prior to saving it to the database.

By Pattern

uses “pattern-by-example” validation.


If the “By Pattern” option is chosen in the Format Phone dropdown. You should specify the format, that should be applied to phone column values.



0 or #

Any digit: 0 to 9


Uppercase latin letter: A, B… to Z


Lowercase latin letter a, b to z

Z or z

Any latin letter


Latin letter or digit


Any character


Suppresses any special meaning of the character that follows, e.g. \* means “star”, not “any character”

any other

Treated literally


If a user input does not match the pattern, the message specified in the Message property is displayed.

Also, in phone formulas Format Phone option is a checkbox. Formulas either do nothing (Format Phone unchecked) or format phones on the fly (checked).

Help text message:


When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.

Next: E-mail Address Columns