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 - Show more from this author
Mactec
http://www.mactec.com.au

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)

/*

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

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.
State can be abbreviated or full

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

*/

Let ( [

DefaultCountry = "Australia";

// Remove extra lines
StreetNameTemp = If ( PatternCount (Street;"¶") > 0 and Position(Street;"¶";1;1)< Length (Street);Right ( Street ; Length ( Street ) - Position ( Street ; "¶" ; 1 ; 1 ));Street);

// Remove any unwanted text before the street number
StreetNameTemp = Case(
PatternCount(StreetNameTemp;",")>0;Right(StreetNameTemp;Length(StreetNameTemp) - Position (StreetNameTemp; "," ;1 ;1 ));
PatternCount(StreetNameTemp;"/") > 0; Right(StreetNameTemp;Length(StreetNameTemp) - Position(StreetNameTemp;"/";1;1));

LeftWords(StreetNameTemp;1)="Unit" or LeftWords ( StreetNameTemp ; 1 ) = "Flat"  or LeftWords ( StreetNameTemp ; 1 ) = "Level" or LeftWords ( StreetNameTemp ; 1 ) = "Suite";Right(StreetNameTemp;Length(StreetNameTemp) - Position(StreetNameTemp;" ";1;2));StreetNameTemp);


StreetName = Trim(RightWords (StreetNameTemp; WordCount ( StreetNameTemp )-1 ));
StreetName = Substitute ( StreetName ; " " ; "+" );
StreetNumber = LeftWords (StreetNameTemp;1 )

];


"http://www.google.com/maps?q=" & StreetNumber & "+" & StreetName & "+" & Suburb & "+" & State & "+" & Zip & "+" & If ( IsEmpty(Country); DefaultCountry; country)
)

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, 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, JEAMA Nov 3, 2011
my eMail address is tassie379@gmail.com

		Sean, Private 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, Brisbane, Australia Jul 13, 2013
Sean, you need to add the follow Function Parameters: Street; Suburb; State; Zip; Country Cheers, Chris

		Sean, Private 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

		Michael Leiser, BYA May 29, 2023
Used to work until recently. Now it comes up with the screen and quickly disappears. Any help? Same problem with the google directions function. Michael

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

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

Comments

Support this website.

Support this website.