Map route planning for field technicians

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Original post:
I have 10 field technicians. I have reports for each of them automatically generated every day with a list of customers for them to visit. I need to sort their daily list of addresses in an efficient route of travel.  Any ideas?
Photo of Dan G. (QB Support)

Dan G. (QB Support), Official Rep

  • 490 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Dan G. (QB Support)

Dan G. (QB Support), Official Rep

  • 490 Points 250 badge 2x thumb
Answer

If I have to travel to from the Ann Arbor library to my beloved Whirly Ball through these waypoints:

Ann Arbor Distrit Library
343 South Fifth Ave., Ann Arbor, MI 48104

White Castle
3953 Packard St, Ann Arbor, MI 48108

Ann Arbor Meijer
3145 Ann Arbor-Saline Rd, Ann Arbor, MI 48103

Whirly Ball Ann Arbor
750 Phoenix Drive Ann Arbor, Michigan 48108

Then I can use the Google Maps API to optimize my route:

https://maps.googleapis.com/maps/api/directions/json
  ?origin=343 South Fifth Ave., Ann Arbor, MI 48104
  &destination=750 Phoenix Drive Ann Arbor, Michigan 48108
  &waypoints=optimize:true|
    3953 Packard St, Ann Arbor, MI 48108|
    3145 Ann Arbor-Saline Rd, Ann Arbor, MI 48103

Shortcut URL:

https://goo.gl/Is0l9b


Was this answer helpful?

Answered by:
Original
dandiebolt_QB_Pirate , Pres. of Service Worker Union
QuickBase Pro 24 days ago




2 comments

Thanks for this info... I am unsure how to implement it for my 10 daily routes of 20 addresses each. Any pointers where/how to set this up would be appreciated!


Brilliant answer by Dan.  I did not know that Google Maps can solve the classical Salesman's Routing problem.

The issue is that you need to build that string.   To do that, there needs to be. Parent review which has all the addresses from those 10 child records floated up to the Parent where they can be concatenated together to build that string.

 So one of your choices is the contract with Dan to write a script that will load up those addresses and build that string for you. The advantage of that method is that it will be able to handle any number of children in case one day a salesman has a 15 stops and not just 10.

The alternative is to use someone a brute force method called reverse relationships and one by one you can build looping relationships to bring up the  address data from a child up to a parent record.

If you have a small batches Dan can probably knock this off for you quickly. If you have no budget you and I can work together on the forum here  and eventually we will get it working. The brakes are really stands original post where he is using Google to actually do the heavy lifting of the mathematics on the route

Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
You may want to convert your address data to the 'Address' data type. Google can then place a map location of that address in the record. Go to add a new field, select "Address" as the data type, then populate an address as a proof of concept. I think you might find this helpful in determining routes.