MBS FileMaker Plugin Example Databases

Report

All examples are included with download of MBS FileMaker Plugin.

Report.fmp12

Overview
Tables2
Relationships2
Layouts2
Scripts2
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
Result
1 field defined, 1 record
Result
Articles
12 fields defined, 3 records
Articles

Fields

Table Name: Result - 1 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
OutputPDFNormal, BinaryAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1

      Table Name: Articles - 12 Fields
      Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
      IDNormal, NumberAuto-Enter:
      • Allow editing
      • Serial: Generate: On creation, Next value: 8, Increment: 1
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: All
      • Index Language: German
          Position AnzeigeNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              BauteilNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  StatusNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      Material NumberNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                          StreetNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                              CityNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  ResultNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      LocationNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                          CommentNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                              Picture 1Normal, BinaryAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                                  Picture 2Normal, BinaryAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1

                                                      Relationship: Articles=Images

                                                      Table OccurrenceArticlesImages
                                                      FieldID=<Missing Field>
                                                      Source TableArticles<Missing Base Table>
                                                      Source FileReport.fmp12Report.fmp12
                                                      Allow creation of records via this relationshipOffOff
                                                      Delete related records in this table when a record is deleted in the other tableOffOff
                                                      Sort records

                                                      Off

                                                      Off

                                                      Layouts

                                                      Layout Hierarchy

                                                      Result
                                                      Articles


                                                      Layout NameInclude In MenuQuick Find# of ObjectsShow Records FromSave record changes automaticallyShow field frames when record is activeShow field frames only on current recordShow current record indicator in List ViewUsed in ScriptsCustom Menu SetScript TriggersTheme ID
                                                      ResultYesYes ResultOnOnOffOn [File Default]01
                                                      ArticlesYesYes ArticlesOnOnOffOn [File Default]01

                                                      Layout Objects: Result

                                                      Regular Fields

                                                      Field Name: Result::OutputPDF
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 6 pt
                                                      • Left: 138 pt
                                                      • Bottom: 867 pt
                                                      • Right: 850 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: Create Report
                                                        Additional Properties:
                                                      • Change to hand cursor over button
                                                      • Rectangular
                                                      • Top: 39 pt
                                                      • Left: 1 pt
                                                      • Bottom: 64 pt
                                                      • Right: 127 pt
                                                      • Anchoring: Left, Top
                                                      Perform Script [ “Create Table” ]

                                                      Scripts:


                                                      Layout Objects: Articles

                                                      Regular Fields

                                                      Field Name: Articles::ID
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 24 pt
                                                      • Left: 135 pt
                                                      • Bottom: 38 pt
                                                      • Right: 214 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: Articles::Position Anzeige
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 96 pt
                                                      • Left: 140 pt
                                                      • Bottom: 113 pt
                                                      • Right: 393 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: Articles::Bauteil
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 117 pt
                                                      • Left: 140 pt
                                                      • Bottom: 134 pt
                                                      • Right: 393 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: Articles::Status
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 138 pt
                                                      • Left: 140 pt
                                                      • Bottom: 155 pt
                                                      • Right: 393 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: Articles::Material Number
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 159 pt
                                                      • Left: 140 pt
                                                      • Bottom: 176 pt
                                                      • Right: 393 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: Articles::Street
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 180 pt
                                                      • Left: 140 pt
                                                      • Bottom: 197 pt
                                                      • Right: 393 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: Articles::City
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 201 pt
                                                      • Left: 140 pt
                                                      • Bottom: 218 pt
                                                      • Right: 393 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: Articles::Result
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 222 pt
                                                      • Left: 140 pt
                                                      • Bottom: 239 pt
                                                      • Right: 393 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: Articles::Location
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 243 pt
                                                      • Left: 140 pt
                                                      • Bottom: 260 pt
                                                      • Right: 393 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: Articles::Comment
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 264 pt
                                                      • Left: 140 pt
                                                      • Bottom: 281 pt
                                                      • Right: 393 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: Articles::Picture 1
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 84 pt
                                                      • Left: 567 pt
                                                      • Bottom: 209 pt
                                                      • Right: 820 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
                                                      No

                                                      Field Name: Articles::Picture 2
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 213 pt
                                                      • Left: 567 pt
                                                      • Bottom: 338 pt
                                                      • Right: 820 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
                                                      No

                                                      Script Hierarchy

                                                      Create Table
                                                      InitDynaPDF

                                                      Next Script: [InitDynaPDF]
                                                      Script NameCreate Table
                                                      Run script with full access privilegesOff
                                                      Include In MenuYes
                                                      Layouts that use this script
                                                      Scripts that use this script
                                                        Script Definition
                                                        Script Steps
                                                        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 Table]
                                                            Script NameInitDynaPDF
                                                            Run script with full access privilegesOff
                                                            Include In MenuNo
                                                            Layouts that use this script
                                                              Scripts that use this script
                                                              Script Definition
                                                              Script Steps
                                                              • #Locate DynaPDF library
                                                              • Set Variable [ $databasePath; Value:Get(FilePath) ]
                                                              • Set Variable [ $databasePath; Value:MBS("Path.FilemakerPathToNativePath"; $databasePath) ]
                                                              • Set Variable [ $databasePath; Value:Substitute ( $databasePath ; ".fp7" ; ".fmp12") ]
                                                              • Set Variable [ $databaseName; Value:Get(FileName) & ".fmp12" ]
                                                              • If [ Get(SystemPlatform) = -2 ]
                                                              • Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dll" ) ]
                                                              • Else
                                                              • Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dylib" ) ]
                                                              • End If
                                                              • #Initialize DynaPDF
                                                              • Set Variable [ $r; Value:MBS( "DynaPDF.Initialize"; $path) ]
                                                              • If [ $r ≠ "OK" ]
                                                              • Show Custom Dialog [ Title: "DynaPDF failed to initialize"; Message: $r; Default Button: “OK”, Commit: “No”; Button 2: “Abbrechen”, Commit: “No” ]
                                                              • Else
                                                              • Set Variable [ $$DynaPDFInited; Value:1 ]
                                                              • End If
                                                              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: Report

                                                                            Used functions:




                                                                            Links
                                                                            MBS Xojo tutorial videos