Any feedback on the new address field type?

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered
The new address fields are an interesting feature and I would like to ask what you think about them. So feel free to add your thoughts and feedback under this thread.

Here are some of my thoughts and discoveries:

Adding a new address field, say [Address] actually creates multiple fields. If you name your address field [Address] then the following fields are created but not displayed:
[Address: Street 1]
[Address: Street 2]
[Address: City]
[Address: State/Region]
[Address: Postal Code]
[Address: Country]
So creating a new address field will actually create seven fields in total - one address type field and six additional composite fields of type text that are hidden from view but nevertheless can be used in formulas.

This is what the schema of an address field looks like:

<field id="10" field_type="address" base_type="text"> <label>new</label> <nowrap>0</nowrap> <bold>0</bold> <required>0</required> <appears_by_default>1</appears_by_default> <find_enabled>1</find_enabled> <allow_new_choices>0</allow_new_choices> <sort_as_given>0</sort_as_given> <width>60</width> <carrychoices>1</carrychoices> <foreignkey>0</foreignkey> <unique>0</unique> <doesdatacopy>1</doesdatacopy> <fieldhelp/> <compositeFields>
<compositeField id="11" key="street" isHidden="0"/>
<compositeField id="12" key="street2" isHidden="0"/> <compositeField id="13" key="city" isHidden="0"/> <compositeField id="14" key="region" isHidden="0"/> <compositeField id="15" key="postal" isHidden="0"/> <compositeField id="16" key="country" isHidden="0"/> </compositeFields></field>

An address field and its composite fields show up in the API with tag names derived by the same algorithm as other fields (lowercased with special characters substituted with underscores):

<address>1600 Pennsylvania Ave NW, Washington, District of Columbia 20500</address> <address__street_1>1600 Pennsylvania Ave NW</address__street_1> <address__street_2/><address__city>Washington</address__city> <address__state_region>District of Columbia</address__state_region> <address__postal_code>20500</address__postal_code> <address__country>United States</address__country>

Note the double underscores derived from the colon and space in the composite field names.

A bit of an oddity is that if even if you enter a state abbreviation such as MI into the address field that full state name Michigan will be saved in the [Address] field and the composite field [Address: State/Region]. This may cause problems if the address field is going to be used for mailing labels.

Also, for US addresses the address field only seems to recognize the fifty states and DC. The following address in Puerto Rico when entered into an address field results in an empty record with no warning:
203 Calle Fortaleza APT 2, San Juan, PR 00901

The [Address: State/Region] field does not support these localities: American Samoa (AS), Guam (GU), Marshall Islands (MH), Micronesia (FM), Northern Marianas (MP), Palau (PW), Puerto Rico (PR), Virgin Islands (VI).

If you intend to use your address field for mailing purposes there are additional problems with military addressing, rural routes, urbanization etc. A thrilling reference for proper addressing of US mail is the following 210 page document:

http://pe.usps.gov/cpim/ftp/pubs/pub28/pub28.pdf

Also, it appears you have to select a single county as part of the address field definition. So if you want to use the address for both US and Canadian addresses you may be out of luck.


Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb

Posted 5 years ago

  • 0
  • 1
Photo of David

David

  • 80 Points 75 badge 2x thumb
Anyone else having a problem using the new address field in a form rule?
Photo of Soumya

Soumya

  • 0 Points
Hi David - You can create form rules that show & hide address fields based upon criteria. We plan to release the ability to trigger form rules based upon the individual components of the address fields in the next couple of weeks. For example, you will be able to create a rule to that is triggered when, say, Mailing Address: City = "Boston". I will update this thread once we release that enhancement.
Photo of Steve

Steve

  • 0 Points
How about related to the API.  Can I send address info using API_AddRecord?
Photo of Soumya

Soumya

  • 0 Points
Yes you can. The individual components of the address fields are writable and you can use those to write to them in API_Add/Edit Record calls. In the  example above, you would write to fids 11, 12, 13 etc.
Photo of vdragland

vdragland

  • 0 Points
You don't have to select a single county as part of the address field definition. Use "international."
Photo of Xavier Fan

Xavier Fan, Champion

  • 340 Points 250 badge 2x thumb
When you show a component of the address (e.g. "Street 1") in a report, would be nice to have an option to get the same "popup map" link as when you're displaying the full address.
Photo of Soumya

Soumya

  • 0 Points
You now have the ability to create form rules that trigger on individual components of an address field.
Photo of David

David

  • 80 Points 75 badge 2x thumb
This is still not helping my cause. I have a start address and end address with a url button to show the distance and routes through google maps. I want to create a checkbox that will put the end address into the start address and then blank out the end address. Obviously, this is to create a way to plan from one route to the next for say a service technician. I still can't create a form rule that says "when the box is checked, put the end address into the start address, then blank out the end address" so that only one address has to be entered.
Photo of Fearghal

Fearghal

  • 0 Points
Why cant the new address feild map for international addresses , only displaying the USA addresses on the map.????
Photo of Xavier Fan

Xavier Fan, Champion

  • 340 Points 250 badge 2x thumb
In the Settings for your Address field, under "Address field options", change "Format" to "International", and then you can you display international addresses on the map.
All our addresses are United Kingdom and it always defaults to United States so its not so useful for us at all?
Photo of Jonathan Heuer

Jonathan Heuer

  • 306 Points 250 badge 2x thumb
I'd like to be able to use the two letter abbreviation for the state, instead of the spelled out version (MI instead of Michigan). Besides making my own lookup table, is there some easier way to do this?