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	Description
Format Phone	Possible phone formatting options: None turns off validation and formatting. On View keeps user’s input as-is, formats phone on the fly prior to display. On Save attempts to validate and format user’s input prior to saving it to the database. By Pattern uses “pattern-by-example” validation.
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 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
Message	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:

Help	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