GoogleDistance

Description of formula:
Formula can be used to calculate  google distance between two points, formula returns distance in meters or travel time in seconds.
Remark:
You can't check in preview if this formula is working!!!
External data source
Function use API of google developers Distance Matrix, 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:
GoogleDistance(Origins, Destination, Region, TravelMode, ReturnTime)
or
GoogleDistance(Origins, Destination)
Parameters:
Origin
(type: text) Starting point for calculating travel distance or time
Destination
(type: text) Finishing point for calculating travel distance or time
Region
(type: text)(optional parameter) The region code, specified as a "top-level domain" two-character value, limits distance calculation to this region, for example: pl, uk; list of codes you can find here.
TravelMode
(type: text)(optional parameter) Transportation mode, possible values are: driving (default), walking, bicycling, transit
ReturnTime
(type: logical value)(optional parameter) If true, formula returns time in seconds; if false, returns distance in meters (default)
Returned type:
Number
Examples:
=GOOGLEDISTANCE('King's Cross station', 'Trafalgar square', 'uk', 'walking', true)
=GOOGLEDISTANCE('King's Cross station', 'Trafalgar square')

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk