Brian Dunning's FileMaker Custom Functions

PrintGoogleDirections ( Start Address ; Start City ; Start State ; Start Zip ; Start Country ; End Address ; End City ; End State ; %

Give

  Average rating: 4.2 (45 votes) Log in to vote

Bill Koller   Bill Koller
Anchor Consulting LLC

Share on Facebook Share on Twitter

  Sample input:
PrintGoogleDirections ( Start Address ; Start City ; Start State ; Start Zip ; Start Country ; End Address ; End City ; End State ; End Zip ; End Country )
  Sample output:
http://maps.google.com/maps?f=d&source=s_d&saddr=1+Microsoft+Way,+Redmond,+WA+98052+(Microsoft+Corporation+825)&daddr=1600+Amphitheatre+Parkway,+Mountain+View,+CA+94043&geocode=Ca9Rv24a3ZyGFbf71gIdLne4-CErWDHbJqnMXA;Fa8DOwIdLyS5-A&view=map&hl=en&mra=pe&mrcr=0&sll=42.532791,-122.106805&sspn=15.613641,32.497559&ie=UTF8&ll=42.536892,-122.67334&spn=15.613641,32.497559&t=h&z=6&layer=c&pw=2

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This will create a URL from a starting address to an ending address to Google Maps Printable version

 

Comments

Daniel Wood   Daniel Wood, Digital Fusion Ltd
Dec 17, 2009
Hi Bill, nice function. Just a couple of things:

1. When I tried to use it I would only see "A" pointer on the start location, and "1" pointer on the destination. There was no line drawn between them, nor any actual directions as text, should there have been?

2. Is it ok to omit certain parameters, ie just leaving them as double quotes? Some addresses in countries other than the US do not have a state or zip. It seems to work to the degree mentioned in (1) above, but that's about it.

Cheers
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.