Guide
Location field stores location as an address or coordinates.
How to add a location field?
Navigate to an entity where you want to add the location field, click New Field on the right and select Location.
How to set values in the location field?
Location field can store partial address or full address. To add a location, just start typing and you will see a list of potential addresses below.
You can also paste some addresses to narrow the search.
Please, make sure that your address is in the correct format
We don't plan to fasten the address auto-correction in the near future.
How about coordinates?
Sometimes you have coordinates that are not linked to any address. In this case, you can just store exact coordinates in a location field. Paste coordinates into the field and click Keep as coordinates option.
Visualize Location on Map View
Location field works best with Map View. Here you can visualize location values as items on a map:
How to extract Country, City, and other parts from the Location field?
You can extract address parts from the location field using Formulas.
Create new Formula and invoke AddressPart function. It has two parameters:
Location Field Name.
Address Part Name: country, region, postcode, district, place, locality, neighbourhood, address, poi
For example, to extract a Country from a field named Location, you have to create this formula:
AddressPart(Location,"country")
Here is the full specification of the AddressPart function
Extracts specific parts of the address component. Available options (case-sensitive):
Generally recognized countries or, in some cases like Hong Kong, an area of quasi-national administrative status that has been given a designated country code under ISO 3166-1.
Top-level sub-national administrative features, such as states in the United States or provinces in Canada or China.
Postal codes used in country-specific national addressing systems.
Features that are smaller than top-level administrative features but typically larger than cities, in countries that use such an additional layer in postal addressing (for example, prefectures in China).
Typically these are cities, villages, municipalities, etc. They’re usually features used in postal addressing and are suitable for display in ambient end-user applications where current-location context is needed (for example, in weather displays).
Official sub-city features are present in countries where such an additional administrative layer is used in postal addressing, or where such features are commonly referred to in local parlance. Examples include city districts in Brazil and Chile and arrondissements in France.
Colloquial sub-city features are often referred to in local parlance. Unlike locality features, these typically lack official status and may lack universally agreed-upon boundaries.
Individual residential or business addresses.
Points of interest. These include restaurants, stores, concert venues, parks, museums, etc.
Here we have two formulas that extract Country and Zip code from the Location field. Note that in some cases this information can not be extracted and the result will be empty.
Creating a report by Country
Then you can use these formula fields to filter data and do other things.
For example, you have a Contact Database with addresses, and you want to create Reports to see in contacts distribution by countries.
Create a Country formula field as shown above
Create a new Report for Contact Database
Select the Country field as a row
Set Bar Chart as a Chart Type
You can create other reports by Region, District, or City.