Template
Linear Route Optimization
An app to demonstrate how to use Action-Looping to optimize the route for order deliveries that need to be made
Industry:
n/a
Since 2016 people have been searching for a solution to the "Travelling Salesman Problem" using AppSheet.
But at that point AppSheet was still pretty newborn, it just didn't have the technical chops to handle some of the calculations that needed to happen in an efficient way - and ultimately none of the attempts ever worked out.
~~~~~~~~~
Fast-forward to today: now the platform has all the efficiencies and capabilities necessary to accomplish even the most complicated of logic tasks.
You're still limited by the capabilities of the DEVICE that's running the app; but in regards to logic, processing/manipulating data, doing calculations, etc. and automating all of that - AppSheet is more than capable nowadays. (^_^)
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
This is a demonstration of how you might solve this problem completely client-side, meaning we do not need to use any external APIs or anything.
The downside to this is that all the distance calculations are done "as the crow files" - so things like street layout, bridges, construction, etc. are not taken into consideration.
But if you're just looking for a quick solution, this can show you how to go about building a system that would correctly order the picks up and delivery destinations.
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...