Description of formula:
Returns google location results and can be used only in items of autocomplete cell.
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 sourceFunction 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()
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

- address - returns results with specified address

- establishment - returns only businesses

- regions - returns cities, regions, postal codes, countries, states and city districts

- cities - returns only cities

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
0 Comments