Hi @Ashley_West, and welcome to the community!
Easily accomplished with some complex geometry in script. :winking_face: I like using the terms easy and complex in the same sentence.
Indeed, if you’re in transportation, you need location science and the most rudimentary element is miles between waypoints. I have one client who uses miles but also adds a surcharge for traffic. If a delivery run requires execution at peak rush hour times, the algorithm computes the cost of drivers waiting in traffic based on the known traffic load at the time of the run.
To do this, you’ll need a script block or script action that:
- … calls an API (like the Distance Matrix) to compute the driving distance from origin to destination.
- … updates the mileage field with the result.
If you happen to already know the lat/lng of origin and destination, you could avoid the API service call and compute the distance with this function. However, this would be estimated miles as the crow flies which could serve as a good estimate that is padded by 20%.
function getDistanceFromLatLonInKm(lat1,lon1,lat2,lon2) {
var R = 6371; // Radius of the earth in km
var dLat = deg2rad(lat2-lat1); // deg2rad below
var dLon = deg2rad(lon2-lon1);
var a =
Math.sin(dLat/2) * Math.sin(dLat/2) +
Math.cos(deg2rad(lat1)) * Math.cos(deg2rad(lat2)) *
Math.sin(dLon/2) * Math.sin(dLon/2)
;
var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));
var d = R * c; // Distance in km
return d;
}
function deg2rad(deg) {
return deg * (Math.PI/180)
}
