Calculate Mileage between Multiple Locations

[blaineiler]

I have two tables -- Truck Loads, and Truck Load Stops. Truck Load Stops is a ref to Truck Loads. Truck Load Stop records have a location, and a datetime field for the stop. I am trying to calculate the mileage for the entire route of the truck load, which is essentially the sum of the distances from stop 1 to stop 2, stop 2 to stop 3, etc. I have been doing this in sheets right now, but I have 4 columns for possible stop locations, and run a simple google maps api script to do the summation of distances between the stops. I wanted to migrate this to an Appsheet app to be more structured, and I assumed that Appsheet had a way to calculate distances, but I haven't been able to figure out a way to do this.

[Landan_QREW]

I would recommend using this API.

I just used it on a project to optimize truck routes based on a number of stops (Addresses that I would supply) and had it return the total distance, total drive time and the optimal order of each stop.