MapQuest_Directions ( StreetStart ; CityStart ; StateStart ; CountryStart ; StreetEnd ; CityEnd ; StateEnd ; CountryEnd )

MapQuest, Directions and Map locator

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

Robert Schaub
Starr Data
http://starrdata.com

Sample input:

MapQuest_Directions ( StreetStart ; CityStart; StateStart; CountryStart; StreetEnd; CityEnd; StateEnd; CountryEnd )

Sample output:

http://www.mapquest.com/directions/main.adp?go=1&do=nw&2ex=1&src=maps&ct=NA&1y=US &1a=26 Summit St&1s=Ct &1c=East HamptonUS &1ah=&2a=10 East High&2s=ct &2c=East HamptonUS

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

//MapQuest_Directions ( StreetStart ; CityStart; StateStart; CountryStart; StreetEnd; CityEnd; StateEnd; CountryEnd )

"http://www.mapquest.com/directions/main.adp?go=1&do=nw&2ex=1&src=maps&ct=NA&1y=US &1a=" & 

Substitute(StreetStart; ""; "+") & 
"&1s=" & StateStart &
" &1c=" & Substitute(CityStart; ""; "+")  & 
If(IsEmpty(CountryStart) ; "US"; CountryStart ) &

" &1ah=&2a=" & Substitute(StreetEnd; ""; "+") & 
"&2s=" & StateEnd &
" &2c=" & Substitute(CityEnd; ""; "+") &
If(IsEmpty(CountryEnd) ; "US"; CountryEnd  )


//Robert Schaub
//starrdata.com

Use your start and end address fields from you database or enter your custom find. Note if you leave the country start and country end fields. It defaults to US behind the scenes, whether it is empty or just left blank.

Use this custom function as a calculation field and set up a web viewer portal using this field. You may also use it as an url in the open url script step.

Comments

		Jan 29, 2009
Excellent!! Perfect for my deliveries!

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

MapQuest_Directions ( StreetStart ; CityStart ; StateStart ; CountryStart ; StreetEnd ; CityEnd ; StateEnd ; CountryEnd )

Comments

Support this website.

Support this website.