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
Click the
to add a field in your
form.
Choose “New Field”
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.
Select a field name and click “Choose Type”.
Choose “Address” from the list of field types.
You can continue adding fields or click the “Select” button to finish adding.
Features
Field Label
Grid Appearance
Block Association
Default Value
Regionalization and Geolocation
Validation
Data Security
Field parts
The address Field has up to 10 parts:
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