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.

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.

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

• Field Label
• Field Setting - Display Alternate Label (affects this form only)

• Column Span
• Row Span

• Sizing

• Tooltip
• Descriptive Text
• Display Alternate Descriptive Text (affects this form only)

• Temporary Block Association
• Global Block Association

• Default Value

• Phone Extension

• Regionalization

• Required
• Maximum Length

• Audit This Field
• Show Audit History

• View Only

The Phone Number Field has six parts:

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

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.

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.