I am trying to write a script that will take information from Lat & Long fields in my database and ultimately display it on a map. I'd like to to automatically copy & paste the lat/long into the search bar on Google Maps.
Here is an example of URL coding for Lat and Long finds on Google Maps: http://maps.google.com/maps?q=40.771008,+-122.41175&iwloc=A&hl=en
so, create a new calculated field:
"http://maps.google.com/maps?q=" & Your Lat Field & ",+" & Your Long Field & "iwloc=A&hl=en"
**Not sure if you have the comma at the end of your Lat field or not, or if you have the minus sign in front of your Long field.**
you can then use this calculated field in a portal if you'd like.
sorry, in my **note, i meant to say i'm not sure if you have the +/- signs
That worked! I removed the + and & "iwloc=A&hl=en" from the end and had success. I wrote a script to open the URL from the Combined Field and made a button 'View Map." Thanks!
Thanks for this answer. However, how can you do this for multiple placemarks onto GoogleMaps? Separating them by a semicolon does not work. Without having to use GoogleEarth and creating a kml, Any thoughts out there on how to use this on GoogleMap? Kindly help.
Retrieving data ...