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
If a column contains data that doesn’t appear or behave as desired, you can edit the column’s General Properties.
Advanced Options
Properties defined by the column type:
- Format Phone
- Possible phone formatting options:
- None: Turns off validation and formatting;
- On View: Keeps the user’s input as-is and formats the phone on the fly prior to display;
- On Save: Attempts to validate and format the user’s input prior to saving it to the database;
- By Pattern: Uses "pattern-by-example" validation.
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.