Map location in 1 table(lat/long) to the nearest Depot (lat/long) in other table

Hi,

I have a table (UNSTICK) with depots and they all have a column (Geo) with lat/long.
I have a second table (DEPOT) where I get the current position (lat/long) and in that second table I want to show the nearest depot and the distance to that depot.
Here is how I want it ( see first record in UNSTICK)
Table UNSTICK


Table DEPOT
contains the columns:
DepotName - GEO

Is this possible?

Thanks for any help.
Hoover

Please take a look at the below sample app.

https://www.appsheet.com/templates/Initialize-a-form-with-values-from-nearest-location?appGuidString=57a665ac-d646-4fde-a5a4-15d0cc88c92c

1 Like