Brian Dunning's FileMaker Custom Functions

GoogleMap ( Street ; Suburb ; State ; Zip ; Country )

Creates URL to display a Google Map from address data

  Average rating: 4.0 (39 votes) Log in to vote

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

Share on Facebook Share on Twitter

  Sample input:
GoogleMap ( "Unit 3/88 Gladstone Road" ; "Highgate Hill" ; "Qld" ; "4101" ; "Australia" )
  Sample output:
http://www.google.com/maps?q=88+Gladstone+Road+Highgate%20Hill+QLD++Australia

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

Takes an address and returns text formatted as a URL to display a Google Map. This can be used to open a URL or Web Viewer window.

Street can be on multiple lines, and can contain unit numbers etc. Any extra text will be removed.

State can be abbreviated or full.

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

 

Comments

ERRI NUÑEZ   ERRI NUÑEZ, PAMPLONA
Jan 20, 2010
I need custom function for adress in mymaps.

you can help me?

the query string have

msa= & msid= parameters

please see

http://www.querystring.org/google-maps/google-maps-query-string-parameters

i cant made this function.
thanks
 
tim   tim, canberra 2
Nov 3, 2011
my eMail address is
tassie379@gmail.com
 
Sean   Sean, Durban
Jul 13, 2013
Hi, feeling foolish. This is the 2nd Google Map custom function I've tried and cannot get to work. Using FM 12 Pro on Windows.

Steps: On creating a new custom function, carefully pasting the code into the Edit Custom Function window, on saving I'm getting an error "The specified parametre cannot be found" It then highlights Street

Please could someone walk me through this? I am new to Custom Functions.

Many thanks,
Sean
 
Chris Pye   Chris Pye, Brisbane, Australia
Jul 13, 2013
Sean, you need to add the follow Function Parameters: Street; Suburb; State; Zip; Country

Cheers,
Chris
 
Sean   Sean, Durban
Jul 14, 2013
Many thanks Chris. Figured out the bigger problem was FM not having Google code for South Africa.

Like your approach and thanks for sharing it with us.

Cheers,
Sean
 

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.