MBS FileMaker Plugin Example Databases

QuickList Test

All examples are included with download of MBS FileMaker Plugin.

QuickList Test.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts4
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
QuickList Test
2 fields defined, 1 record
QuickList Test

Fields

Table Name: QuickList Test - 2 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
ListNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      ListSizeNormal, NumberAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German

          Layout Objects: QuickList Test

          Regular Fields

          Field Name: QuickList Test::List
          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
          • Top: 42 pt
          • Left: 12 pt
          • Bottom: 566 pt
          • Right: 331 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: QuickList Test::ListSize
          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
          • Top: 570 pt
          • Left: 138 pt
          • Bottom: 586 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: System Default
          • Go to next field using: Tab key
          Yes

          Group Buttons

          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Build using FileMaker
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 48 pt
          • Left: 340 pt
          • Bottom: 73 pt
          • Right: 506 pt
          • Anchoring: Left, Top
          Perform Script [ “Build using FileMaker” ]

          Scripts:


          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Build using Plugin
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 78 pt
          • Left: 340 pt
          • Bottom: 103 pt
          • Right: 506 pt
          • Anchoring: Left, Top
          Perform Script [ “Build using Plugin” ]

          Scripts:


          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Process using FileMaker
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 126 pt
          • Left: 340 pt
          • Bottom: 151 pt
          • Right: 506 pt
          • Anchoring: Left, Top
          Perform Script [ “Process using FileMaker” ]

          Scripts:


          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Process using Plugin
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 156 pt
          • Left: 340 pt
          • Bottom: 181 pt
          • Right: 506 pt
          • Anchoring: Left, Top
          Perform Script [ “Process using Plugin” ]

          Scripts:


          Script Hierarchy

          Build using FileMaker
          Build using Plugin
          Process using FileMaker
          Process using Plugin

          Next Script: [Build using Plugin]
          Script NameBuild using FileMaker
          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 [ $t1; Value:MBS( "SystemInfo.Time" ) ]
            • Set Variable [ $list; Value:"" ]
            • Set Variable [ $index; Value:0 ]
            • Loop
            • Set Variable [ $list; Value:$list & ("Entry " & $index & ¶) ]
            • Set Variable [ $index; Value:$index + 1 ]
            • Exit Loop If [ $index >= QuickList Test::ListSize ]
            • End Loop
            • Set Variable [ $t2; Value:MBS( "SystemInfo.Time" ) ]
            • Set Field [ QuickList Test::List; $list ]
            • Show Custom Dialog [ Title: "Build List"; Message: ($t2-$t1) & " seconds for " & $index & " entries."; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, 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

                    Previous Script: [Build using FileMaker]Next Script: [Process using FileMaker]
                    Script NameBuild using Plugin
                    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 [ $t1; Value:MBS( "SystemInfo.Time" ) ]
                      • Set Variable [ $listid; Value:MBS("QuickList.New") ]
                      • Set Variable [ $index; Value:0 ]
                      • Loop
                      • Set Variable [ $text; Value:"Entry " & $index ]
                      • Set Variable [ $r; Value:MBS( "QuickList.AddValue"; $listID; $Text ) ]
                      • Set Variable [ $index; Value:$index + 1 ]
                      • Exit Loop If [ $index >= QuickList Test::ListSize ]
                      • End Loop
                      • Set Variable [ $list; Value:MBS("QuickList.GetList"; $listID) ]
                      • Set Variable [ $r; Value:MBS("QuickList.Free"; $listID) ]
                      • Set Variable [ $t2; Value:MBS( "SystemInfo.Time" ) ]
                      • Set Field [ QuickList Test::List; $list ]
                      • Show Custom Dialog [ Title: "Build List"; Message: ($t2-$t1) & " seconds for " & $index & " entries."; Default Button: “OK”, Commit: “No”; Button 2: “Cancel”, 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

                              Previous Script: [Build using Plugin]Next Script: [Process using Plugin]
                              Script NameProcess using FileMaker
                              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 [ $t1; Value:MBS( "SystemInfo.Time" ) ]
                                • # Start
                                • Set Variable [ $list; Value:QuickList Test::List ]
                                • Set Variable [ $length; Value:0 ]
                                • Set Variable [ $index; Value:0 ]
                                • # Count?
                                • Set Variable [ $count; Value:ValueCount ( $list ) ]
                                • # Start of loop
                                • Loop
                                • # Get value and calc length
                                • Set Variable [ $text; Value:GetValue ( $list ; $index ) ]
                                • Set Variable [ $length; Value:$length + Length($text) ]
                                • # Next loop
                                • Set Variable [ $index; Value:$index + 1 ]
                                • Exit Loop If [ $index >= $count ]
                                • End Loop
                                • # And done
                                • Set Variable [ $t2; Value:MBS( "SystemInfo.Time" ) ]
                                • Show Custom Dialog [ Title: "Process List"; Message: "Length of all texts in list: " & $length & ¶ & ($t2-$t1) & " seconds for " & $index & " entries."; Default Button: “OK”, Commit: “No”; Button 2: “Cancel”, 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

                                        Previous Script: [Process using FileMaker]
                                        Script NameProcess using Plugin
                                        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 [ $t1; Value:MBS( "SystemInfo.Time" ) ]
                                          • # Start
                                          • Set Variable [ $listid; Value:MBS("QuickList.New"; QuickList Test::List) ]
                                          • Set Variable [ $length; Value:0 ]
                                          • Set Variable [ $index; Value:0 ]
                                          • # Count?
                                          • Set Variable [ $count; Value:MBS("QuickList.Count"; $listID) ]
                                          • # Start of loop
                                          • Loop
                                          • # Get value and calc length
                                          • Set Variable [ $text; Value:MBS( "QuickList.GetValue"; $listID; $index ) ]
                                          • Set Variable [ $length; Value:$length + Length($text) ]
                                          • # Next loop
                                          • Set Variable [ $index; Value:$index + 1 ]
                                          • Exit Loop If [ $index >= $count ]
                                          • End Loop
                                          • # And done
                                          • Set Variable [ $r; Value:MBS("QuickList.Free"; $listID) ]
                                          • Set Variable [ $t2; Value:MBS( "SystemInfo.Time" ) ]
                                          • Show Custom Dialog [ Title: "Process List"; Message: "Length of all texts in list: " & $length & ¶ & ($t2-$t1) & " seconds for " & $index & " entries."; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, 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: QuickList Test

                                                  Used functions:




                                                  Links
                                                  MBS Xojo Plugins