Linking two tables together to compare LatLong and find the closest person (GeoFencing)

I am wondering how to link two tables together (reference) so i can use LatLong in two scenarios:

1st Scenario:I am looking at Table 1 on a map (contains assets) and i want to know which is the closest driver (Table 2 ) to an asset based on LatLong

2nd Scenario: I am looking at Table 2 on a map (drivers) and i want to know which is the closest asset (Table 1)to a driver based on LatLong

I will need to, if possible, use VC

Solved Solved
0 31 1,654
1 ACCEPTED SOLUTION

@Tiger for AppSheet to grab the label instead of the key in that instance, I believe you need to mark it as a Ref column.

View solution in original post

31 REPLIES 31
Top Labels in this Space