In this example, we've got two tables and therefore we need to bring in Lookups from one table to the other. Location --> Customer --> Quote
The Start Address (saddr=) is from the Location Table and the Destination Address (daddr=) is from the Site Address in the Quote record. You'll notice I've used not Left() and the delimiter is a " " (space)... this gets rid of the possible scenario of U1/1234 Whatsy Street and just refers to Whatsy Street.
You can use URLEncode before List() too if required - but I didn't need to in this case...
You can make the Formula - URL a button called "Get Directions" and have it open up in a new Window.
The map will show Durations and Distance as well.
So there's the first forum post - someone had too! Cheers
BTW - I was going to call the button "Route Planner"...but it might have been misinterpreted!
Date Created 9/27/2012 10:24:08 PM
Date Updated 6/5/2013 3:47:54 PM
martin oliver 10/4/2012 9:07:46 AM
I have tried this using the URL "https://maps//google.co.za/maps?saddr=" The South African Google site, but this does not take me onto the get directions tab as is the case with your "https://maps.google.com/maps?saddr=" above
any ideas - thanks
martin oliver 10/4/2012 9:10:00 AM
sorry should read "https://maps.goo gle.co.za/maps?saddr="
Yes - the [Location Address] was actually a Street Name (a bit confusing I agree!).
Well done for battling through it! Cheers
Jacques du preez 6/5/2013 3:47:54 PM
Hi guys, I will be the first to face that you are extremely clever.If you really want to impress and also become stinking rich( which you all are probably already) develop a multiple point route in google apps each one with its own estimate time of arrival. I am rude sorry, My name is Jacques and I am 13 years in the Chicken industry in South Africa, I am busy trying to create a exiting resellable platform, custom made for the south african meat industry. Any inputs will be so so welcome!!