MBS FileMaker Plugin Example Databases

SQL Select

All examples are included with download of MBS FileMaker Plugin.

SQL Select.fmp12

Overview
Tables2
Relationships0
Layouts8
Scripts0
Value Lists2
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 layoutIntro
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
SQL Select
9 fields defined, 1 record
SQL Select
ZIP_CODES
7 fields defined, 42741 records
ZIP_CODES

Fields

Table Name: SQL Select - 9 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
zipToLookupNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: English
        CityNormal, TextAuto-Enter: Validation:
        • Only during data entry
        Storage:
        • Repetitions: 1
        • Indexing: None
        • Automatically create indexes as needed
        • Index Language: English
              StateNormal, TextAuto-Enter: Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: English
                    CountyNormal, TextAuto-Enter: Validation:
                    • Only during data entry
                    Storage:
                    • Repetitions: 1
                    • Indexing: None
                    • Automatically create indexes as needed
                    • Index Language: English
                          StateToLookUpNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: English
                                Column DelimiterNormal, TextAuto-Enter:
                                • Allow editing
                                Validation:
                                • Only during data entry
                                Storage:
                                • Repetitions: 1
                                • Indexing: None
                                • Automatically create indexes as needed
                                • Index Language: English
                                      Record DelimiterNormal, 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: Validation:
                                            • Only during data entry
                                            Storage:
                                            • Repetitions: 1
                                            • Indexing: None
                                            • Automatically create indexes as needed
                                            • Index Language: English
                                                  Result CopyNormal, TextAuto-Enter: Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: English

                                                        Table Name: ZIP_CODES - 7 Fields
                                                        Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
                                                        zipNormal, TextAuto-Enter:
                                                        • Allow editing
                                                        Validation:
                                                        • Only during data entry
                                                        Storage:
                                                        • Repetitions: 1
                                                        • Indexing: Minimal
                                                        • Automatically create indexes as needed
                                                        • Index Language: English
                                                            latitudeNormal, TextAuto-Enter:
                                                            • Allow editing
                                                            Validation:
                                                            • Only during data entry
                                                            Storage:
                                                            • Repetitions: 1
                                                            • Indexing: None
                                                            • Automatically create indexes as needed
                                                            • Index Language: English
                                                                  longitudeNormal, TextAuto-Enter:
                                                                  • Allow editing
                                                                  Validation:
                                                                  • Only during data entry
                                                                  Storage:
                                                                  • Repetitions: 1
                                                                  • Indexing: None
                                                                  • Automatically create indexes as needed
                                                                  • Index Language: English
                                                                        CityNormal, TextAuto-Enter:
                                                                        • Allow editing
                                                                        Validation:
                                                                        • Only during data entry
                                                                        Storage:
                                                                        • Repetitions: 1
                                                                        • Indexing: None
                                                                        • Automatically create indexes as needed
                                                                        • Index Language: English
                                                                              StateNormal, TextAuto-Enter:
                                                                              • Allow editing
                                                                              Validation:
                                                                              • Only during data entry
                                                                              Storage:
                                                                              • Repetitions: 1
                                                                              • Indexing: Minimal
                                                                              • Automatically create indexes as needed
                                                                              • Index Language: English
                                                                                  CountyNormal, TextAuto-Enter:
                                                                                  • Allow editing
                                                                                  Validation:
                                                                                  • Only during data entry
                                                                                  Storage:
                                                                                  • Repetitions: 1
                                                                                  • Indexing: None
                                                                                  • Automatically create indexes as needed
                                                                                  • Index Language: English
                                                                                        TypeNormal, TextAuto-Enter:
                                                                                        • Allow editing
                                                                                        Validation:
                                                                                        • Only during data entry
                                                                                        Storage:
                                                                                        • Repetitions: 1
                                                                                        • Indexing: None
                                                                                        • Automatically create indexes as needed
                                                                                        • Index Language: English

                                                                                              Layout Objects: Intro

                                                                                              Group Buttons

                                                                                              Button PropertiesCoordinatesScript/Script Step
                                                                                                Type:
                                                                                              • Text: Demo 2
                                                                                                Additional Properties:
                                                                                              • Change to hand cursor over button
                                                                                              • Rectangular
                                                                                              • Top: 263 pt
                                                                                              • Left: 181 pt
                                                                                              • Bottom: 294 pt
                                                                                              • Right: 272 pt
                                                                                              • Anchoring: Left, Top
                                                                                              Go to Layout [ “SQL Select 2” (SQL Select) ]

                                                                                              Layouts:


                                                                                              Button PropertiesCoordinatesScript/Script Step
                                                                                                Type:
                                                                                              • Text: Demo 1
                                                                                                Additional Properties:
                                                                                              • Change to hand cursor over button
                                                                                              • Rectangular
                                                                                              • Top: 263 pt
                                                                                              • Left: 91 pt
                                                                                              • Bottom: 294 pt
                                                                                              • Right: 182 pt
                                                                                              • Anchoring: Left, Top
                                                                                              Go to Layout [ “SQL Select” (SQL Select) ]

                                                                                              Layouts:


                                                                                              Layout Objects: SQL Select

                                                                                              Regular Fields

                                                                                              Field Name: SQL Select::zipToLookup
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 256 pt
                                                                                              • Left: 99 pt
                                                                                              • Bottom: 273 pt
                                                                                              • Right: 178 pt
                                                                                              • Anchoring: Left, Top
                                                                                              Field Format:
                                                                                              • Drop-down List
                                                                                              • Display values from: Zip Codes
                                                                                              • Auto-complete using value list
                                                                                              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: SQL Select::City
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 306 pt
                                                                                              • Left: 93 pt
                                                                                              • Bottom: 323 pt
                                                                                              • Right: 358 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: SQL Select::State
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 324 pt
                                                                                              • Left: 93 pt
                                                                                              • Bottom: 341 pt
                                                                                              • Right: 358 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: SQL Select::County
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 342 pt
                                                                                              • Left: 93 pt
                                                                                              • Bottom: 359 pt
                                                                                              • Right: 358 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

                                                                                              Group Buttons

                                                                                              Button PropertiesCoordinatesScript/Script Step
                                                                                                Type:
                                                                                              • Text: Demo 2
                                                                                                Additional Properties:
                                                                                              • Change to hand cursor over button
                                                                                              • Rectangular
                                                                                              • Top: 4 pt
                                                                                              • Left: 16 pt
                                                                                              • Bottom: 35 pt
                                                                                              • Right: 107 pt
                                                                                              • Anchoring: Left, Top
                                                                                              Go to Layout [ “SQL Select 2” (SQL Select) ]

                                                                                              Layouts:


                                                                                              Layout Objects: SQL Select 2

                                                                                              Regular Fields

                                                                                              Field Name: SQL Select::StateToLookUp
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 229 pt
                                                                                              • Left: 106 pt
                                                                                              • Bottom: 246 pt
                                                                                              • Right: 185 pt
                                                                                              • Anchoring: Left, Top
                                                                                              Field Format:
                                                                                              • Drop-down List
                                                                                              • Display values from: States
                                                                                              • Auto-complete using value list
                                                                                              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: SQL Select::Column Delimiter
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 225 pt
                                                                                              • Left: 328 pt
                                                                                              • Bottom: 242 pt
                                                                                              • Right: 407 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: SQL Select::Record Delimiter
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 249 pt
                                                                                              • Left: 328 pt
                                                                                              • Bottom: 266 pt
                                                                                              • Right: 407 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: SQL Select::Result
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 301 pt
                                                                                              • Left: 12 pt
                                                                                              • Bottom: 660 pt
                                                                                              • Right: 649 pt
                                                                                              • Anchoring: Left, Top
                                                                                              Field Format:
                                                                                              • Edit Box
                                                                                              • Include vertical scrollbar
                                                                                              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: SQL Select::StateToLookUp
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 156 pt
                                                                                              • Left: 240 pt
                                                                                              • Bottom: 173 pt
                                                                                              • Right: 319 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: SQL Select::Result Copy
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 139 pt
                                                                                              • Left: 696 pt
                                                                                              • Bottom: 498 pt
                                                                                              • Right: 1333 pt
                                                                                              • Anchoring: Left, Top
                                                                                              Field Format:
                                                                                              • Edit Box
                                                                                              • Include vertical scrollbar
                                                                                              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

                                                                                              Group Buttons

                                                                                              Button PropertiesCoordinatesScript/Script Step
                                                                                                Type:
                                                                                              • Text: Demo 1
                                                                                                Additional Properties:
                                                                                              • Change to hand cursor over button
                                                                                              • Rectangular
                                                                                              • Top: 2 pt
                                                                                              • Left: 16 pt
                                                                                              • Bottom: 33 pt
                                                                                              • Right: 107 pt
                                                                                              • Anchoring: Left, Top
                                                                                              Go to Layout [ “SQL Select” (SQL Select) ]

                                                                                              Layouts:


                                                                                              Layout Objects: ZIP_CODES

                                                                                              Regular Fields

                                                                                              Field Name: ZIP_CODES::zip
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 24 pt
                                                                                              • Left: 138 pt
                                                                                              • Bottom: 41 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: System Default
                                                                                              • Go to next field using: Tab key
                                                                                              Yes

                                                                                              Field Name: ZIP_CODES::latitude
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 42 pt
                                                                                              • Left: 138 pt
                                                                                              • Bottom: 59 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: System Default
                                                                                              • Go to next field using: Tab key
                                                                                              Yes

                                                                                              Field Name: ZIP_CODES::longitude
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 60 pt
                                                                                              • Left: 138 pt
                                                                                              • Bottom: 77 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: System Default
                                                                                              • Go to next field using: Tab key
                                                                                              Yes

                                                                                              Field Name: ZIP_CODES::City
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 78 pt
                                                                                              • Left: 138 pt
                                                                                              • Bottom: 95 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: System Default
                                                                                              • Go to next field using: Tab key
                                                                                              Yes

                                                                                              Field Name: ZIP_CODES::State
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 96 pt
                                                                                              • Left: 138 pt
                                                                                              • Bottom: 113 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: System Default
                                                                                              • Go to next field using: Tab key
                                                                                              Yes

                                                                                              Field Name: ZIP_CODES::County
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 114 pt
                                                                                              • Left: 138 pt
                                                                                              • Bottom: 131 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: System Default
                                                                                              • Go to next field using: Tab key
                                                                                              Yes

                                                                                              Field Name: ZIP_CODES::Type
                                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                              • Top: 132 pt
                                                                                              • Left: 138 pt
                                                                                              • Bottom: 149 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: System Default
                                                                                              • Go to next field using: Tab key
                                                                                              Yes

                                                                                              Value Lists

                                                                                              Value List NameSourceValuesOn Layouts
                                                                                              Zip CodesField
                                                                                              StatesField

                                                                                              Download example: SQL Select

                                                                                              Used functions:




                                                                                              Links
                                                                                              MBS Xojo blog