GoogleLocation

Description of formula:
Returns google location results and can be used only in items of autocomplete cell.
Remark:
You can't check in preview if this formula is working!!!
External data source
Function use API of google developers Geolocation, so data are taken from external source. Function will start working when you open admin and External Data Sources tab, choose source you want and turn on. To do this, you need to check Enabled and enter ApiKey. How you can get ApiKey you can read here.
Syntax:
GoogleLocation()
or
GoogleLocation(type)
or
GoogleLocation(type, country)
Parameters:
type
(type: text)(optional parameter) Type of location to return, available types: 'geocode', 'address', 'establishment', '(regions)', '(cities)'
country
(type: text)(optional parameter) Limit google search to specific country given as two-letter code compatible with ISO 3166-1 Alpha-2; list of codes here.
A detailed description of the location types (first parameter):
- geocode - returns all places except businesses
mceclip0.png
- address - returns results with specified address
mceclip1.png
- establishment - returns only businesses
mceclip2.png
- regions - returns cities, regions, postal codes, countries, states and city districts
mceclip3.png
- cities - returns only cities
mceclip4.png
More about returned places you can read here. 
Returned type:
Autocomplete
Examples:
=GOOGLELOCATION() - returns all possible locations
=GOOGLELOCATION('(CITIES)') - returns cities from all over the world
=GOOGLELOCATION('ESTABLISHMENT', 'PL') - returns only locations that are businesses in Poland
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk