I have an Airtable base that has my project sites and my employees’ addresses.
I’ve hooked up the Google Maps API and have found the distance between employees and job sites. (And could do the same to find their distance from each other...)
And I’ve used the Google Maps API to plot their locations on a map, so i can see who lives near each other.
Can anyone help me brainstorm the best way to build efficient routes?
The ultimate goal would be to say “I’ve got these 10 people in Denver, and these 10 in Colorado Springs, and i need to send 5 each to jobs in Denver, Aurora, Colorado Springs, and Pueblo.”
But, that’s obviously a big ask. So even just “Here are the people who are going to the site in Aurora, and the routes they’ll take.” and i can see where carpooling makes sense would be a huge help.
I’m open to doing this in Airtable, Softr, a different app, etc.
