Multi Drop Delivery

[ddlaw]

Hi,

Apologies if this has already been asked, but I am unable to find an answer.

I am trying to create an app for a courier, they can have multiple drops per driver and these will be added in no particular order.

We have a required collection / delivery address field, that will calculate the lat/long, however, we want to be able to calculate the distance between each stop, and put those in order of distance from each other, i.e if Address A is 5 miles from B yet C is 3 miles away, the order we would want to put these is A,C,B

Can anyone help point me in the right direction, please?

Kind Regards

[1minManager]

So you can use Distance() to get the STRAIGHT LINE distance.  But the 2 columns have to both be LatLong.  If one or both is an Adddress, or you need the road distance, you'll need to use the Google Maps API.

Simon, 1minManager.com