Monkeybread Software - MBS FileMaker Plugin: Contacts to FileMaker

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

MBS FileMaker Plugin Example Databases

Contacts to FileMaker

All examples are included with download of MBS FileMaker Plugin.

Contacts to FileMaker.fmp12

Overview
Tables	8
Relationships	7
Layouts	8
Scripts	6
Value Lists	0
Custom Functions	0
Custom Menus	24

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

Tables

Table Name	Statistics	Comments	Occurrences in Relationship Graph
Contacts to FileMaker	18 fields defined, 0 record		Contacts to FileMaker
Emails	10 fields defined, 0 record		Emails
URLs	10 fields defined, 0 record		URLs
SocialProfiles	10 fields defined, 0 record		SocialProfiles
PostalAddresses	16 fields defined, 0 record		PostalAddresses
PhoneNumbers	10 fields defined, 0 record		PhoneNumbers
ContactRelations	10 fields defined, 0 record		ContactRelations
Dates	10 fields defined, 0 record		Dates

Fields

Table Name: Contacts to FileMaker - 18 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: Contacts to FileMaker 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: English	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: English	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: English	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: English	Account name of the user who last modified each record
First Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
Last Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
Company	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
Middle Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
Job Title	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
Nick Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker
imageData	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Contacts to FileMaker		Import Contacts
Type	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
previousFamilyName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
Contact Identifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		Contacts to FileMaker	Contacts to FileMaker=Emails URLs=Contacts to FileMaker Contacts to FileMaker=SocialProfiles PostalAddresses=Contacts to FileMaker PhoneNumbers=Contacts to FileMaker ContactRelations=Contacts to FileMaker Dates=Contacts to FileMaker	Import Contacts Show In Addressbook
MailingAddress	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker		Import Contacts

Table Name: Emails - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: Emails 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: English	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: English	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: English	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: English	Account name of the user who last modified each record
ContactIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		Emails	Contacts to FileMaker=Emails	Import Contacts
EmailIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Emails		Import Contacts
Label	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker Emails		Import Contacts
Email	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker Emails		Import Contacts
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker Emails		Import Contacts

Table Name: URLs - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: URLs 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: English	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: English	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: English	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: English	Account name of the user who last modified each record
ContactIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		URLs	URLs=Contacts to FileMaker	Import Contacts
URLIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		URLs		Import Contacts
Label	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker URLs		Import Contacts
URL	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker URLs		Import Contacts
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker URLs		Import Contacts

Table Name: SocialProfiles - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: SocialProfiles 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: English	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: English	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: English	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: English	Account name of the user who last modified each record
ContactIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		SocialProfiles	Contacts to FileMaker=SocialProfiles	Import Contacts
ProfileIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		SocialProfiles		Import Contacts
Label	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker SocialProfiles		Import Contacts
username	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker SocialProfiles		Import Contacts
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker SocialProfiles		Import Contacts

Table Name: PostalAddresses - 16 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: PostalAddresses 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: English	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: English	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: English	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: English	Account name of the user who last modified each record
ContactIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		PostalAddresses	PostalAddresses=Contacts to FileMaker	Import Contacts
AddressIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		PostalAddresses
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker PostalAddresses		Import Contacts
Street	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker PostalAddresses		Import Contacts
PostalCode	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker PostalAddresses		Import Contacts
City	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker PostalAddresses		Import Contacts
Country	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker PostalAddresses		Import Contacts
SubLocality	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		PostalAddresses		Import Contacts
SubAdministrativeArea	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		PostalAddresses		Import Contacts
State	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		PostalAddresses		Import Contacts
ISOCountryCode	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		PostalAddresses		Import Contacts

Table Name: PhoneNumbers - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: PhoneNumbers 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: English	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: English	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: English	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: English	Account name of the user who last modified each record
ContactIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		PhoneNumbers	PhoneNumbers=Contacts to FileMaker	Import Contacts
PhoneIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		PhoneNumbers		Import Contacts
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker PhoneNumbers		Import Contacts
Label	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker PhoneNumbers		Import Contacts
Phone Number	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker PhoneNumbers		Import Contacts

Table Name: ContactRelations - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: ContactRelations 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: English	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: English	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: English	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: English	Account name of the user who last modified each record
ContactIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		ContactRelations	ContactRelations=Contacts to FileMaker	Import Contacts
RelationIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		ContactRelations		Import Contacts
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker ContactRelations		Import Contacts
Label	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker ContactRelations		Import Contacts
Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker ContactRelations		Import Contacts

Table Name: Dates - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: Dates 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: English	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: English	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: English	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: English	Account name of the user who last modified each record
ContactIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		Dates	Dates=Contacts to FileMaker	Import Contacts
DateIdentifier	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Dates		Import Contacts
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Dates		Import Contacts
Label	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: English		Contacts to FileMaker Dates		Import Contacts
Date	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		Contacts to FileMaker Dates		Import Contacts

Relationship: URLs=Contacts to FileMaker

Table Occurrence	URLs		Contacts to FileMaker
Field	ContactIdentifier	=	Contact Identifier
Source Table	URLs		Contacts to FileMaker
Source File	Contacts to FileMaker.fmp12		Contacts to FileMaker.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: Contacts to FileMaker=SocialProfiles

Table Occurrence	Contacts to FileMaker		SocialProfiles
Field	Contact Identifier	=	ContactIdentifier
Source Table	Contacts to FileMaker		SocialProfiles
Source File	Contacts to FileMaker.fmp12		Contacts to FileMaker.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: PostalAddresses=Contacts to FileMaker

Table Occurrence	PostalAddresses		Contacts to FileMaker
Field	ContactIdentifier	=	Contact Identifier
Source Table	PostalAddresses		Contacts to FileMaker
Source File	Contacts to FileMaker.fmp12		Contacts to FileMaker.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: PhoneNumbers=Contacts to FileMaker

Table Occurrence	PhoneNumbers		Contacts to FileMaker
Field	ContactIdentifier	=	Contact Identifier
Source Table	PhoneNumbers		Contacts to FileMaker
Source File	Contacts to FileMaker.fmp12		Contacts to FileMaker.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: ContactRelations=Contacts to FileMaker

Table Occurrence	ContactRelations		Contacts to FileMaker
Field	ContactIdentifier	=	Contact Identifier
Source Table	ContactRelations		Contacts to FileMaker
Source File	Contacts to FileMaker.fmp12		Contacts to FileMaker.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: Dates=Contacts to FileMaker

Table Occurrence	Dates		Contacts to FileMaker
Field	ContactIdentifier	=	Contact Identifier
Source Table	Dates		Contacts to FileMaker
Source File	Contacts to FileMaker.fmp12		Contacts to FileMaker.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Layouts

Layout Hierarchy

Contacts to FileMaker

Save record changes automatically

Show field frames when record is active

Show field frames only on current record

Show current record indicator in List View

Contacts to FileMaker

Yes

36 Regular Fields
4 Buttons
8 Popover Buttons
7 Portals

Contacts to FileMaker

Off

Import Contacts

[File Default]

Emails

Yes

5 Regular Fields

Emails

Off

Import Contacts

[File Default]

URLs

Yes

5 Regular Fields

URLs

Off

Import Contacts

[File Default]

SocialProfiles

Yes

5 Regular Fields

SocialProfiles

Off

Import Contacts

[File Default]

PostalAddresses

Yes

11 Regular Fields

PostalAddresses

Off

Import Contacts

[File Default]

PhoneNumbers

Yes

5 Regular Fields

PhoneNumbers

Off

Import Contacts

[File Default]

ContactRelations

Yes

5 Regular Fields

ContactRelations

Off

Import Contacts

[File Default]

Dates

Yes

5 Regular Fields

Dates

Off

Import Contacts

[File Default]

Layout Objects: Contacts to FileMaker

Regular Fields

Field Name: Contacts to FileMaker::First Name

Layout Name:

Contacts to FileMaker

Top: 284 pt
Left: 141 pt
Bottom: 315 pt
Right: 394 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: Contacts to FileMaker::Last Name

Layout Name:

Contacts to FileMaker

Top: 356 pt
Left: 141 pt
Bottom: 387 pt
Right: 394 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: Contacts to FileMaker::Company

Layout Name:

Contacts to FileMaker

Top: 392 pt
Left: 141 pt
Bottom: 423 pt
Right: 394 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: Contacts to FileMaker::Middle Name

Layout Name:

Contacts to FileMaker

Top: 320 pt
Left: 141 pt
Bottom: 351 pt
Right: 394 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: Contacts to FileMaker::Job Title

Layout Name:

Contacts to FileMaker

Top: 428 pt
Left: 141 pt
Bottom: 459 pt
Right: 394 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: Contacts to FileMaker::Nick Name

Layout Name:

Contacts to FileMaker

Top: 463 pt
Left: 141 pt
Bottom: 494 pt
Right: 394 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: Contacts to FileMaker::imageData

Layout Name:

Contacts to FileMaker

Top: 154 pt
Left: 141 pt
Bottom: 279 pt
Right: 394 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: Contacts to FileMaker::Type

Layout Name:

Contacts to FileMaker

Top: 498 pt
Left: 141 pt
Bottom: 529 pt
Right: 394 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: Contacts to FileMaker::previousFamilyName

Layout Name:

Contacts to FileMaker

Top: 533 pt
Left: 141 pt
Bottom: 564 pt
Right: 394 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: Contacts to FileMaker::Contact Identifier

Layout Name:

Contacts to FileMaker

Top: 568 pt
Left: 141 pt
Bottom: 599 pt
Right: 394 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: Emails::Label

Layout Name:

Contacts to FileMaker

Top: 122 pt
Left: 444 pt
Bottom: 153 pt
Right: 598 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: Emails::Email

Layout Name:

Contacts to FileMaker

Top: 122 pt
Left: 602 pt
Bottom: 153 pt
Right: 792 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: Emails::JSON

Layout Name:

Contacts to FileMaker

Top: 39 pt
Left: 459 pt
Bottom: 391 pt
Right: 730 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: URLs::Label

Layout Name:

Contacts to FileMaker

Top: 248 pt
Left: 444 pt
Bottom: 279 pt
Right: 598 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: URLs::URL

Layout Name:

Contacts to FileMaker

Top: 248 pt
Left: 602 pt
Bottom: 279 pt
Right: 792 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: URLs::JSON

Layout Name:

Contacts to FileMaker

Top: 98 pt
Left: 459 pt
Bottom: 450 pt
Right: 730 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: SocialProfiles::Label

Layout Name:

Contacts to FileMaker

Top: 374 pt
Left: 444 pt
Bottom: 405 pt
Right: 598 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: SocialProfiles::username

Layout Name:

Contacts to FileMaker

Top: 374 pt
Left: 602 pt
Bottom: 405 pt
Right: 792 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: SocialProfiles::JSON

Layout Name:

Contacts to FileMaker

Top: 223 pt
Left: 459 pt
Bottom: 575 pt
Right: 730 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: PostalAddresses::Street

Layout Name:

Contacts to FileMaker

Top: 375 pt
Left: 845 pt
Bottom: 406 pt
Right: 1193 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: PostalAddresses::City

Layout Name:

Contacts to FileMaker

Top: 412 pt
Left: 940 pt
Bottom: 443 pt
Right: 1064 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: PostalAddresses::Country

Layout Name:

Contacts to FileMaker

Top: 412 pt
Left: 1068 pt
Bottom: 443 pt
Right: 1193 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: PostalAddresses::PostalCode

Layout Name:

Contacts to FileMaker

Top: 412 pt
Left: 811 pt
Bottom: 443 pt
Right: 936 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: PostalAddresses::JSON

Layout Name:

Contacts to FileMaker

Top: 348 pt
Left: 459 pt
Bottom: 700 pt
Right: 730 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: Contacts to FileMaker::Name

Layout Name:

Contacts to FileMaker

Top: 118 pt
Left: 141 pt
Bottom: 149 pt
Right: 394 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: Contacts to FileMaker::MailingAddress

Layout Name:

Contacts to FileMaker

Top: 603 pt
Left: 141 pt
Bottom: 677 pt
Right: 394 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: Contacts to FileMaker::JSON

Layout Name:

Contacts to FileMaker

Top: 39 pt
Left: 61 pt
Bottom: 391 pt
Right: 332 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: PhoneNumbers::Label

Layout Name:

Contacts to FileMaker

Top: 500 pt
Left: 444 pt
Bottom: 531 pt
Right: 598 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: PhoneNumbers::Phone Number

Layout Name:

Contacts to FileMaker

Top: 500 pt
Left: 602 pt
Bottom: 531 pt
Right: 792 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: PhoneNumbers::JSON

Layout Name:

Contacts to FileMaker

Top: 349 pt
Left: 459 pt
Bottom: 701 pt
Right: 730 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: ContactRelations::Label

Layout Name:

Contacts to FileMaker

Top: 123 pt
Left: 846 pt
Bottom: 154 pt
Right: 1000 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: ContactRelations::Name

Layout Name:

Contacts to FileMaker

Top: 123 pt
Left: 1004 pt
Bottom: 154 pt
Right: 1194 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: ContactRelations::JSON

Layout Name:

Contacts to FileMaker

Top: 39 pt
Left: 861 pt
Bottom: 391 pt
Right: 1132 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: Dates::Label

Layout Name:

Contacts to FileMaker

Top: 248 pt
Left: 847 pt
Bottom: 279 pt
Right: 1001 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: Dates::Date

Layout Name:

Contacts to FileMaker

Top: 248 pt
Left: 1005 pt
Bottom: 279 pt
Right: 1195 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: ContactRelations::JSON

Layout Name:

Contacts to FileMaker

Top: 99 pt
Left: 862 pt
Bottom: 451 pt
Right: 1133 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: Check Authorization

Layout Name:

Contacts to FileMaker

Additional Properties:

Change to hand cursor over button

Top: 64 pt
Left: 31 pt
Bottom: 95 pt
Right: 199 pt

Anchoring: Left, Top

Perform Script [ “Check Authorization Status” ]

Scripts:

Check Authorization Status

Button Properties

Coordinates

Script/Script Step

Type:

Text: Request Authorization

Layout Name:

Contacts to FileMaker

Additional Properties:

Change to hand cursor over button

Top: 64 pt
Left: 213 pt
Bottom: 95 pt
Right: 420 pt

Anchoring: Left, Top

Perform Script [ “Request Authorization” ]

Scripts:

Request Authorization

Button Properties

Coordinates

Script/Script Step

Type:

Text: Import Contacts

Layout Name:

Contacts to FileMaker

Additional Properties:

Change to hand cursor over button

Top: 64 pt
Left: 434 pt
Bottom: 95 pt
Right: 602 pt

Anchoring: Left, Top

Perform Script [ “Import Contacts” ]

Scripts:

Import Contacts

Button Properties

Coordinates

Script/Script Step

Type:

Text: Show in Contacts App

Layout Name:

Contacts to FileMaker

Hide Condition:

Length ( Contacts to FileMaker::Contact Identifier ) = 0

Additional Properties:

Change to hand cursor over button

Top: 64 pt
Left: 616 pt
Bottom: 95 pt
Right: 797 pt

Anchoring: Left, Top

Perform Script [ “Show In Addressbook” ]

Scripts:

Show In Addressbook

Popover Buttons

Popover Button Properties		Coordinates
Type: Text: ⚙️ Layout Name: Contacts to FileMaker		Top: 123 pt Left: 408 pt Bottom: 154 pt Right: 439 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "JSON" Position: Right		Top: 5 pt Left: 450 pt Bottom: 405 pt Right: 740 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects Emails::JSON at (39, 459, 391, 730)

Popover Button Properties		Coordinates
Type: Text: ⚙️ Layout Name: Contacts to FileMaker		Top: 248 pt Left: 408 pt Bottom: 279 pt Right: 439 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "JSON" Position: Right		Top: 64 pt Left: 450 pt Bottom: 464 pt Right: 740 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects URLs::JSON at (98, 459, 450, 730)

Popover Button Properties		Coordinates
Type: Text: ⚙️ Layout Name: Contacts to FileMaker		Top: 373 pt Left: 408 pt Bottom: 404 pt Right: 439 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "JSON" Position: Right		Top: 189 pt Left: 450 pt Bottom: 589 pt Right: 740 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects SocialProfiles::JSON at (223, 459, 575, 730)

Popover Button Properties		Coordinates
Type: Text: ⚙️ Layout Name: Contacts to FileMaker		Top: 373 pt Left: 809 pt Bottom: 404 pt Right: 840 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "JSON" Position: Right		Top: 314 pt Left: 450 pt Bottom: 714 pt Right: 740 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects PostalAddresses::JSON at (348, 459, 700, 730)

Popover Button Properties		Coordinates
Type: Text: ⚙️ Layout Name: Contacts to FileMaker		Top: 118 pt Left: 10 pt Bottom: 149 pt Right: 41 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "JSON" Position: Right		Top: 5 pt Left: 52 pt Bottom: 405 pt Right: 342 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects Contacts to FileMaker::JSON at (39, 61, 391, 332)

Popover Button Properties		Coordinates
Type: Text: ⚙️ Layout Name: Contacts to FileMaker		Top: 499 pt Left: 408 pt Bottom: 530 pt Right: 439 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "JSON" Position: Right		Top: 315 pt Left: 450 pt Bottom: 715 pt Right: 740 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects PhoneNumbers::JSON at (349, 459, 701, 730)

Popover Button Properties		Coordinates
Type: Text: ⚙️ Layout Name: Contacts to FileMaker		Top: 124 pt Left: 810 pt Bottom: 155 pt Right: 841 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "JSON" Position: Right		Top: 5 pt Left: 852 pt Bottom: 405 pt Right: 1142 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects ContactRelations::JSON at (39, 861, 391, 1132)

Popover Button Properties		Coordinates
Type: Text: ⚙️ Layout Name: Contacts to FileMaker		Top: 249 pt Left: 811 pt Bottom: 280 pt Right: 842 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "JSON" Position: Right		Top: 65 pt Left: 853 pt Bottom: 465 pt Right: 1143 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects ContactRelations::JSON at (99, 862, 451, 1133)

Table:

Emails

Layout Name:

Contacts to FileMaker

Top: 117 pt
Left: 403 pt
Bottom: 236 pt
Right: 797 pt

Anchoring: Left, Top

Field Objects

Emails::Label at (122, 444, 153, 598)
Emails::Email at (122, 602, 153, 792)
Emails::JSON at (39, 459, 391, 730)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 3
Show vertical scroll bar

Table:

URLs

Layout Name:

Contacts to FileMaker

Top: 243 pt
Left: 403 pt
Bottom: 362 pt
Right: 797 pt

Anchoring: Left, Top

Field Objects

URLs::Label at (248, 444, 279, 598)
URLs::URL at (248, 602, 279, 792)
URLs::JSON at (98, 459, 450, 730)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 3
Show vertical scroll bar

Table:

SocialProfiles

Layout Name:

Contacts to FileMaker

Top: 369 pt
Left: 403 pt
Bottom: 488 pt
Right: 797 pt

Anchoring: Left, Top

Field Objects

SocialProfiles::Label at (374, 444, 405, 598)
SocialProfiles::username at (374, 602, 405, 792)
SocialProfiles::JSON at (223, 459, 575, 730)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 3
Show vertical scroll bar

Table:

PostalAddresses

Layout Name:

Contacts to FileMaker

Top: 369 pt
Left: 806 pt
Bottom: 620 pt
Right: 1198 pt

Anchoring: Left, Top

Field Objects

PostalAddresses::Street at (375, 845, 406, 1193)
PostalAddresses::City at (412, 940, 443, 1064)
PostalAddresses::Country at (412, 1068, 443, 1193)
PostalAddresses::PostalCode at (412, 811, 443, 936)
PostalAddresses::JSON at (348, 459, 700, 730)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 3
Show vertical scroll bar

Table:

PhoneNumbers

Layout Name:

Contacts to FileMaker

Top: 495 pt
Left: 403 pt
Bottom: 614 pt
Right: 797 pt

Anchoring: Left, Top

Field Objects

PhoneNumbers::Label at (500, 444, 531, 598)
PhoneNumbers::Phone Number at (500, 602, 531, 792)
PhoneNumbers::JSON at (349, 459, 701, 730)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 3
Show vertical scroll bar

Table:

ContactRelations

Layout Name:

Contacts to FileMaker

Top: 118 pt
Left: 805 pt
Bottom: 237 pt
Right: 1199 pt

Anchoring: Left, Top

Field Objects

ContactRelations::Label at (123, 846, 154, 1000)
ContactRelations::Name at (123, 1004, 154, 1194)
ContactRelations::JSON at (39, 861, 391, 1132)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 3
Show vertical scroll bar

Table:

Dates

Layout Name:

Contacts to FileMaker

Top: 243 pt
Left: 806 pt
Bottom: 362 pt
Right: 1200 pt

Anchoring: Left, Top

Field Objects

Dates::Label at (248, 847, 279, 1001)
Dates::Date at (248, 1005, 279, 1195)
ContactRelations::JSON at (99, 862, 451, 1133)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 3
Show vertical scroll bar

Layout Objects: Emails

Regular Fields

Field Name: Emails::ContactIdentifier

Layout Name:

Emails

Top: 114 pt
Left: 138 pt
Bottom: 145 pt
Right: 391 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: Emails::EmailIdentifier

Layout Name:

Emails

Top: 149 pt
Left: 138 pt
Bottom: 180 pt
Right: 391 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: Emails::Label

Layout Name:

Emails

Top: 184 pt
Left: 138 pt
Bottom: 215 pt
Right: 391 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: Emails::Email

Layout Name:

Emails

Top: 219 pt
Left: 138 pt
Bottom: 250 pt
Right: 391 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: Emails::JSON

Layout Name:

Emails

Top: 114 pt
Left: 490 pt
Bottom: 250 pt
Right: 743 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

Layout Objects: URLs

Regular Fields

Field Name: URLs::ContactIdentifier

Layout Name:

URLs

Top: 114 pt
Left: 138 pt
Bottom: 145 pt
Right: 391 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: URLs::URLIdentifier

Layout Name:

URLs

Top: 149 pt
Left: 138 pt
Bottom: 180 pt
Right: 391 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: URLs::Label

Layout Name:

URLs

Top: 184 pt
Left: 138 pt
Bottom: 215 pt
Right: 391 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: URLs::URL

Layout Name:

URLs

Top: 219 pt
Left: 138 pt
Bottom: 250 pt
Right: 391 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: URLs::JSON

Layout Name:

URLs

Top: 114 pt
Left: 497 pt
Bottom: 250 pt
Right: 750 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

Layout Objects: SocialProfiles

Regular Fields

Field Name: SocialProfiles::ContactIdentifier

Layout Name:

SocialProfiles

Top: 114 pt
Left: 138 pt
Bottom: 145 pt
Right: 391 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: SocialProfiles::ProfileIdentifier

Layout Name:

SocialProfiles

Top: 149 pt
Left: 138 pt
Bottom: 180 pt
Right: 391 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: SocialProfiles::Label

Layout Name:

SocialProfiles

Top: 184 pt
Left: 138 pt
Bottom: 215 pt
Right: 391 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: SocialProfiles::username

Layout Name:

SocialProfiles

Top: 219 pt
Left: 138 pt
Bottom: 250 pt
Right: 391 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: SocialProfiles::JSON

Layout Name:

SocialProfiles

Top: 114 pt
Left: 495 pt
Bottom: 250 pt
Right: 748 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

Layout Objects: PostalAddresses

Regular Fields

Field Name: PostalAddresses::ContactIdentifier

Layout Name:

PostalAddresses

Top: 122 pt
Left: 179 pt
Bottom: 153 pt
Right: 432 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: PostalAddresses::AddressIdentifier

Layout Name:

PostalAddresses

Top: 157 pt
Left: 179 pt
Bottom: 188 pt
Right: 432 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: PostalAddresses::JSON

Layout Name:

PostalAddresses

Top: 117 pt
Left: 537 pt
Bottom: 468 pt
Right: 790 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: PostalAddresses::Street

Layout Name:

PostalAddresses

Top: 192 pt
Left: 179 pt
Bottom: 223 pt
Right: 432 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: PostalAddresses::PostalCode

Layout Name:

PostalAddresses

Top: 227 pt
Left: 179 pt
Bottom: 258 pt
Right: 432 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: PostalAddresses::City

Layout Name:

PostalAddresses

Top: 262 pt
Left: 179 pt
Bottom: 293 pt
Right: 432 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: PostalAddresses::Country

Layout Name:

PostalAddresses

Top: 297 pt
Left: 179 pt
Bottom: 328 pt
Right: 432 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: PostalAddresses::SubLocality

Layout Name:

PostalAddresses

Top: 332 pt
Left: 179 pt
Bottom: 363 pt
Right: 432 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: PostalAddresses::SubAdministrativeArea

Layout Name:

PostalAddresses

Top: 367 pt
Left: 179 pt
Bottom: 398 pt
Right: 432 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: PostalAddresses::State

Layout Name:

PostalAddresses

Top: 402 pt
Left: 179 pt
Bottom: 433 pt
Right: 432 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: PostalAddresses::ISOCountryCode

Layout Name:

PostalAddresses

Top: 437 pt
Left: 179 pt
Bottom: 468 pt
Right: 432 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

Layout Objects: PhoneNumbers

Regular Fields

Field Name: PhoneNumbers::ContactIdentifier

Layout Name:

PhoneNumbers

Top: 114 pt
Left: 138 pt
Bottom: 145 pt
Right: 391 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: PhoneNumbers::PhoneIdentifier

Layout Name:

PhoneNumbers

Top: 149 pt
Left: 138 pt
Bottom: 180 pt
Right: 391 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: PhoneNumbers::JSON

Layout Name:

PhoneNumbers

Top: 114 pt
Left: 516 pt
Bottom: 251 pt
Right: 769 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: PhoneNumbers::Label

Layout Name:

PhoneNumbers

Top: 184 pt
Left: 138 pt
Bottom: 215 pt
Right: 391 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: PhoneNumbers::Phone Number

Layout Name:

PhoneNumbers

Top: 220 pt
Left: 138 pt
Bottom: 251 pt
Right: 391 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

Layout Objects: ContactRelations

Regular Fields

Field Name: ContactRelations::ContactIdentifier

Layout Name:

ContactRelations

Top: 114 pt
Left: 138 pt
Bottom: 145 pt
Right: 391 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: ContactRelations::RelationIdentifier

Layout Name:

ContactRelations

Top: 149 pt
Left: 138 pt
Bottom: 180 pt
Right: 391 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: ContactRelations::JSON

Layout Name:

ContactRelations

Top: 115 pt
Left: 507 pt
Bottom: 250 pt
Right: 760 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: ContactRelations::Label

Layout Name:

ContactRelations

Top: 184 pt
Left: 138 pt
Bottom: 215 pt
Right: 391 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: ContactRelations::Name

Layout Name:

ContactRelations

Top: 219 pt
Left: 138 pt
Bottom: 250 pt
Right: 391 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

Layout Objects: Dates

Regular Fields

Field Name: Dates::ContactIdentifier

Layout Name:

Dates

Top: 114 pt
Left: 138 pt
Bottom: 145 pt
Right: 391 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: Dates::DateIdentifier

Layout Name:

Dates

Top: 149 pt
Left: 138 pt
Bottom: 180 pt
Right: 391 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: Dates::JSON

Layout Name:

Dates

Top: 114 pt
Left: 503 pt
Bottom: 250 pt
Right: 756 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: Dates::Label

Layout Name:

Dates

Top: 184 pt
Left: 138 pt
Bottom: 215 pt
Right: 391 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: Dates::Date

Layout Name:

Dates

Top: 219 pt
Left: 138 pt
Bottom: 250 pt
Right: 391 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

Check Authorization Status

Request Authorization

Show In Addressbook

Hide Progressbar

Next Script: [Clear]

Script Name	Import Contacts
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	Contacts to FileMaker
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $status; Value:MBS( "CNContactStore.AuthorizationStatus" ) ] If [ $status = "Authorized" ] #okay Else If [ $status = "NotDetermined" ] Show Custom Dialog [ Title: "Please authorize first!"; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] Else If [ $status = "Restricted" ] #partly okay Else If [ $status = "Denied" ] Show Custom Dialog [ Title: "Please authorize first!"; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] End If Set Variable [ $r; Value:MBS("ProgressDialog.Reset") // forget old settings ] Set Variable [ $r; Value:MBS("ProgressDialog.SetBottomText"; "Searching for contacts...") ] Set Variable [ $r; Value:MBS("ProgressDialog.SetTitle"; "Importing Contacts") ] Set Variable [ $r; Value:MBS("ProgressDialog.SetTopText"; "Please wait for us to import contacts to FileMaker.") ] Set Variable [ $r; Value:MBS("ProgressDialog.SetButtonCaption"; "Cancel") ] Set Variable [ $r; Value:MBS("ProgressDialog.ClearImage") ] Set Variable [ $r; Value:MBS("ProgressDialog.SetProgress"; -1) ] Set Variable [ $r; Value:MBS("ProgressDialog.Show") ] Set Variable [ $LastProgress; Value:0 ] Pause/Resume Script [ Duration (seconds): ,1 ] #loop over contacts Go to Layout [ “Contacts to FileMaker” (Contacts to FileMaker) ] Set Variable [ $contacts; Value:MBS( "CNContactStore.Contacts"; 1 ) ] Set Variable [ $ContactCount; Value:ValueCount ( $contacts ) ] If [ $ContactCount > 0 ] Set Variable [ $r; Value:MBS("ProgressDialog.SetProgress"; 0) ] Set Variable [ $ContactIndex; Value:1 ] Loop [ Flush: Always ] Set Variable [ $contactID; Value:GetValue($contacts; $ContactIndex) ] New Record/Request Set Field [ Contacts to FileMaker::Name; MBS("CNContact.Name"; $contactID) ] Set Field [ Contacts to FileMaker::MailingAddress; MBS("CNContact.MailingAddress"; $contactID) ] Set Field [ Contacts to FileMaker::JSON; MBS("CNContact.JSON"; $contactID) ] Set Field [ Contacts to FileMaker::First Name; MBS("CNContact.Value"; $contactID; "givenName") ] Set Field [ Contacts to FileMaker::Last Name; MBS("CNContact.Value"; $contactID; "familyName") ] Set Field [ Contacts to FileMaker::Middle Name; MBS("CNContact.Value"; $contactID; "middleName") ] Set Field [ Contacts to FileMaker::Company; MBS("CNContact.Value"; $contactID; "organizationName") ] Set Field [ Contacts to FileMaker::Job Title; MBS("CNContact.Value"; $contactID; "jobTitle") ] Set Field [ Contacts to FileMaker::Type; MBS("CNContact.Value"; $contactID; "type") ] Set Field [ Contacts to FileMaker::previousFamilyName; MBS("CNContact.Value"; $contactID; "previousFamilyName") ] Set Field [ Contacts to FileMaker::imageData; MBS("CNContact.Value"; $contactID; "imageData") ] Set Field [ Contacts to FileMaker::Contact Identifier; $contactID ] Commit Records/Requests #loop over emails Set Variable [ $Emails; Value:MBS("CNContact.Value"; $contactID; "emailaddresses") ] If [ MBS("IsError") = 0 ] Set Variable [ $Count; Value:MBS("JSON.GetArraySize"; $Emails) ] If [ $Count > 0 ] Set Variable [ $Index; Value:0 ] Loop [ Flush: Defer ] Set Variable [ $JSON; Value:MBS("JSON.GetArrayItem"; $Emails; $Index) ] Go to Layout [ “Emails” (Emails) ] New Record/Request Set Field [ Emails::ContactIdentifier; $contactID ] Set Field [ Emails::EmailIdentifier; JSONGetElement ( $JSON; "identifier" ) ] Set Field [ Emails::Label; Let([ label = JSONGetElement ( $JSON; "label" ); localizedLabel = JSONGetElement ( $JSON; "localizedLabel" ); result = If(Length(localizedLabel) > 0; localizedLabel; label) ]; result) ] Set Field [ Emails::Email; JSONGetElement ( $JSON; "value" ) ] Set Field [ Emails::JSON; $JSON ] Commit Records/Requests Set Variable [ $Index; Value:$Index + 1 ] Exit Loop If [ $Index >= $Count ] End Loop End If End If #loop over URLs Set Variable [ $URLs; Value:MBS("CNContact.Value"; $contactID; "urlAddresses") ] If [ MBS("IsError") = 0 ] Set Variable [ $Count; Value:MBS("JSON.GetArraySize"; $URLs) ] If [ $Count > 0 ] Set Variable [ $Index; Value:0 ] Loop [ Flush: Defer ] Set Variable [ $JSON; Value:MBS("JSON.GetArrayItem"; $URLs; $Index) ] Go to Layout [ “URLs” (URLs) ] New Record/Request Set Field [ URLs::ContactIdentifier; $contactID ] Set Field [ URLs::URLIdentifier; JSONGetElement ( $JSON; "identifier" ) ] Set Field [ URLs::Label; Let([ label = JSONGetElement ( $JSON; "label" ); localizedLabel = JSONGetElement ( $JSON; "localizedLabel" ); result = If(Length(localizedLabel) > 0; localizedLabel; label) ]; result) ] Set Field [ URLs::URL; JSONGetElement ( $JSON; "value" ) ] Set Field [ URLs::JSON; $JSON ] Commit Records/Requests Set Variable [ $Index; Value:$Index + 1 ] Exit Loop If [ $Index >= $Count ] End Loop End If End If #loop over Social profiles Set Variable [ $socialProfiles; Value:MBS("CNContact.Value"; $contactID; "socialProfiles") ] If [ MBS("IsError") = 0 ] Set Variable [ $Count; Value:MBS("JSON.GetArraySize"; $socialProfiles) ] If [ $Count > 0 ] Set Variable [ $Index; Value:0 ] Loop [ Flush: Defer ] Set Variable [ $JSON; Value:MBS("JSON.GetArrayItem"; $socialProfiles; $Index) ] Go to Layout [ “SocialProfiles” (SocialProfiles) ] New Record/Request Set Field [ SocialProfiles::ContactIdentifier; $contactID ] Set Field [ SocialProfiles::ProfileIdentifier; JSONGetElement ( $JSON; "identifier" ) ] Set Field [ SocialProfiles::Label; Let([ label = JSONGetElement ( $JSON; "label" ); localizedLabel = JSONGetElement ( $JSON; "localizedLabel" ); service = JSONGetElement ( $JSON; "value.service" ); result = If(Length(localizedLabel) > 0; localizedLabel; If(Length(service) > 0; service; label)) ]; result) ] Set Field [ SocialProfiles::username; JSONGetElement ( $JSON; "value.username" ) ] Set Field [ SocialProfiles::JSON; $JSON ] Commit Records/Requests Set Variable [ $Index; Value:$Index + 1 ] Exit Loop If [ $Index >= $Count ] End Loop End If End If #loop over postal addresses Set Variable [ $postalAddresses; Value:MBS("CNContact.Value"; $contactID; "postalAddresses") ] If [ MBS("IsError") = 0 ] Set Variable [ $Count; Value:MBS("JSON.GetArraySize"; $postalAddresses) ] If [ $Count > 0 ] Set Variable [ $Index; Value:0 ] Loop [ Flush: Defer ] Set Variable [ $JSON; Value:MBS("JSON.GetArrayItem"; $postalAddresses; $Index) ] Go to Layout [ “PostalAddresses” (PostalAddresses) ] New Record/Request Set Field [ PostalAddresses::ContactIdentifier; $contactID ] Set Field [ Emails::EmailIdentifier; JSONGetElement ( $JSON; "identifier" ) ] Set Field [ PostalAddresses::Street; JSONGetElement ( $JSON; "value.street" ) ] Set Field [ PostalAddresses::PostalCode; JSONGetElement ( $JSON; "value.postalCode" ) ] Set Field [ PostalAddresses::City; JSONGetElement ( $JSON; "value.city" ) ] Set Field [ PostalAddresses::Country; JSONGetElement ( $JSON; "value.country" ) ] Set Field [ PostalAddresses::SubLocality; JSONGetElement ( $JSON; "value.subLocality" ) ] Set Field [ PostalAddresses::SubAdministrativeArea; JSONGetElement ( $JSON; "value.subAdministrativeArea" ) ] Set Field [ PostalAddresses::State; JSONGetElement ( $JSON; "value.state" ) ] Set Field [ PostalAddresses::ISOCountryCode; JSONGetElement ( $JSON; "value.ISOCountryCode" ) ] Set Field [ PostalAddresses::JSON; $JSON ] Commit Records/Requests Set Variable [ $Index; Value:$Index + 1 ] Exit Loop If [ $Index >= $Count ] End Loop End If End If #loop over Phone Numbers Set Variable [ $phoneNumbers; Value:MBS("CNContact.Value"; $contactID; "phoneNumbers") ] If [ MBS("IsError") = 0 ] Set Variable [ $Count; Value:MBS("JSON.GetArraySize"; $phoneNumbers) ] If [ $Count > 0 ] Set Variable [ $Index; Value:0 ] Loop [ Flush: Defer ] Set Variable [ $JSON; Value:MBS("JSON.GetArrayItem"; $phoneNumbers; $Index) ] Go to Layout [ “PhoneNumbers” (PhoneNumbers) ] New Record/Request Set Field [ PhoneNumbers::ContactIdentifier; $contactID ] Set Field [ PhoneNumbers::PhoneIdentifier; JSONGetElement ( $JSON; "identifier" ) ] Set Field [ PhoneNumbers::Label; Let([ label = JSONGetElement ( $JSON; "label" ); localizedLabel = JSONGetElement ( $JSON; "localizedLabel" ); result = If(Length(localizedLabel) > 0; localizedLabel; label) ]; result) ] Set Field [ PhoneNumbers::Phone Number; JSONGetElement ( $JSON; "value" ) ] Set Field [ PhoneNumbers::JSON; $JSON ] Commit Records/Requests Set Variable [ $Index; Value:$Index + 1 ] Exit Loop If [ $Index >= $Count ] End Loop End If End If #loop over Contact Relations Set Variable [ $contactRelations; Value:MBS("CNContact.Value"; $contactID; "contactRelations") ] If [ MBS("IsError") = 0 ] Set Variable [ $Count; Value:MBS("JSON.GetArraySize"; $contactRelations) ] If [ $Count > 0 ] Set Variable [ $Index; Value:0 ] Loop [ Flush: Defer ] Set Variable [ $JSON; Value:MBS("JSON.GetArrayItem"; $contactRelations; $Index) ] Go to Layout [ “ContactRelations” (ContactRelations) ] New Record/Request Set Field [ ContactRelations::ContactIdentifier; $contactID ] Set Field [ ContactRelations::RelationIdentifier; JSONGetElement ( $JSON; "identifier" ) ] Set Field [ ContactRelations::Label; Let([ label = JSONGetElement ( $JSON; "label" ); localizedLabel = JSONGetElement ( $JSON; "localizedLabel" ); result = If(Length(localizedLabel) > 0; localizedLabel; label) ]; result) ] Set Field [ ContactRelations::Name; JSONGetElement ( $JSON; "value" ) ] Set Field [ ContactRelations::JSON; $JSON ] Commit Records/Requests Set Variable [ $Index; Value:$Index + 1 ] Exit Loop If [ $Index >= $Count ] End Loop End If End If #loop over Dates Set Variable [ $JSON; Value:MBS("CNContact.Value"; $contactID; "birthday") ] If [ Length ( $JSON ) > 3 ] Go to Layout [ “Dates” (Dates) ] New Record/Request Set Field [ Dates::ContactIdentifier; $contactID ] Set Field [ Dates::DateIdentifier; "" ] Set Field [ Dates::Label; "Birthday" ] Set Variable [ $day; Value:JSONGetElement ( $JSON; "day" ) ] Set Variable [ $month; Value:JSONGetElement ( $JSON; "month" ) ] Set Variable [ $year; Value:JSONGetElement ( $JSON; "year" ) ] Set Field [ Dates::Date; If ( $year = ""; $day & "." & $month; // birthday without year Date ( $month ; $day ; $year )) ] Set Field [ Dates::JSON; $JSON ] Commit Records/Requests End If Set Variable [ $dates; Value:MBS("CNContact.Value"; $contactID; "dates") ] If [ MBS("IsError") = 0 ] Set Variable [ $Count; Value:MBS("JSON.GetArraySize"; $dates) ] If [ $Count > 0 ] Set Variable [ $Index; Value:0 ] Loop [ Flush: Defer ] Set Variable [ $JSON; Value:MBS("JSON.GetArrayItem"; $dates; $Index) ] Go to Layout [ “Dates” (Dates) ] New Record/Request Set Field [ Dates::ContactIdentifier; $contactID ] Set Field [ Dates::DateIdentifier; JSONGetElement ( $JSON; "identifier" ) ] Set Field [ Dates::Label; Let([ label = JSONGetElement ( $JSON; "label" ); localizedLabel = JSONGetElement ( $JSON; "localizedLabel" ); result = If(Length(localizedLabel) > 0; localizedLabel; label) ]; result) ] Set Variable [ $day; Value:JSONGetElement ( $JSON; "value.day" ) ] Set Variable [ $month; Value:JSONGetElement ( $JSON; "value.month" ) ] Set Variable [ $year; Value:JSONGetElement ( $JSON; "value.year" ) ] Set Field [ Dates::Date; If ( $year = ""; $day & "." & $month; // birthday without year Date ( $month ; $day ; $year )) ] Set Field [ Dates::JSON; $JSON ] Commit Records/Requests Set Variable [ $Index; Value:$Index + 1 ] Exit Loop If [ $Index >= $Count ] End Loop End If End If Go to Layout [ “Contacts to FileMaker” (Contacts to FileMaker) ] Set Variable [ $NewProgress; Value:Round($ContactIndex * 100 / $ContactCount; 0) ] #only update every few entries to not slow down the script with redrawing the progress bar If [ $NewProgress > $LastProgress +2 ] Set Variable [ $LastProgress; Value:$NewProgress ] Set Variable [ $r; Value:MBS("ProgressDialog.SetProgress"; $NewProgress) ] Set Variable [ $r; Value:MBS("ProgressDialog.SetBottomText"; GetAsText ( $ContactIndex) & " of " & $ContactCount) ] Set Variable [ $r; Value:MBS("ProgressDialog.Update") ] End If #next Set Variable [ $ContactIndex; Value:$ContactIndex + 1 ] Exit Loop If [ $ContactIndex > $ContactCount ] // Exit Loop If [ $ContactIndex > 10 ] Exit Loop If [ MBS("ProgressDialog.GetCancel") = 1 ] End Loop End If Set Variable [ $r; Value:MBS("ProgressDialog.Hide") ]
Fields used in this script	Contacts to FileMaker::Name Contacts to FileMaker::MailingAddress Contacts to FileMaker::JSON Contacts to FileMaker::First Name Contacts to FileMaker::Last Name Contacts to FileMaker::Middle Name Contacts to FileMaker::Company Contacts to FileMaker::Job Title Contacts to FileMaker::Type Contacts to FileMaker::previousFamilyName Contacts to FileMaker::imageData Contacts to FileMaker::Contact Identifier Emails::ContactIdentifier Emails::EmailIdentifier Emails::Label Emails::Email Emails::JSON URLs::ContactIdentifier URLs::URLIdentifier URLs::Label URLs::URL URLs::JSON SocialProfiles::ContactIdentifier SocialProfiles::ProfileIdentifier SocialProfiles::Label SocialProfiles::username SocialProfiles::JSON PostalAddresses::ContactIdentifier PostalAddresses::Street PostalAddresses::PostalCode PostalAddresses::City PostalAddresses::Country PostalAddresses::SubLocality PostalAddresses::SubAdministrativeArea PostalAddresses::State PostalAddresses::ISOCountryCode PostalAddresses::JSON PhoneNumbers::ContactIdentifier PhoneNumbers::PhoneIdentifier PhoneNumbers::Label PhoneNumbers::Phone Number PhoneNumbers::JSON ContactRelations::ContactIdentifier ContactRelations::RelationIdentifier ContactRelations::Label ContactRelations::Name ContactRelations::JSON Dates::ContactIdentifier Dates::DateIdentifier Dates::Label Dates::Date Dates::JSON
Scripts used in this script
Layouts used in this script	Contacts to FileMaker Emails URLs SocialProfiles PostalAddresses PhoneNumbers ContactRelations Dates
Tables used in this script	ContactRelations Contacts to FileMaker Dates Emails PhoneNumbers PostalAddresses SocialProfiles URLs
Table occurrences used by this script	ContactRelations Contacts to FileMaker Dates Emails PhoneNumbers PostalAddresses SocialProfiles URLs
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Import Contacts]

Next Script: [Check Authorization Status]

Script Name	Clear
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	Truncate Table [ No dialog; Table: “Contacts to FileMaker” ] Truncate Table [ No dialog; Table: “Emails” ] Truncate Table [ No dialog; Table: “URLs” ] Truncate Table [ No dialog; Table: “SocialProfiles” ] Truncate Table [ No dialog; Table: “PostalAddresses” ] Truncate Table [ No dialog; Table: “PhoneNumbers” ] Truncate Table [ No dialog; Table: “ContactRelations” ] Truncate Table [ No dialog; Table: “Dates” ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Clear]

Next Script: [Request Authorization]

Script Name	Check Authorization Status
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	Contacts to FileMaker
Scripts that use this script
Script Definition
Script Steps	Show Custom Dialog [ Title: "Authorization Status"; Message: MBS( "CNContactStore.AuthorizationStatus" ); Default Button: “OK”, Commit: “Yes” ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Check Authorization Status]

Next Script: [Show In Addressbook]

Script Name	Request Authorization
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	Contacts to FileMaker
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS( "CNContactStore.RequestAccesss" ) ] Pause/Resume Script [ Duration (seconds): 1 ] Set Variable [ $r; Value:MBS( "CNContactStore.AuthorizationError" ) ] If [ Length($r) > 0 ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ] End If Set Variable [ $groups; Value:MBS( "CNContactStore.Groups" ) ] If [ Length ( $groups ) = 0 ] Show Custom Dialog [ Title: "Possible Problem"; Message: "Either you have no groups or you did not code sign the app?"; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Request Authorization]

Next Script: [Hide Progressbar]

Script Name	Show In Addressbook
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	Contacts to FileMaker
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("CNContact.ShowInAddressbook"; Contacts to FileMaker::Contact Identifier) ]
Fields used in this script	Contacts to FileMaker::Contact Identifier
Scripts used in this script
Layouts used in this script
Tables used in this script	Contacts to FileMaker
Table occurrences used by this script	Contacts to FileMaker
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Show In Addressbook]

Script Name	Hide Progressbar
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	Set Variable [ $r; Value:MBS("ProgressDialog.Hide") ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Download example: Contacts to FileMaker

Used functions: