Address

The address field is used for storing an address. It can store three street address lines, a city, a state (or province/region), a postal code, and a country.

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 “Address” from the list of field types.
  6. You can continue adding fields or click the “Select” button to finish adding.

Features

Field Label

Grid Appearance

Tooltip

Block Association

Default Value

Regionalization and Geolocation

Validation

Data Security

Field parts

The address Field has up to 10 parts:

  • Street
  • Street 2
  • Street 3
  • City
  • State
  • Postal Code
  • Country
  • Address Type
  • Latitude (when Geolocation is enabled)
  • Longitude (when Geolocation is enabled)

Output formats (where applicable)

The address Field has twelve different output formats:

  • Full Field - This output format returns the Street portion of the address, then a newline character, then Street 2 of the Address, then a newline character, then Street 3 of the Address, then a newline character, then City, comma, space, State, space, Zip Code.
  • WX Stored Value - This output format returns the internally stored XML for the address Field. Use this format when saving the entire address from one Field to another address Field, or when setting a default value for an address Field. Whenever this format is used, the “Return results as” setting must be set to “HTML.”
  • Address Type - this output format returns 'International' if the address is of the International format, and 'United States' if the address is of the United States format.
  • Street - This output format returns the Street part of the address Field.
  • Street 2 - This output format returns the Street 2 part of the address Field.
  • Street 3 - This output format returns the Street 3 part of the address Field.
  • City - This output format returns the City part of the address Field.
  • State - This output format returns the State part of the address Field.
  • Zip Code - This output format returns the Zip Code part of the address Field.
  • Country - This output format returns the Country part of the address Field.
  • Latitude - This output format returns the latitude of the address when geolocation is enabled otherwise it will return an empty string
  • Longitude - This output format returns the longitude of the address when geolocation is enabled otherwise it will return an empty string

Filters

The address field can be filtered using the address filters.

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