Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 FileMaker Pro Web Viewer Examples

Search  |  List  |  Show Random  |  Upload  |  Add This to Your Site

GEO Geocoding GOOGLE

Ralph Nusser, Sogetes FileMaker-Services
http://www.sogetes.com

Lookup of Longitude Latitude of a given address



Then copy & paste into the "Edit Web Address" field of FileMaker Pro 8.5's "Web Viewer Setup" window while defining a Web Viewer object in Layout Mode. Use FileMaker's calculation functions to replace sample data in this example with references to the fields in your database. See FileMaker's documentation for more information about Web Viewers.

Example:

Description:

/*----------------------------------------------------------------------------------------------
SYNTAX:
_GEO_GEOCODING_Google ( pStreet ; pZip ; pCity ; pCountry )

AUTHOR:
Ralph Nusser, 15-SEP-2011

DESCRIPTION:
Geocode a given address with WGS84 Latitude and Longitude. Geocoding API (V3).
Generally, only one entry in the "results" array is returned for address lookups,
though the geocoder may return several results when address queries are ambiguous.

EXAMPLE:
http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=false

QUERY LIMIT PER DAY:
2,500 as of SEP-2011: "This limit may be changed in the future without notice."
http://code.google.com/intl/en-EN/apis/maps/documentation/geocoding/

LICENCE RESTRICTIONS:
The Geocoding API may only be used in conjunction with a Google map;
geocoding results without displaying them on a map is prohibited.
For complete details on allowed usage, consult the Maps API Terms of Service License Restrictions.
http://code.google.com/apis/maps/terms.html#section_10_12
----------------------------------------------------------------------------------------------*/
Let ([
vString1 = "http://maps.googleapis.com/maps/api/geocode/xml?address=";
vStreet = Substitute ( pStreet ; " "; "+");
vCity = Substitute ( pZip & " " & pCity; " "; "+");
vCountry = pCountry;
vString2 = "&sensor=false"
];
vString1 & vStreet & ",+" & vCity & ",+" & vCountry & vString2
)

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

This is my Web Viewer Example and I want to edit it

digg this page | del.icio.us this page


Newest Web Viewer Examples:

1. Pilot Air Tracking
  (Wed, Oct 03, 3:26pm)
2. PHOTO_GOOGLE
  (Wed, Apr 04, 1:35am)
3. DANGEROUS GOODS_UN Number
  (Wed, Mar 21, 7:35am)

RSS Feed of Web Viewer Examples

Quick Poll...
Are you mainly Mac
or mainly Windows?
 • Mac
 • Windows
View the answers

Progress Bars

Add progress bars to those slow scripts in your FileMaker Pro solution. Click here.

Web Viewer Example Authors:
Link to all of your own Web Viewer Examples on this site with the following URL:
http://www.briandunning.com/filemaker-web-viewer/results.php?author=Your Name Here