Monkeybread Software - MBS FileMaker Plugin: Validate Address

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

MBS FileMaker Plugin Example Databases

Validate Address

All examples are included with download of MBS FileMaker Plugin.

Validate Address.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	2
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
Validate Address	13 fields defined, 8 records	Validate Address

Fields

Table Name: Validate Address - 13 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: Validate Address Calculation: Get( UUID ) Validation: Only during data entry Not empty Unique Strict validation Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: Unicode Raw	Unique identifier of each record in this table
CreationTimestamp	Normal, Timestamp	Auto-Enter: Creation timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Date and time each record was created
CreatedBy	Normal, Text	Auto-Enter: Creation account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Account name of the user who created each record
ModificationTimestamp	Normal, Timestamp	Auto-Enter: Modification timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Date and time each record was last modified
ModifiedBy	Normal, Text	Auto-Enter: Modification account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Account name of the user who last modified each record
Input	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Validate Address		Lookup
Address	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Validate Address		Lookup Clean
PostalCode	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Validate Address		Lookup Clean
City	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Validate Address		Lookup Clean
Street	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Validate Address		Lookup Clean
Country	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Validate Address		Lookup Clean
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		Validate Address		Lookup Clean
Description	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Validate Address

Layout Objects: Validate Address

Regular Fields

Field Name: Validate Address::Input

Layout Name:

Validate Address

Top: 131 pt
Left: 146 pt
Bottom: 215 pt
Right: 544 pt

Anchoring: Left and Right, 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: Validate Address::Address

Layout Name:

Validate Address

Top: 236 pt
Left: 146 pt
Bottom: 320 pt
Right: 544 pt

Anchoring: Left and Right, 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: Validate Address::PostalCode

Layout Name:

Validate Address

Top: 380 pt
Left: 146 pt
Bottom: 411 pt
Right: 240 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: Validate Address::City

Layout Name:

Validate Address

Top: 380 pt
Left: 249 pt
Bottom: 411 pt
Right: 544 pt

Anchoring: Left and Right, 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: Validate Address::Street

Layout Name:

Validate Address

Top: 341 pt
Left: 146 pt
Bottom: 372 pt
Right: 544 pt

Anchoring: Left and Right, 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: Validate Address::Country

Layout Name:

Validate Address

Top: 419 pt
Left: 146 pt
Bottom: 450 pt
Right: 544 pt

Anchoring: Left and Right, 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: Validate Address::JSON

Layout Name:

Validate Address

Top: 123 pt
Left: 158 pt
Bottom: 484 pt
Right: 447 pt

Anchoring: Left and Right, Top and Bottom

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: Validate Address::Description

Layout Name:

Validate Address

Top: 454 pt
Left: 146 pt
Bottom: 485 pt
Right: 544 pt

Anchoring: Left and Right, 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: Try this!

Layout Name:

Validate Address

Top: 174 pt
Left: 18 pt
Bottom: 205 pt
Right: 135 pt

Anchoring: Left, Top

Perform Script [ “Lookup” ]

Scripts:

Lookup

Popover Buttons

Popover Button Properties		Coordinates
Type: Text: JSON Layout Name: Validate Address Hide Condition: IsEmpty ( Validate Address::JSON )		Top: 275 pt Left: 41 pt Bottom: 306 pt Right: 135 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "Popover" Position: Right		Top: 91 pt Left: 146 pt Bottom: 491 pt Right: 457 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects Validate Address::JSON at (123, 158, 484, 447)

Script Name	Lookup
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	Validate Address
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $geocoder; Value:MBS( "CLGeocoder.GeocodeAddressString"; Validate Address::Input; 1) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to locate address"; Message: $geocoder; Default Button: “OK”, Commit: “Yes” ] Else If [ MBS( "CLGeocoder.PlacemarkCount"; $Geocoder ) = 0 ] Show Custom Dialog [ Title: "No place found."; Default Button: “OK”, Commit: “Yes” ] Else Set Variable [ $streetNumber; Value:MBS( "CLGeocoder.PlacemarkValue"; $Geocoder; 0; "subThoroughfare") ] Set Field [ Validate Address::Address; MBS( "CLGeocoder.PlacemarkValue"; $Geocoder; 0; "Address") ] Set Field [ Validate Address::PostalCode; MBS( "CLGeocoder.PlacemarkValue"; $Geocoder; 0; "postalCode") ] Set Field [ Validate Address::City; MBS( "CLGeocoder.PlacemarkValue"; $Geocoder; 0; "locality") ] Set Field [ Validate Address::Street; MBS( "CLGeocoder.PlacemarkValue"; $Geocoder; 0; "thoroughfare") & If ( Length ( $streetNumber ) > 0; " " & $streetNumber; "" ) ] Set Field [ Validate Address::Country; MBS( "CLGeocoder.PlacemarkValue"; $Geocoder; 0; "Country") ] Set Field [ Validate Address::JSON; MBS("JSON.Colorize"; MBS( "CLGeocoder.JSON"; $Geocoder)) ] End If Set Variable [ $r; Value:MBS( "CLGeocoder.Close"; $Geocoder ) ]
Fields used in this script	Validate Address::Input Validate Address::Address Validate Address::PostalCode Validate Address::City Validate Address::Street Validate Address::Country Validate Address::JSON
Scripts used in this script
Layouts used in this script
Tables used in this script	Validate Address
Table occurrences used by this script	Validate Address
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Lookup]

Script Name	Clean
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Replace Field Contents [ Validate Address::JSON; Replace with calculation: "" ] [ No dialog ] Replace Field Contents [ Validate Address::Country; Replace with calculation: "" ] [ No dialog ] Replace Field Contents [ Validate Address::Street; Replace with calculation: "" ] [ No dialog ] Replace Field Contents [ Validate Address::City; Replace with calculation: "" ] [ No dialog ] Replace Field Contents [ Validate Address::PostalCode; Replace with calculation: "" ] [ No dialog ] Replace Field Contents [ Validate Address::Address; Replace with calculation: "" ] [ No dialog ]
Fields used in this script	Validate Address::JSON Validate Address::Country Validate Address::Street Validate Address::City Validate Address::PostalCode Validate Address::Address
Scripts used in this script
Layouts used in this script
Tables used in this script	Validate Address
Table occurrences used by this script	Validate Address
Custom Functions used by this script
Custom menu set used by this script

Download example: Validate Address

Used functions: