Automatic short route on maps

[Hinse_Wouters]

Hello!

Is there an option that appsheets looks for the logic following delivery? Like I have 10 orders, and appsheets looks for me what is the best route to take when I want to deliver as fast as possible all these orders.

Something like : www.optimoroute.com?

I want to create an driver app. (I found already the standard app).

Thank you for helping me!

[1minManager]

What you’re talking about is a classic maths problem called the “Travelling Salesman Problem”. It is impossible to do this in Appsheet alone as Appsheet has no knowledge of the roads and timings between each address.

The best way to solve this would be the Google Maps API, which has a function called Matrix I think. This is where you can send Google a start point and 20 addresses and it will put them in the quickest order. To sort this you’re going to need a Google Scripts/JavaScript expert. Or you might be able to do it via APIGEE. But don’t quote me on that.