MBS FileMaker Plugin Example Databases

Colors

All examples are included with download of MBS FileMaker Plugin.

Colors.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts3
Value Lists0
Custom Functions0
Custom Menus33
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
Colors
7 fields defined, 655 records
Colors

Fields

Table Name: Colors - 7 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
NameNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      HexadecimalNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
            RedNormal, NumberAuto-Enter:
            • Allow editing
            Validation:
            • Only during data entry
            • Range: 0 - 255
            Storage:
            • Repetitions: 1
            • Indexing: None
            • Automatically create indexes as needed
            • Index Language: German
                  GreenNormal, NumberAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  • Range: 0 - 255
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                        BlueNormal, NumberAuto-Enter:
                        • Allow editing
                        Validation:
                        • Only during data entry
                        • Range: 0 - 255
                        Storage:
                        • Repetitions: 1
                        • Indexing: None
                        • Automatically create indexes as needed
                        • Index Language: German
                              FormattedTextNormal, TextAuto-Enter: Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  ImageNormal, BinaryAuto-Enter: Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1

                                      Layout Objects: Colors

                                      Regular Fields

                                      Field Name: Colors::Name
                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                      • Top: 60 pt
                                      • Left: 6 pt
                                      • Bottom: 74 pt
                                      • Right: 157 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: Colors::Hexadecimal
                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                      • Top: 60 pt
                                      • Left: 312 pt
                                      • Bottom: 74 pt
                                      • Right: 397 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: Colors::Red
                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                      • Top: 60 pt
                                      • Left: 162 pt
                                      • Bottom: 74 pt
                                      • Right: 201 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: Colors::Green
                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                      • Top: 60 pt
                                      • Left: 204 pt
                                      • Bottom: 74 pt
                                      • Right: 243 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: Colors::Blue
                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                      • Top: 60 pt
                                      • Left: 246 pt
                                      • Bottom: 74 pt
                                      • Right: 284 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: Colors::FormattedText
                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                      • Top: 60 pt
                                      • Left: 408 pt
                                      • Bottom: 74 pt
                                      • Right: 553 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: Colors::Image
                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                      • Top: 57 pt
                                      • Left: 564 pt
                                      • Bottom: 80 pt
                                      • Right: 607 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
                                      No

                                      Group Buttons

                                      Button PropertiesCoordinatesScript/Script Step
                                        Type:
                                      • Text: Run
                                        Additional Properties:
                                      • Change to hand cursor over button
                                      • Rectangular
                                      • Top: 6 pt
                                      • Left: 486 pt
                                      • Bottom: 31 pt
                                      • Right: 559 pt
                                      • Anchoring: Left, Top
                                      Perform Script [ “Create all” ]

                                      Scripts:


                                      Script Hierarchy

                                      Create all
                                      Clear all
                                      Trace

                                      Next Script: [Clear all]
                                      Script NameCreate all
                                      Run script with full access privilegesOff
                                      Include In MenuYes
                                      Layouts that use this script
                                      Scripts that use this script
                                        Script Definition
                                        Script Steps
                                        • Go to Record/Request/Page [ First ]
                                        • Loop
                                        • Set Field [ Colors::FormattedText; "" ]
                                        • Set Field [ Colors::Image; "" ]
                                        • Set Field [ Colors::Name; Colors::Name ]
                                        • Commit Records/Requests [ No dialog ]
                                        • Go to Record/Request/Page [ Next; Exit after last ]
                                        • End Loop
                                        • Go to Record/Request/Page [ First ]
                                        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: [Create all]Next Script: [Trace]
                                                Script NameClear all
                                                Run script with full access privilegesOff
                                                Include In MenuYes
                                                Layouts that use this script
                                                  Scripts that use this script
                                                    Script Definition
                                                    Script Steps
                                                    • Go to Record/Request/Page [ First ]
                                                    • Loop
                                                    • Set Field [ Colors::FormattedText; "" ]
                                                    • Set Field [ Colors::Image; "" ]
                                                    • Commit Records/Requests [ No dialog ]
                                                    • Go to Record/Request/Page [ Next; Exit after last ]
                                                    • End Loop
                                                    • Go to Record/Request/Page [ First ]
                                                    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 all]
                                                            Script NameTrace
                                                            Run script with full access privilegesOff
                                                            Include In MenuYes
                                                            Layouts that use this script
                                                              Scripts that use this script
                                                                Script Definition
                                                                Script Steps
                                                                • Set Variable [ $r; Value:MBS("Trace") ]
                                                                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: Colors

                                                                              Used functions:




                                                                              Links
                                                                              MBS Xojo Plugins