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 the 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 text is entered and stored in the Phone Number column, it is decorated as a link. Additionally, there is a tooltip that displays the phone number formatted according to your country’s rules.

Phone columns are also extended with pattern validation options.

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

General Properties

Phone Number General Properties

If a column contains data that doesn’t appear or behave as desired, you can edit the column’s General Properties.

Advanced Options

Phone Number Advanced Options

Properties defined by the column type:

Format Phone
Possible phone formatting options:

In the Formula-Phone Number column, the Format Phone option is presented as a checkbox. When this option is left unchecked, the data in the column will not undergo formatting. However, if the checkbox is selected, the value will be formatted automatically.

Pattern
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.
Character Meaning
0 or # Any digit: 0 to 9
A Uppercase latin letter: A, B… to Z
a Lower 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
any other Treated literally

If you want to take advantage of regular expressions, start pattern with regex: and put regular expression afterwards, e.g. regex:\d{3,5} means 3 to 5 digits are allowed.

Message
If a user’s input does not match the pattern, the message specified in the Message property is displayed.
Help
When the Help text property is filled in, a question mark is displayed near the field name on the View/Edit form. If you point to this question mark, a pop-up with a tip or a help text message will be shown.