Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Use the forum to share formulas and tricks between TD application developers
Let's face it - we're all pretty clever singularly... But imagine how far we can go if we share workflow ideas and shortcuts!

So to start off - a formula for doing a Direction Planner using Google Maps:

You'll need a Start Point Address and City/Suburb... and a Destination Point Address and City/Suburb

The Google URL will look like this:

"https://maps.google.com/maps?saddr="& List(",+",NotLeft([Location Address]," "),[Location City/Suburb])&"&daddr="&List(",+",NotLeft([Site Address]," "), [Site City])

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!
ID
566
Category
Setup
Author

basenine
Date Created
9/27/2012 10:24:08 PM
Date Updated
6/5/2013 3:47:54 PM
Comments
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="
martin oliver 10/4/2012 9:10:23 AM
"https://maps//google.co.za/maps?saddr="

martin oliver 10/4/2012 9:10:37 AM
"https://maps.google.co.za/maps?saddr="
martin oliver 10/4/2012 9:12:20 AM
"https://maps.google.co.za/maps?saddr=

Please ignore see does work
martin oliver 10/4/2012 10:18:00 AM
I used this for South Africa

"https://maps.google.co.za/maps?saddr="& List(",+",([Street Name]), [Suburb Name])&"&daddr="&List(",+",([Street/Road Name]), [City /Suburb])

simply using street names & suburb/city
basenine 10/4/2012 6:32:21 PM
Hello Martin,

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!!
Feedback
Back to Search Results