Monkeybread Software - MBS FileMaker Plugin: Google Maps API

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

Google Maps API

All examples are included with download of MBS FileMaker Plugin.

Google Maps API.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	1
Value Lists	0
Custom Functions	0
Custom Menus	24

File Options
Default custom menu set	[Standard FileMaker Menus]
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Google Maps API	8 fields defined, 2 records	Google Maps API

Fields

Table Name: Google Maps API - 8 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
API Key	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Google Maps API		Query
Address to query	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Google Maps API		Query
Latitude	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Google Maps API		Query
Longitude	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Google Maps API		Query
Result	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Google Maps API		Query
Debug Messages	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Google Maps API		Query
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Google Maps API		Query
Found	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Google Maps API		Query

Layout Objects: Google Maps API

Regular Fields

Field Name: Google Maps API::API Key

Layout Name:

Google Maps API

Top: 8 pt
Left: 761 pt
Bottom: 29 pt
Right: 1014 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Field Name: Google Maps API::Address to query

Layout Name:

Google Maps API

Top: 69 pt
Left: 148 pt
Bottom: 90 pt
Right: 401 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Google Maps API::Latitude

Layout Name:

Google Maps API

Top: 92 pt
Left: 148 pt
Bottom: 113 pt
Right: 401 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Google Maps API::Longitude

Layout Name:

Google Maps API

Top: 115 pt
Left: 148 pt
Bottom: 136 pt
Right: 401 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Google Maps API::Result

Layout Name:

Google Maps API

Top: 138 pt
Left: 148 pt
Bottom: 159 pt
Right: 401 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Google Maps API::Debug Messages

Layout Name:

Google Maps API

Top: 226 pt
Left: 148 pt
Bottom: 513 pt
Right: 401 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Google Maps API::JSON

Layout Name:

Google Maps API

Top: 226 pt
Left: 508 pt
Bottom: 513 pt
Right: 987 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Google Maps API::Found

Layout Name:

Google Maps API

Top: 71 pt
Left: 728 pt
Bottom: 189 pt
Right: 981 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Type:

Text: Query

Layout Name:

Google Maps API

Top: 71 pt
Left: 452 pt
Bottom: 102 pt
Right: 607 pt

Anchoring: Left, Top

Perform Script [ “Query” ]

Scripts:

Query

Button Properties

Coordinates

Script/Script Step

Type:

Text: Open Documentation

Layout Name:

Google Maps API

Top: 113 pt
Left: 452 pt
Bottom: 144 pt
Right: 607 pt

Anchoring: Left, Top

Open URL [ "https://developers.google.com/maps/documentation/geocoding/intro" ] [ No dialog ]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Request API Key

Layout Name:

Google Maps API

Top: 155 pt
Left: 452 pt
Bottom: 186 pt
Right: 607 pt

Anchoring: Left, Top

Open URL [ "https://developers.google.com/maps/documentation/geocoding/get-api-key" ] [ No dialog ]

Script Hierarchy

Query

Script Name	Query
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Google Maps API
Scripts that use this script
Script Definition
Script Steps	If [ Length(Google Maps API::API Key) = 0 ] Show Custom Dialog [ Message: "Please get an API key from Google."; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ] Open URL [ "https://developers.google.com/maps/documentation/geocoding/get-api-key" ] [ No dialog ] Exit Script [ ] End If #Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; "https://maps.googleapis.com/maps/api/geocode/json?address=" & MBS("Text.EncodeToURL"; Substitute(Google Maps API::Address to query; ¶; ", "); "utf8") & "&key=" & Google Maps API::API Key) ] #RUN now Set Field [ Google Maps API::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ Google Maps API::JSON; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ Google Maps API::Debug Messages; MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $httpResult; Value:MBS("CURL.GetResponseCode"; $curl) ] Set Variable [ $status; Value:MBS( "JSON.GetPathItem"; Google Maps API::JSON; "status"; 1 ) ] If [ $status = "OK" ] Set Field [ Google Maps API::Latitude; MBS( "JSON.GetPathItem"; Google Maps API::JSON; "results¶0¶geometry¶location¶lat"; 1 ) ] Set Field [ Google Maps API::Longitude; MBS( "JSON.GetPathItem"; Google Maps API::JSON; "results¶0¶geometry¶location¶lng"; 1 ) ] Set Field [ Google Maps API::Found; MBS( "JSON.GetPathItem"; Google Maps API::JSON; "results¶0¶formatted_address"; 1 ) ] Else Set Field [ Google Maps API::Latitude; "" ] Set Field [ Google Maps API::Longitude; "" ] Set Field [ Google Maps API::Found; "" ] End If #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	Google Maps API::API Key Google Maps API::Address to query Google Maps API::Result Google Maps API::JSON Google Maps API::Debug Messages Google Maps API::Latitude Google Maps API::Longitude Google Maps API::Found
Scripts used in this script
Layouts used in this script
Tables used in this script	Google Maps API
Table occurrences used by this script	Google Maps API
Custom Functions used by this script
Custom menu set used by this script

Download example: Google Maps API

Used functions: