MBS FileMaker Plugin Example Databases

Global Variables

All examples are included with download of MBS FileMaker Plugin.

Global Variables.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts3
Value Lists0
Custom Functions0
Custom Menus30
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
Variables
4 fields defined, 1 record
Variables

Fields

Table Name: Variables - 4 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
VariableNameNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: English
      VariableValueNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: English
          ResultNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: English
              VariableValue__lctCalculated, TextCalculation: Storage:
              • Repetitions: 1
              • Do not store calculation results
              • Index Language: English

                    Layout Objects: Variables

                    Regular Fields

                    Field Name: Variables::VariableName
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 65 pt
                    • Left: 299 pt
                    • Bottom: 82 pt
                    • Right: 396 pt
                    • Anchoring: Left, Top
                    Field Format:
                    • Edit Box
                    Field Behavior:
                    • Allow field to be entered: In Find mode, In Browse mode
                    • Touch keyboard type: System Default
                    • Go to next field using: Tab key
                    Yes

                    Field Name: Variables::VariableValue
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 65 pt
                    • Left: 401 pt
                    • Bottom: 82 pt
                    • Right: 492 pt
                    • Anchoring: Left, Top
                    Field Format:
                    • Edit Box
                    Field Behavior:
                    • Allow field to be entered: In Find mode, In Browse mode
                    • Touch keyboard type: System Default
                    • Go to next field using: Tab key
                    Yes

                    Field Name: Variables::Result
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 431 pt
                    • Left: 156 pt
                    • Bottom: 448 pt
                    • Right: 409 pt
                    • Anchoring: Left, Top
                    Field Format:
                    • Edit Box
                    Field Behavior:
                    • Allow field to be entered: In Find mode, In Browse mode
                    • Touch keyboard type: System Default
                    • Go to next field using: Tab key
                    Yes

                    Field Name: Variables::VariableValue__lct
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 135 pt
                    • Left: 333 pt
                    • Bottom: 152 pt
                    • Right: 496 pt
                    • Anchoring: Left, Top
                    Field Format:
                    • Edit Box
                    Field Behavior:
                    • Allow field to be entered: In Find mode, In Browse mode
                    • Touch keyboard type: System Default
                    • Go to next field using: Tab key
                    Yes

                    Field Name: Variables::VariableName
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 247 pt
                    • Left: 332 pt
                    • Bottom: 264 pt
                    • Right: 429 pt
                    • Anchoring: Left, Top
                    Field Format:
                    • Edit Box
                    Field Behavior:
                    • Allow field to be entered: In Find mode, In Browse mode
                    • Touch keyboard type: System Default
                    • Go to next field using: Tab key
                    Yes

                    Merge Fields

                    Field PropertiesCoordinatesFieldsQuick Find
                    • Top: 135 pt
                    • Left: 0 pt
                    • Bottom: 167 pt
                    • Right: 328 pt
                    • Anchoring: Left, Top
                    Yes

                    Group Buttons

                    Button PropertiesCoordinatesScript/Script Step
                      Type:
                    • Text: Set
                      Additional Properties:
                    • Change to hand cursor over button
                    • Rectangular
                    • Top: 62 pt
                    • Left: 62 pt
                    • Bottom: 87 pt
                    • Right: 135 pt
                    • Anchoring: Left, Top
                    Perform Script [ “Set the Variable” ]

                    Scripts:


                    Button PropertiesCoordinatesScript/Script Step
                      Type:
                    • Text: Clear
                      Additional Properties:
                    • Change to hand cursor over button
                    • Rectangular
                    • Top: 244 pt
                    • Left: 83 pt
                    • Bottom: 269 pt
                    • Right: 156 pt
                    • Anchoring: Left, Top
                    Perform Script [ “Clear the Variable” ]

                    Scripts:


                    Script Hierarchy

                    Set the Variable
                    Clear the Variable
                    List Variables

                    Next Script: [Clear the Variable]
                    Script NameSet the Variable
                    Run script with full access privilegesOff
                    Include In MenuYes
                    Layouts that use this script
                    Scripts that use this script
                      Script Definition
                      Script Steps
                      • Set Field [ Variables::Result; MBS("FM.VariableSet"; Variables::VariableName; Variables::VariableValue) ]
                      • #refresh the window so the unstored calc updates
                      • Commit Records/Requests [ No dialog ]
                      • Refresh Window
                      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: [Set the Variable]Next Script: [List Variables]
                              Script NameClear the Variable
                              Run script with full access privilegesOff
                              Include In MenuYes
                              Layouts that use this script
                              Scripts that use this script
                                Script Definition
                                Script Steps
                                • Set Field [ Variables::Result; MBS("FM.VariableClear"; Variables::VariableName) ]
                                • #refresh the window so the unstored calc updates
                                • Commit Records/Requests [ No dialog ]
                                • Refresh Window
                                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 the Variable]
                                        Script NameList Variables
                                        Run script with full access privilegesOff
                                        Include In MenuYes
                                        Layouts that use this script
                                          Scripts that use this script
                                            Script Definition
                                            Script Steps
                                            • Show Custom Dialog [ Message: MBS("FM.VariableList"; ": "); Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                            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: Global Variables

                                                          Used functions:




                                                          Links
                                                          MBS FileMaker blog