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

MBS FileMaker Plugin Example Databases

JSON Test

All examples are included with download of MBS FileMaker Plugin.

JSON Test.fmp12

Overview
Tables 1
Relationships 0
Layouts 1
Scripts 2
Value Lists 0
Custom Functions 0
Custom Menus 33
File Options
Default custom menu set [Standard FileMaker Menus]
Default theme Minimalist
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 Off
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
JSON Test
6 fields defined, 2 records
 JSON Test

Fields

Table Name: JSON Test - 6 Fields
Field Name Type Options Comments On Layouts In Relationships In Scripts In Value Lists
FirstName Normal, Text Auto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      LastName Normal, Text Auto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          Email1 Normal, Text Auto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              Email2 Normal, Text Auto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  Email3 Normal, Text Auto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      JSON Normal, Text Auto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German

                          Layout Objects: JSON Test

                          Regular Fields

                          Field Name: JSON Test::FirstName
                          Field Properties Coordinates Field Format Field Behavior Quick Find
                          • Top: 31 pt
                          • Left: 106 pt
                          • Bottom: 50 pt
                          • Right: 359 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: JSON Test::LastName
                          Field Properties Coordinates Field Format Field Behavior Quick Find
                          • Top: 54 pt
                          • Left: 106 pt
                          • Bottom: 73 pt
                          • Right: 359 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: JSON Test::Email1
                          Field Properties Coordinates Field Format Field Behavior Quick Find
                          • Top: 77 pt
                          • Left: 106 pt
                          • Bottom: 96 pt
                          • Right: 359 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: JSON Test::Email2
                          Field Properties Coordinates Field Format Field Behavior Quick Find
                          • Top: 100 pt
                          • Left: 106 pt
                          • Bottom: 119 pt
                          • Right: 359 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: JSON Test::Email3
                          Field Properties Coordinates Field Format Field Behavior Quick Find
                          • Top: 123 pt
                          • Left: 106 pt
                          • Bottom: 142 pt
                          • Right: 359 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: JSON Test::JSON
                          Field Properties Coordinates Field Format Field Behavior Quick Find
                          • Top: 146 pt
                          • Left: 106 pt
                          • Bottom: 251 pt
                          • Right: 359 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

                          Buttons

                          Button Properties Coordinates Script/Script Step
                            Type:
                          • Text: Build JSON
                            Additional Properties:
                          • Change to hand cursor over button
                          • Top: 38 pt
                          • Left: 381 pt
                          • Bottom: 73 pt
                          • Right: 531 pt
                          • Anchoring: Left, Top
                          		 Perform Script [ “BuildJSON” ]

                          Scripts:

                          Button Properties Coordinates Script/Script Step
                            Type:
                          • Text: Parse JSON
                            Additional Properties:
                          • Change to hand cursor over button
                          • Top: 88 pt
                          • Left: 381 pt
                          • Bottom: 123 pt
                          • Right: 531 pt
                          • Anchoring: Left, Top
                          		 Perform Script [ “ParseJSON” ]

                          Scripts:

                          Script Hierarchy

                          BuildJSON
                          ParseJSON

                          Next Script: [ParseJSON]
                          Script Name BuildJSON
                          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
                            • #Get Array of Emails
                            • Set Variable [ $Emails; Value:MBS("JSON.CreateStringArray"; JSON Test::Email1; JSON Test::Email2; JSON Test::Email3) ]
                            • #Encode Strings
                            • Set Variable [ $FirstName; Value:MBS("JSON.CreateString"; JSON Test::FirstName) ]
                            • Set Variable [ $LastName; Value:MBS("JSON.CreateString"; JSON Test::LastName) ]
                            • #Create Object
                            • Set Variable [ $object; Value:MBS("JSON.CreateObject") ]
                            • #Add items to object
                            • Set Variable [ $object; Value:MBS("JSON.AddItemToObject"; $object; "FirstName"; $FirstName) ]
                            • Set Variable [ $object; Value:MBS("JSON.AddItemToObject"; $object; "LastName"; $LastName) ]
                            • Set Variable [ $object; Value:MBS("JSON.AddItemToObject"; $object; "Emails"; $Emails) ]
                            • #Set field with final JSON string
                            • Set Field [ JSON Test::JSON; $object ]
                            • #Done
                            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: [BuildJSON]
                                    Script Name ParseJSON
                                    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 [ $json; Value:JSON Test::JSON ]
                                      • #First Name
                                      • Set Variable [ $FirstNameJSON; Value:MBS("JSON.GetObjectItem"; $json; "Firstname") ]
                                      • Set Variable [ $FirstName; Value:MBS("JSON.GetStringValue"; $FirstNameJSON) ]
                                      • Set Field [ JSON Test::FirstName; $FirstName ]
                                      • #Last Name
                                      • Set Variable [ $LastNameJSON; Value:MBS("JSON.GetObjectItem"; $json; "LastName") ]
                                      • Set Variable [ $LastName; Value:MBS("JSON.GetStringValue"; $LastNameJSON) ]
                                      • Set Field [ JSON Test::LastName; $LastName ]
                                      • #Emails
                                      • Set Variable [ $EmailsJSON; Value:MBS("JSON.GetObjectItem"; $json; "Emails") ]
                                      • Set Variable [ $Email1JSON; Value:MBS("JSON.GetArrayItem"; $EmailsJSON; 0) ]
                                      • Set Variable [ $Email2JSON; Value:MBS("JSON.GetArrayItem"; $EmailsJSON; 1) ]
                                      • Set Variable [ $Email3JSON; Value:MBS("JSON.GetArrayItem"; $EmailsJSON; 2) ]
                                      • Set Variable [ $Email1; Value:MBS("JSON.GetStringValue"; $Email1JSON) ]
                                      • Set Variable [ $Email2; Value:MBS("JSON.GetStringValue"; $Email2JSON) ]
                                      • Set Variable [ $Email3; Value:MBS("JSON.GetStringValue"; $Email3JSON) ]
                                      • Set Field [ JSON Test::Email1; $Email1 ]
                                      • Set Field [ JSON Test::Email2; $Email2 ]
                                      • Set Field [ JSON Test::Email3; $Email3 ]
                                      • #Done
                                      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: JSON Test

                                              Used functions: