Brian Dunning's FileMaker Custom Functions

GoogleDirections ( Street1 ; Suburb1 ; State1 ; Zip1 ; Country1 ; %

Creates URL to display Google Directions from address data

  Average rating: 4.3 (41 votes) Log in to vote

Chris Pye   Chris Pye
Mactec
http://www.mactec.com.au

Share on Facebook Share on Twitter

  Sample input:
GoogleDirections ( "190 Weller Road"; "Tarragindi"; "Qld"; "4121"; "Australia"; "148 Ipswich Road"; "Wooloongabba"; "Qld";
  Sample output:
http://www.google.com/maps?saddr=190+Weller+Road+Tarragindi+QLD++Australia&daddr=15+Parkway+Road+Daisy%20Hill+QLD+4127+Australia

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

Takes two addresses and returns text formatted as a URL to display a Google Map with directions. This can be used to open a URL or Web Viewer window.

Street can be on multiple lines, and can contain unit numbers etc.
State can be abbreviated or full.

If country field is empty, it will default to the country set in DefaultCountry variable.

 

Comments

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.