MBS FileMaker Plugin Example Databases

List ColorSpaces

All examples are included with download of MBS FileMaker Plugin.

List ColorSpaces.fmp12

Overview
Tables2
Relationships0
Layouts2
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
Start
2 fields defined, 1 record
Start
List
17 fields defined, 0 record
List

Fields

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

          Table Name: List - 17 Fields
          Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
          IndexNormal, NumberAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              TypeNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  AlternateNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      ICC Profile SizeNormal, NumberAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                          ICC ProfileNormal, BinaryAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                              NumInComponentsNormal, NumberAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  NumOutComponentsNormal, NumberAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      NumColorsNormal, NumberAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                          ColorantsCountNormal, NumberAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                              ColorantsNormal, TextAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German
                                                  MetadataSizeNormal, NumberAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: German
                                                      MetadataNormal, TextAuto-Enter:
                                                      • Allow editing
                                                      Validation:
                                                      • Only during data entry
                                                      Storage:
                                                      • Repetitions: 1
                                                      • Indexing: None
                                                      • Automatically create indexes as needed
                                                      • Index Language: German
                                                          ModelNormal, TextAuto-Enter:
                                                          • Allow editing
                                                          Validation:
                                                          • Only during data entry
                                                          Storage:
                                                          • Repetitions: 1
                                                          • Indexing: None
                                                          • Automatically create indexes as needed
                                                          • Index Language: German
                                                              ManufacturerNormal, TextAuto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                              • Indexing: None
                                                              • Automatically create indexes as needed
                                                              • Index Language: German
                                                                  CopyrightNormal, TextAuto-Enter:
                                                                  • Allow editing
                                                                  Validation:
                                                                  • Only during data entry
                                                                  Storage:
                                                                  • Repetitions: 1
                                                                  • Indexing: None
                                                                  • Automatically create indexes as needed
                                                                  • Index Language: German
                                                                      DescriptionNormal, TextAuto-Enter:
                                                                      • Allow editing
                                                                      Validation:
                                                                      • Only during data entry
                                                                      Storage:
                                                                      • Repetitions: 1
                                                                      • Indexing: None
                                                                      • Automatically create indexes as needed
                                                                      • Index Language: German
                                                                          NameNormal, TextAuto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: None
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German

                                                                              Layout Objects: Start

                                                                              Regular Fields

                                                                              Field Name: Start::SourcePDF
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 42 pt
                                                                              • Left: 138 pt
                                                                              • Bottom: 167 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
                                                                              No

                                                                              Field Name: Start::NumberOfColorSpaces
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 168 pt
                                                                              • Left: 138 pt
                                                                              • Bottom: 182 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: List Color Spaces
                                                                                Additional Properties:
                                                                              • Change to hand cursor over button
                                                                              • Rectangular
                                                                              • Top: 42 pt
                                                                              • Left: 431 pt
                                                                              • Bottom: 67 pt
                                                                              • Right: 568 pt
                                                                              • Anchoring: Left, Top
                                                                              Perform Script [ “List” ]

                                                                              Scripts:


                                                                              Layout Objects: List

                                                                              Regular Fields

                                                                              Field Name: List::Index
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 37 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 51 pt
                                                                              • Right: 250 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: List::Type
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 55 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 69 pt
                                                                              • Right: 424 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: List::Alternate
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 73 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 87 pt
                                                                              • Right: 424 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: List::ICC Profile Size
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 91 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 105 pt
                                                                              • Right: 250 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: List::ICC Profile
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 109 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 234 pt
                                                                              • Right: 424 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: List::NumInComponents
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 238 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 252 pt
                                                                              • Right: 250 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: List::NumOutComponents
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 256 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 270 pt
                                                                              • Right: 250 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: List::NumColors
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 274 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 288 pt
                                                                              • Right: 250 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: List::ColorantsCount
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 292 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 306 pt
                                                                              • Right: 250 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: List::Colorants
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 310 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 324 pt
                                                                              • Right: 424 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: List::MetadataSize
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 328 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 342 pt
                                                                              • Right: 250 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: List::Metadata
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 346 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 360 pt
                                                                              • Right: 424 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: List::Model
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 364 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 378 pt
                                                                              • Right: 424 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: List::Manufacturer
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 382 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 396 pt
                                                                              • Right: 424 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: List::Copyright
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 400 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 414 pt
                                                                              • Right: 424 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: List::Description
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 418 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 432 pt
                                                                              • Right: 424 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: List::Name
                                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                              • Top: 435 pt
                                                                              • Left: 171 pt
                                                                              • Bottom: 449 pt
                                                                              • Right: 424 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

                                                                              Script Hierarchy

                                                                              List
                                                                              InitDynaPDF
                                                                              Clear

                                                                              Next Script: [InitDynaPDF]
                                                                              Script NameList
                                                                              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: [List]Next Script: [Clear]
                                                                                    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

                                                                                                    Previous Script: [InitDynaPDF]
                                                                                                    Script NameClear
                                                                                                    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 Layout [ “List” (List) ]
                                                                                                        • Delete All Records [ No dialog ]
                                                                                                        • Go to Layout [ “Start” (Start) ]
                                                                                                        • Set Field [ Start::NumberOfColorSpaces; "" ]
                                                                                                        • Commit Records/Requests [ Skip data entry validation; No dialog ]
                                                                                                        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: List ColorSpaces

                                                                                                              Used functions:




                                                                                                              Links
                                                                                                              MBS FileMaker Plugins