In a formula-type column, the GEOLOC() function returns the geographic coordinates (latitude and longitude) of a full address.
Syntax
GEOLOC(address)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotation marks.
- do not use quotation marks for numbers.
Parameters
Examples
Geolocate an address
GEOLOC("12 Rue de Rivoli, 75004, Paris")
→ The result corresponds to the geographic coordinates, in the form longitude ; latitude.
Return type
The function returns a value of type coordinates (longitude ; latitude).
The output format type of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business use case
GEOLOC() geolocates your addresses: tracking points on a map view, optimizing delivery routes, visually displaying client locations.
Best practice
To isolate a component or measure a distance, combine GEOLOC() with COORDX(), COORDY(), COORDINATES(), and DISTANCE().
Go further
DISTANCE()
Calculate the straight-line distance between two coordinates.
Or continue with
Formula glossary
All available operators and functions, sorted by category.