Formatting International Address(s).
I'm working on an application that will contain people from multiple countries. I would like help on how to create one formatted address to work with all countries.
Thanks in advance,
Not all of us are familiar with international address formats. Can you post some examples of what they might look like?
Here are some examples:
City, State, Zip
The solution I came up with is to have a multi-line text field, then the person could format the address any way they want. The problem I see with that is trying to put a filter on let's say on city, since city can appear anywhere on the second line.
Thanks once again,
No I wouldn't use a multi-line text field. The street, city, state, zip and country fields should all be data in separate fields. They can be combined via calculation or in merge fields to produce any one of these formats and there are many ways you could do that.
Here's just one out of many possibilities:
Use a calculation field set to return text with a case statement to select the correct/desired address format:
Case ( Country = "USA" ; List ( Street ; City & ", " & State & " " & Zip ) ; EuroFormat = "zip" ; List ( Street ; Zip & ", " & City ; Country ) ; List ( Street ; City & ", " & zip ; Country ) )
EuroFormat would be a field formatted with a valuelist where the user can specify zip before city. It they do not select an option, it defaults to city before zip.
Thank you so much,
This will get me started, I might need some more help in the future.
Retrieving data ...