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

AppSheet AppSheet Q&A
,
1

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

3X_b_6_b668aa033909ff805794a65990baf20437303f3f.png
3X_b_6_b668aa033909ff805794a65990baf20437303f3f.png1099×297 33.3 KB

Table DEPOT
contains the columns:
DepotName - GEO

Is this possible?

Thanks for any help.
Hoover
2

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