Monkeybread Software - MBS FileMaker Plugin: JSON Insert and Update

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

MBS FileMaker Plugin Example Databases

JSON Insert and Update

All examples are included with download of MBS FileMaker Plugin.

JSON Insert and Update.fmp12

Overview
Tables	2
Relationships	1
Layouts	2
Scripts	8
Value Lists	0
Custom Functions	1
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	Occurrences in Relationship Graph
Table	11 fields defined, 1 record	Table
Data	10 fields defined, 0 record	Data

Fields

Table Name: Table - 11 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: Table 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		TablexData
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
JSON Insert	Normal, Text	Auto-Enter: Allow editing Context table: Table Calculation: cfFormatJSON ( Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table		JSON Insert Set Variables with JSON
JSON Update	Normal, Text	Auto-Enter: Allow editing Context table: Table Calculation: cfFormatJSON ( Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table		JSON Update JSON Updates
JSON InsertOrUpdate	Normal, Text	Auto-Enter: Allow editing Context table: Table Calculation: cfFormatJSON ( Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table		JSON Insert or Update
JSON Delete	Normal, Text	Auto-Enter: Allow editing Context table: Table Calculation: cfFormatJSON ( Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table		JSON Delete JSON Deletes
JSON Update PrimaryKeys	Normal, Text	Auto-Enter: Allow editing Context table: Table Calculation: cfFormatJSON ( Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table		JSON Update JSON Updates
JSON InsertORUpdate PrimaryKeys	Normal, Text	Auto-Enter: Allow editing Context table: Table Calculation: cfFormatJSON ( Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table		JSON Insert or Update

Table Name: Data - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: Data 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		TablexData
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
FirstName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Table Data
LastName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Table Data
Birthday	Normal, Date	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table Data
Donation	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table Data
Status	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Table Data

Layout Objects: Table

Regular Fields

Field Name: Table::JSON Insert

Layout Name:

Table

Top: 61 pt
Left: 138 pt
Bottom: 216 pt
Right: 525 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: Table::JSON Update

Layout Name:

Table

Top: 220 pt
Left: 138 pt
Bottom: 375 pt
Right: 525 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: Table::JSON InsertOrUpdate

Layout Name:

Table

Top: 461 pt
Left: 138 pt
Bottom: 616 pt
Right: 525 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: Table::JSON Delete

Layout Name:

Table

Top: 702 pt
Left: 138 pt
Bottom: 857 pt
Right: 525 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: Data::FirstName

Layout Name:

Table

Top: 75 pt
Left: 544 pt
Bottom: 106 pt
Right: 633 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: Data::LastName

Layout Name:

Table

Top: 75 pt
Left: 637 pt
Bottom: 106 pt
Right: 726 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: Data::Birthday

Layout Name:

Table

Top: 75 pt
Left: 730 pt
Bottom: 106 pt
Right: 818 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: Data::Donation

Layout Name:

Table

Top: 75 pt
Left: 822 pt
Bottom: 106 pt
Right: 911 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: Data::Status

Layout Name:

Table

Top: 75 pt
Left: 915 pt
Bottom: 106 pt
Right: 1004 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: Table::JSON Update PrimaryKeys

Layout Name:

Table

Top: 379 pt
Left: 138 pt
Bottom: 456 pt
Right: 525 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: Table::JSON InsertORUpdate PrimaryKeys

Layout Name:

Table

Top: 619 pt
Left: 138 pt
Bottom: 696 pt
Right: 525 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: Insert

Layout Name:

Table

Top: 106 pt
Left: 17 pt
Bottom: 137 pt
Right: 127 pt

Anchoring: Left, Top

Perform Script [ “JSON Insert” ]

Scripts:

JSON Insert

Button Properties

Coordinates

Script/Script Step

Type:

Text: Update

Layout Name:

Table

Additional Properties:

Change to hand cursor over button

Top: 253 pt
Left: 14 pt
Bottom: 284 pt
Right: 124 pt

Anchoring: Left, Top

Perform Script [ “JSON Update” ]

Scripts:

JSON Update

Button Properties

Coordinates

Script/Script Step

Type:

Text: Insert or Update

Layout Name:

Table

Additional Properties:

Change to hand cursor over button

Top: 512 pt
Left: 14 pt
Bottom: 558 pt
Right: 124 pt

Anchoring: Left, Top

Perform Script [ “JSON Insert or Update” ]

Scripts:

JSON Insert or Update

Button Properties

Coordinates

Script/Script Step

Type:

Text: Delete

Layout Name:

Table

Additional Properties:

Change to hand cursor over button

Top: 735 pt
Left: 14 pt
Bottom: 766 pt
Right: 124 pt

Anchoring: Left, Top

Perform Script [ “JSON Delete” ]

Scripts:

JSON Delete

Table:

Data

Layout Name:

Table

Top: 70 pt
Left: 539 pt
Bottom: 696 pt
Right: 1009 pt

Anchoring: Left and Right, Top and Bottom

Field Objects

Data::FirstName at (75, 544, 106, 633)
Data::LastName at (75, 637, 106, 726)
Data::Birthday at (75, 730, 106, 818)
Data::Donation at (75, 822, 106, 911)
Data::Status at (75, 915, 106, 1004)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 16

Layout Objects: Data

Regular Fields

Field Name: Data::FirstName

Layout Name:

Data

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: Data::LastName

Layout Name:

Data

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: Data::Birthday

Layout Name:

Data

Top: 184 pt
Left: 138 pt
Bottom: 215 pt
Right: 259 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: Data::Donation

Layout Name:

Data

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

Layout Name:

Data

Top: 254 pt
Left: 138 pt
Bottom: 285 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

JSON Insert or Update

JSON Delete

JSON Deletes

CSV Insert

Set Variables with JSON

Next Script: [JSON Update]

Script Name	JSON Insert
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	Table
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("JSON.InsertRecord"; ""; "Data"; Table::JSON Insert) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to insert."; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	Table::JSON Insert
Scripts used in this script
Layouts used in this script
Tables used in this script	Table
Table occurrences used by this script	Table
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [JSON Insert]

Next Script: [JSON Updates]

Script Name	JSON Update
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	Table
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("JSON.UpdateRecord"; ""; "Data"; Table::JSON Update PrimaryKeys; Table::JSON Update) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to update."; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	Table::JSON Update PrimaryKeys Table::JSON Update
Scripts used in this script
Layouts used in this script
Tables used in this script	Table
Table occurrences used by this script	Table
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [JSON Update]

Next Script: [JSON Insert or Update]

Script Name	JSON Updates
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("JSON.UpdateRecords"; ""; "Data"; Table::JSON Update PrimaryKeys; Table::JSON Update) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to update."; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	Table::JSON Update PrimaryKeys Table::JSON Update
Scripts used in this script
Layouts used in this script
Tables used in this script	Table
Table occurrences used by this script	Table
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [JSON Updates]

Next Script: [JSON Delete]

Script Name	JSON Insert or Update
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	Table
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("JSON.InsertOrUpdateRecord"; ""; "Data"; Table::JSON InsertORUpdate PrimaryKeys; Table::JSON InsertOrUpdate) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to insert."; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	Table::JSON InsertORUpdate PrimaryKeys Table::JSON InsertOrUpdate
Scripts used in this script
Layouts used in this script
Tables used in this script	Table
Table occurrences used by this script	Table
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [JSON Insert or Update]

Next Script: [JSON Deletes]

Script Name	JSON Delete
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	Table
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("JSON.DeleteRecord"; ""; "Data"; Table::JSON Delete) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to insert."; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	Table::JSON Delete
Scripts used in this script
Layouts used in this script
Tables used in this script	Table
Table occurrences used by this script	Table
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [JSON Delete]

Next Script: [CSV Insert]

Script Name	JSON Deletes
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("JSON.DeleteRecords"; ""; "Data"; Table::JSON Delete) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to insert."; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	Table::JSON Delete
Scripts used in this script
Layouts used in this script
Tables used in this script	Table
Table occurrences used by this script	Table
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [JSON Deletes]

Next Script: [Set Variables with JSON]

Script Name	CSV Insert
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 [ $CSV; Value:"Kate;Berry;20.07.1956;20;Done" & ¶ & "Clarie;Jones;02.03.1963;50;Coming" ] Set Variable [ $FieldNames; Value:"FirstName¶LastName¶Birthday¶Donation¶Status" ] Set Variable [ $r; Value:MBS( "FM.InsertRecordCSV"; ""; "Data"; $FieldNames; $CSV ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to insert."; Message: $r; 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: [CSV Insert]

Script Name	Set Variables with JSON
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 [ $Variables; Value:MBS("JSON.SetVariables"; Table::JSON Insert) ] #@variable $FirstName, $LastName, $Birthday Show Custom Dialog [ Title: "Names"; Message: $FirstName; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] Set Variable [ $r; Value:MBS("JSON.ClearVariables"; $Variables) ]
Fields used in this script	Table::JSON Insert
Scripts used in this script
Layouts used in this script
Tables used in this script	Table
Table occurrences used by this script	Table
Custom Functions used by this script
Custom menu set used by this script

Custom Functions

Function Name	Parameters	Availability	Definition	In Field Definitions	In Scripts
cfFormatJSON	InputJSON	All accounts	Let ( [ jsonFormatted = MBS("JSON.Format"; InputJSON); jsonFormatFailed = MBS("IsError"); jsonText = If(jsonFormatFailed; InputJSON; jsonFormatted); result = MBS("JSON.Colorize"; jsonText) ]; result )	Table::JSON Insert Table::JSON Update Table::JSON InsertOrUpdate Table::JSON Delete Table::JSON Update PrimaryKeys Table::JSON InsertORUpdate PrimaryKeys

Custom Menu Sets

Menu Sets	Menus	In Scripts	In Layouts	Comments
[Standard FileMaker Menus]	All Standard Menus

Download example: JSON Insert and Update

Used functions: