Telephone

The Phone Number Field is for storing a telephone or fax number (U.S. and International formats are supported). It can store a country code (when International format is chosen), an area code, an exchange (when U.S. format is chosen), a line number and (optionally) an extension.

How to Create

  1. Click the to add a field in your form.
  2. Choose “New Field”
  3. Select the table you wish to add the field to. Most of the time, this will be the current table you are on, called the current context.
  4. Select a field name and click “Choose Type”.
  5. Choose “Phone Number” from the list of field types.
  6. You can continue adding fields or click the “Select” button to finish adding.

Features

Field features can be edited by clicking on the orange field icon when the presentation layer is displayed.

Field Label

Grid Appearance

Sizing

Tooltip

Block Association

Default Value

Phone Extension

Regionalization

Validation

Audit History

View Only

Field parts

The Phone Number Field has six parts:

  • Phone Number Type - either International or United States.
  • Country Code
  • Area Code
  • Exchange
  • Line Number
  • Extension

Output formats

The Phone Field has eight different output formats:

  • Full Field - This output format returns the Area Code enclosed in parentheses (if the Area Code is filled in) followed by a space, then the Exchange, then a hyphen followed by the Line Number. If the Extension is filled in, a ' x' is appended to this number, followed by the Extension (ex. (555) 555-5555 x5555)
  • WX Stored Value - This output format returns the internally stored XML for the Phone Number Field. Use this format when saving the entire phone number from one Field to another Phone Number Field, or when setting a default value for a Phone Number Field. Whenever this format is used, the “Return results as” setting must be set to “HTML.”
  • Phone Number Type - This format returns 'International' if the stored number is of the international format and 'United States' if the stored number if of the United States format.
  • Country Code - This format returns the Country Code part of the Phone Number Field (only applicable if chosen format is International).
  • Area Code - This output format returns the Area Code part of the Phone Number Field.
  • Prefix - This output format returns the Exchange part of the Phone Number Field (only applicable if chosen format is United States).
  • Line Number - This output format returns the Line Number part of the Phone Number Field.
  • Extension - This output format returns the Extension part of the Phone Number Field.

Acceptable inputs

The phone number field has inherent validation such that when the U.S. format is chosen, if an area code is filled in, the prefix and line number must be filled in, and the area code, prefix and line number must have three, three and four digits, respectively. Also, if any of the remaining parts are filled in, the prefix and line number must be filled in with three and four numbers, respectively. When the International format is chosen, the country code is required, and the line number is required when the area code is filled in. The extension is always optional.

field type - telephone.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2020