MBS FileMaker Plugin Example Databases

PDF Library

All examples are included with download of MBS FileMaker Plugin.

PDF Library.fmp12

Overview
Tables2
Relationships1
Layouts3
Scripts13
Value Lists0
Custom Functions0
Custom Menus0
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
PDF
12 fields defined, 0 record
PDF
Pages
10 fields defined, 0 record
Pages

Fields

Table Name: PDF - 12 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
PrimaryKeyNormal, TextAuto-Enter:
  • Context table: PDF
    Calculation: Get( UUID )
Validation:
  • Only during data entry
  • Not empty
  • Unique
  • Strict validation
Storage:
  • Repetitions: 1
  • Indexing: Minimal
  • Automatically create indexes as needed
  • Index Language: Unicode Raw
Eindeutige ID für jeden Datensatz in dieser Tabelle
    OriginalNormal, BinaryAuto-Enter:
    • Allow editing
    Validation:
    • Only during data entry
    Storage:
    • Repetitions: 1
        PreviewNormal, BinaryAuto-Enter:
        • Allow editing
        Validation:
        • Only during data entry
        Storage:
        • Repetitions: 1
            TextNormal, BinaryAuto-Enter:
            • Allow editing
            Validation:
            • Only during data entry
            Storage:
            • Repetitions: 1
                SearchFieldNormal, TextAuto-Enter:
                • Allow editing
                Validation:
                • Only during data entry
                Storage:
                • Global
                • Repetitions: 1
                • Index Language: German
                    NameCalculated, TextCalculation: Storage:
                    • Repetitions: 1
                    • Indexing: None
                    • Automatically create indexes as needed
                    • Index Language: German
                          CreationDateNormal, DateAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                              FileSizeNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  SubjectNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      AuthorNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                          KeywordsNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                              PageCountNormal, NumberAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German

                                                  Table Name: Pages - 10 Fields
                                                  Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
                                                  PrimaryKeyNormal, TextAuto-Enter:
                                                  • Context table: Pages
                                                    Calculation: Get( UUID )
                                                  Validation:
                                                  • Only during data entry
                                                  • Not empty
                                                  • Unique
                                                  • Strict validation
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: Minimal
                                                  • Automatically create indexes as needed
                                                  • Index Language: Unicode Raw
                                                  Eindeutige ID für jeden Datensatz in dieser Tabelle
                                                          P_PDFIDNormal, TextAuto-Enter:
                                                          • Allow editing
                                                          Validation:
                                                          • Only during data entry
                                                          Storage:
                                                          • Repetitions: 1
                                                          • Indexing: All
                                                          • Index Language: German
                                                              P_PageOriginalPDFNormal, BinaryAuto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                                    P_PreviewCalculated, BinaryCalculation: Auto-Enter:
                                                                    • Always evaluate
                                                                    Storage:
                                                                    • Repetitions: 1
                                                                          P_PageNumberNormal, NumberAuto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: None
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German
                                                                              P_TextNormal, TextAuto-Enter:
                                                                              • Allow editing
                                                                              Validation:
                                                                              • Only during data entry
                                                                              Storage:
                                                                              • Repetitions: 1
                                                                              • Indexing: All
                                                                              • Index Language: German
                                                                                  P_SearchfieldNormal, TextAuto-Enter:
                                                                                  • Allow editing
                                                                                  Validation:
                                                                                  • Only during data entry
                                                                                  Storage:
                                                                                  • Global
                                                                                  • Repetitions: 1
                                                                                  • Index Language: German
                                                                                      P_HitNormal, TextAuto-Enter:
                                                                                      • Allow editing
                                                                                      Validation:
                                                                                      • Only during data entry
                                                                                      Storage:
                                                                                      • Repetitions: 1
                                                                                      • Indexing: Minimal
                                                                                      • Automatically create indexes as needed
                                                                                      • Index Language: German
                                                                                          P_PDFNormal, BinaryAuto-Enter:
                                                                                          • Allow editing
                                                                                          Validation:
                                                                                          • Only during data entry
                                                                                          Storage:
                                                                                          • Repetitions: 1
                                                                                                  P_PageImageNormal, BinaryAuto-Enter:
                                                                                                  • Allow editing
                                                                                                  Validation:
                                                                                                  • Only during data entry
                                                                                                  Storage:
                                                                                                  • Repetitions: 1

                                                                                                        Layout Objects: PDF

                                                                                                        Regular Fields

                                                                                                        Field Name: PDF::Preview
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 53 pt
                                                                                                        • Left: 13 pt
                                                                                                        • Bottom: 132 pt
                                                                                                        • Right: 81 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: PDF::SearchField
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 11 pt
                                                                                                        • Left: 380 pt
                                                                                                        • Bottom: 40 pt
                                                                                                        • Right: 763 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: PDF::Name
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 56 pt
                                                                                                        • Left: 169 pt
                                                                                                        • Bottom: 77 pt
                                                                                                        • Right: 387 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: PDF::CreationDate
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 82 pt
                                                                                                        • Left: 169 pt
                                                                                                        • Bottom: 103 pt
                                                                                                        • Right: 387 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: PDF::FileSize
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 109 pt
                                                                                                        • Left: 169 pt
                                                                                                        • Bottom: 130 pt
                                                                                                        • Right: 387 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: PDF::Subject
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 56 pt
                                                                                                        • Left: 471 pt
                                                                                                        • Bottom: 77 pt
                                                                                                        • Right: 724 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: PDF::Author
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 82 pt
                                                                                                        • Left: 471 pt
                                                                                                        • Bottom: 103 pt
                                                                                                        • Right: 724 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: PDF::Keywords
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 109 pt
                                                                                                        • Left: 471 pt
                                                                                                        • Bottom: 130 pt
                                                                                                        • Right: 724 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: PDF::PageCount
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 109 pt
                                                                                                        • Left: 812 pt
                                                                                                        • Bottom: 130 pt
                                                                                                        • Right: 891 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

                                                                                                        Buttons

                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                          Type:
                                                                                                        • Text: Import PDF
                                                                                                        • Top: 13 pt
                                                                                                        • Left: 13 pt
                                                                                                        • Bottom: 35 pt
                                                                                                        • Right: 102 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Perform Script [ “Import Dialog” ]

                                                                                                        Scripts:


                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                          Type:
                                                                                                        • Text:
                                                                                                        • Top: 10 pt
                                                                                                        • Left: 778 pt
                                                                                                        • Bottom: 39 pt
                                                                                                        • Right: 859 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Perform Script [ “Documents” ]

                                                                                                        Scripts:


                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                          Type:
                                                                                                        • Text: Quit Searchmode
                                                                                                        • Top: 10 pt
                                                                                                        • Left: 874 pt
                                                                                                        • Bottom: 39 pt
                                                                                                        • Right: 989 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Perform Script [ “Exit Searchmode” ]

                                                                                                        Scripts:


                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                          Type:
                                                                                                        • Text: Open Document
                                                                                                        • Top: 60 pt
                                                                                                        • Left: 874 pt
                                                                                                        • Bottom: 89 pt
                                                                                                        • Right: 989 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Perform Script [ “Select” ]

                                                                                                        Scripts:


                                                                                                        Layout Objects: Pages

                                                                                                        Regular Fields

                                                                                                        Field Name: Pages::P_Preview
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 55 pt
                                                                                                        • Left: 47 pt
                                                                                                        • Bottom: 490 pt
                                                                                                        • Right: 408 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: Pages::P_PageNumber
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 57 pt
                                                                                                        • Left: 933 pt
                                                                                                        • Bottom: 78 pt
                                                                                                        • Right: 989 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: Pages::P_Text
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 55 pt
                                                                                                        • Left: 438 pt
                                                                                                        • Bottom: 490 pt
                                                                                                        • Right: 824 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: Pages::P_Searchfield
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 15 pt
                                                                                                        • Left: 458 pt
                                                                                                        • Bottom: 42 pt
                                                                                                        • Right: 781 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: Pages::P_Hit
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 79 pt
                                                                                                        • Left: 933 pt
                                                                                                        • Bottom: 100 pt
                                                                                                        • Right: 989 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

                                                                                                        Buttons

                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                          Type:
                                                                                                        • Text:
                                                                                                        • Top: 7 pt
                                                                                                        • Left: 824 pt
                                                                                                        • Bottom: 42 pt
                                                                                                        • Right: 862 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Perform Script [ “SearchButtonLayoutPages” ]

                                                                                                        Scripts:


                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                          Type:
                                                                                                        • Text: Back
                                                                                                        • Top: 505 pt
                                                                                                        • Left: 47 pt
                                                                                                        • Bottom: 527 pt
                                                                                                        • Right: 130 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Perform Script [ “Go Back” ]

                                                                                                        Scripts:


                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                          Type:
                                                                                                        • Text: Back
                                                                                                        • Top: 13 pt
                                                                                                        • Left: 47 pt
                                                                                                        • Bottom: 35 pt
                                                                                                        • Right: 130 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Perform Script [ “Go Back” ]

                                                                                                        Scripts:


                                                                                                        Layout Objects: import

                                                                                                        Regular Fields

                                                                                                        Field Name: PDF::PrimaryKey
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 64 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 85 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        Yes

                                                                                                        Field Name: PDF::Original
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 87 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 212 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        No

                                                                                                        Field Name: PDF::Preview
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 214 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 339 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        No

                                                                                                        Field Name: PDF::Text
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 341 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 466 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        No

                                                                                                        Field Name: PDF::SearchField
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 468 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 489 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        No

                                                                                                        Field Name: PDF::Name
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 491 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 512 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        Yes

                                                                                                        Field Name: PDF::CreationDate
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 514 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 535 pt
                                                                                                        • Right: 265 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: PDF::FileSize
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 537 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 558 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        Yes

                                                                                                        Field Name: PDF::Subject
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 560 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 581 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        Yes

                                                                                                        Field Name: PDF::Author
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 583 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 604 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        Yes

                                                                                                        Field Name: PDF::Keywords
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 606 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 627 pt
                                                                                                        • Right: 397 pt
                                                                                                        • Anchoring: Left, Top
                                                                                                        Field Format:
                                                                                                        • Edit Box
                                                                                                        Field Behavior:
                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                        • Go to next field using: Tab key
                                                                                                        Yes

                                                                                                        Field Name: PDF::PageCount
                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                        • Top: 629 pt
                                                                                                        • Left: 144 pt
                                                                                                        • Bottom: 650 pt
                                                                                                        • Right: 223 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

                                                                                                        InitDynaPDF
                                                                                                        Import Dialog
                                                                                                        Import
                                                                                                        Analyze PDF
                                                                                                        Split Pages
                                                                                                        Select
                                                                                                        Search Pages
                                                                                                        Go Back
                                                                                                        Documents
                                                                                                        Exit Searchmode
                                                                                                        SearchReturn
                                                                                                        SearchButtonLayoutPages
                                                                                                        Clear All

                                                                                                        Next Script: [Import Dialog]
                                                                                                        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
                                                                                                          • #initialized Dyna PDF
                                                                                                          • #Locate DynaPDF library
                                                                                                          • #you can have libraries in container and export at runtime to folder of your choice.
                                                                                                          • #Or install library somewhere and pass path.
                                                                                                          • #If library is in same folder as plugin, you can only pass only file name.
                                                                                                          • If [ MBS("IsServer") ]
                                                                                                          • #Put the path you use for your server here:
                                                                                                          • If [ Get(SystemPlatform) = -2 ]
                                                                                                          • #Server on Windows
                                                                                                          • Set Variable [ $path; Value:"C:\Programs\FileMaker Server\dynapdf64.dll" ]
                                                                                                          • Else If [ MBS("IsLinux") ]
                                                                                                          • #Server on Linux for FileMaker Cloud
                                                                                                          • Set Variable [ $path; Value:"/opt/FileMaker/FileMaker Server/dynapdf.linux.so" ]
                                                                                                          • Else
                                                                                                          • #Server on Mac
                                                                                                          • Set Variable [ $path; Value: "/Library/FileMaker Server/dynapdf.dylib" ]
                                                                                                          • End If
                                                                                                          • Else
                                                                                                          • #For desktop and our examples we look in same folder as database:
                                                                                                          • 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" ) ]
                                                                                                          • #plugin will look for dynapdf.dll and if not found also for dynapdf64.dll (64-bit) and dynapdf32.dll (32-bit).
                                                                                                          • Else
                                                                                                          • Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dylib" ) ]
                                                                                                          • #Mac dylib is usually 32 and 64 bit together.
                                                                                                          • End If
                                                                                                          • End If
                                                                                                          • #You can test for free.
                                                                                                          • #If you like to get a dynapdf license, please follow links on our pricing page:
                                                                                                          • #https://www.monkeybreadsoftware.de/filemaker/pricing.shtml
                                                                                                          • Set Variable [ $LicenseKey; Value:// put your own license key here: "" ]
                                                                                                          • Set Variable [ $r; Value:MBS( "DynaPDF.Initialize"; $path; $LicenseKey) ]
                                                                                                          • If [ $r ≠ "OK" ]
                                                                                                          • Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “No”; Button 2: “Cancel”, Commit: “No” ]
                                                                                                          • Halt Script
                                                                                                          • End If
                                                                                                          • Set Variable [ $r; Value:MBS( "Plugin.SetPreviewSize"; 1200 ) ]
                                                                                                          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]Next Script: [Import]
                                                                                                                        Script NameImport Dialog
                                                                                                                        Run script with full access privilegesOff
                                                                                                                        Include In MenuYes
                                                                                                                        Layouts that use this script
                                                                                                                        Scripts that use this script
                                                                                                                          Script Definition
                                                                                                                          Script Steps
                                                                                                                          • #Import (Script from button Import PDF)
                                                                                                                          • Set Variable [ $r; Value:MBS( "FileDialog.Reset") ]
                                                                                                                          • Set Variable [ $r; Value:MBS( "FileDialog.SetAllowMulti"; 1 ) ]
                                                                                                                          • Set Variable [ $r; Value:MBS( "FileDialog.OpenFileDialog" ) ]
                                                                                                                          • Set Variable [ $index; Value:0 ]
                                                                                                                          • Set Variable [ $count; Value:MBS("FileDialog.GetPathCount") ]
                                                                                                                          • Loop
                                                                                                                          • Exit Loop If [ $count-1 < $index ]
                                                                                                                          • Set Variable [ $file; Value:MBS("FileDialog.GetPath"; $index) ]
                                                                                                                          • If [ MBS("IsError") = 0 ]
                                                                                                                          • Perform Script [ “Import”; Parameter: $file ]
                                                                                                                          • End If
                                                                                                                          • Set Variable [ $index; Value:$index+1 ]
                                                                                                                          • End Loop
                                                                                                                          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: [Import Dialog]Next Script: [Analyze PDF]
                                                                                                                                      Script NameImport
                                                                                                                                      Run script with full access privilegesOff
                                                                                                                                      Include In MenuNo
                                                                                                                                      Layouts that use this script
                                                                                                                                        Scripts that use this script
                                                                                                                                        Script Definition
                                                                                                                                        Script Steps
                                                                                                                                        • #Import one file
                                                                                                                                        • Set Variable [ $file; Value:Get(ScriptParameter) ]
                                                                                                                                        • Set Variable [ $PDF; Value:MBS( "Container.ReadFile"; $file; "auto") ]
                                                                                                                                        • If [ MBS("IsError") = 0 ]
                                                                                                                                        • Go to Layout [ “import” (PDF) ]
                                                                                                                                        • New Record/Request
                                                                                                                                        • Set Field [ PDF::CreationDate; MBS( "Files.CreationDate"; $file ) ]
                                                                                                                                        • Set Field [ PDF::FileSize; MBS( "Files.FileSize"; $file) ]
                                                                                                                                        • Set Field [ PDF::Original; $PDF ]
                                                                                                                                        • Commit Records/Requests [ No dialog ]
                                                                                                                                        • Perform Script [ “Analyze PDF” ]
                                                                                                                                        • Go to Layout [ original layout ]
                                                                                                                                        • 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: [Import]Next Script: [Split Pages]
                                                                                                                                            Script NameAnalyze PDF
                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                            Include In MenuNo
                                                                                                                                            Layouts that use this script
                                                                                                                                              Scripts that use this script
                                                                                                                                              Script Definition
                                                                                                                                              Script Steps
                                                                                                                                              • #Script is called for each new imported Document, it calles the script for the preview, the text for text extraction and the page split
                                                                                                                                              • If [ MBS("DynaPDF.IsInitialized") ≠ 1 ]
                                                                                                                                              • Perform Script [ “InitDynaPDF” ]
                                                                                                                                              • End If
                                                                                                                                              • If [ MBS("DynaPDF.IsInitialized") ≠ 1 ]
                                                                                                                                              • Exit Script [ Result: "Failed to initialize DynaPDF." ]
                                                                                                                                              • End If
                                                                                                                                              • Set Variable [ $pdf; Value:MBS("DynaPDF.New") ]
                                                                                                                                              • #Set some flags for import
                                                                                                                                              • Set Variable [ $r; Value:MBS("DynaPDF.SetImportFlags"; $pdf; "ImportAll ImportAsPage") ]
                                                                                                                                              • #Add first page
                                                                                                                                              • Set Variable [ $r; Value:MBS("DynaPDF.OpenPDFFromContainer"; $pdf; PDF::Original) ]
                                                                                                                                              • If [ MBS("IsError") ]
                                                                                                                                              • Exit Script [ Result: "Failed to open PDF" ]
                                                                                                                                              • End If
                                                                                                                                              • #Extract the text from the PDF
                                                                                                                                              • Set Variable [ $r; Value:MBS("DynaPDF.ImportPDFFile"; $pdf) ]
                                                                                                                                              • If [ MBS("IsError") ]
                                                                                                                                              • Exit Script [ Result: "Failed to import PDF pages" ]
                                                                                                                                              • End If
                                                                                                                                              • #metadata
                                                                                                                                              • Set Field [ PDF::Author; MBS( "DynaPDF.GetDocInfo"; $pdf; "Author" ) ]
                                                                                                                                              • Set Field [ PDF::Subject; MBS( "DynaPDF.GetDocInfo"; $pdf; "Subject" ) ]
                                                                                                                                              • Set Field [ PDF::Keywords; MBS( "DynaPDF.GetDocInfo"; $pdf; "Keywords" ) ]
                                                                                                                                              • #get text for whole document
                                                                                                                                              • Set Variable [ $text; Value:MBS("DynaPDF.ExtractDocumentText"; $pdf) ]
                                                                                                                                              • If [ MBS("IsError")=0 ]
                                                                                                                                              • Set Field [ PDF::Text; $text ]
                                                                                                                                              • Else
                                                                                                                                              • Set Variable [ $$Error; Value:1 ]
                                                                                                                                              • End If
                                                                                                                                              • #check page count
                                                                                                                                              • Set Variable [ $PageCount; Value:MBS("DynaPDF.GetPageCount"; $pdf ) ]
                                                                                                                                              • Set Field [ PDF::PageCount; $PageCount ]
                                                                                                                                              • ##preview first page
                                                                                                                                              • Set Variable [ $Picture; Value:MBS( "DynaPDF.RenderPage"; $PDF; 1 ) ]
                                                                                                                                              • Set Field [ PDF::Preview; $Picture ]
                                                                                                                                              • Set Variable [ $r; Value:MBS("DynaPDF.Release";$pdf) ]
                                                                                                                                              • Perform Script [ “Split Pages” ]
                                                                                                                                              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: [Analyze PDF]Next Script: [Select]
                                                                                                                                                    Script NameSplit Pages
                                                                                                                                                    Run script with full access privilegesOff
                                                                                                                                                    Include In MenuNo
                                                                                                                                                    Layouts that use this script
                                                                                                                                                      Scripts that use this script
                                                                                                                                                      Script Definition
                                                                                                                                                      Script Steps
                                                                                                                                                      • #Split the Document in different pages and save each page as record in the Table Pages as refenence set (Relation ID)
                                                                                                                                                      • #Initialize DynaPDF if needed
                                                                                                                                                      • If [ MBS("DynaPDF.IsInitialized") ≠ 1 ]
                                                                                                                                                      • Perform Script [ “InitDynaPDF” ]
                                                                                                                                                      • End If
                                                                                                                                                      • If [ MBS("DynaPDF.IsInitialized") ≠ 1 ]
                                                                                                                                                      • Exit Script [ Result: "Failed to initialize DynaPDF." ]
                                                                                                                                                      • End If
                                                                                                                                                      • Set Variable [ $ID; Value:PDF::PrimaryKey ]
                                                                                                                                                      • Set Variable [ $Original; Value:PDF::Original ]
                                                                                                                                                      • #Clear current PDF document
                                                                                                                                                      • Set Variable [ $pdf; Value:MBS("DynaPDF.New") ]
                                                                                                                                                      • #Query page count
                                                                                                                                                      • Set Variable [ $destPage; Value:1 ]
                                                                                                                                                      • Set Variable [ $page; Value:0 ]
                                                                                                                                                      • Set Variable [ $openResult; Value:MBS("DynaPDF.OpenPDFFromContainer"; $pdf; $Original) ]
                                                                                                                                                      • Set Variable [ $pageCount; Value:MBS("DynaPDF.GetImportPageCount"; $pdf ) ]
                                                                                                                                                      • Set Variable [ $r; Value:MBS("DynaPDF.Release"; $pdf) ]
                                                                                                                                                      • If [ $openResult ≠ 0 ]
                                                                                                                                                      • Exit Script [ ]
                                                                                                                                                      • End If
                                                                                                                                                      • #Loop over pages and save each in as an new record
                                                                                                                                                      • If [ $pageCount > 0 ]
                                                                                                                                                      • Loop
                                                                                                                                                      • Go to Layout [ “Pages” (Pages) ]
                                                                                                                                                      • New Record/Request
                                                                                                                                                      • Set Variable [ $page; Value:$page + 1 ]
                                                                                                                                                      • Set Variable [ $pdf; Value:MBS("DynaPDF.New") ]
                                                                                                                                                      • Set Variable [ $openResult; Value:MBS("DynaPDF.OpenPDFFromContainer"; $pdf; $Original) ]
                                                                                                                                                      • Set Variable [ $r; Value:MBS("DynaPDF.ImportPDFPage"; $pdf; $page) ]
                                                                                                                                                      • #Extract text
                                                                                                                                                      • Set Variable [ $text; Value:MBS("DynaPDF.ExtractText"; $pdf; 1) ]
                                                                                                                                                      • If [ MBS("IsError") = 0 ]
                                                                                                                                                      • Set Field [ Pages::P_Text; $text ]
                                                                                                                                                      • End If
                                                                                                                                                      • #Preview
                                                                                                                                                      • Set Variable [ $Picture; Value:MBS( "DynaPDF.RenderPage"; $PDF; 1 ) ]
                                                                                                                                                      • If [ MBS("IsError") = 0 ]
                                                                                                                                                      • Set Field [ Pages::P_PageImage; $Picture ]
                                                                                                                                                      • End If
                                                                                                                                                      • #PDF
                                                                                                                                                      • Set Field [ Pages::P_PageOriginalPDF; MBS( "DynaPDF.Save"; $PDF; "page" & $page & ".pdf" ) ]
                                                                                                                                                      • Set Field [ Pages::P_PDFID; $ID ]
                                                                                                                                                      • Set Field [ Pages::P_PageNumber; $page ]
                                                                                                                                                      • Commit Records/Requests [ Skip data entry validation; No dialog ]
                                                                                                                                                      • Set Variable [ $r; Value:MBS("DynaPDF.Release"; $pdf) ]
                                                                                                                                                      • Go to Layout [ “PDF” (PDF) ]
                                                                                                                                                      • Exit Loop If [ $page = $pageCount ]
                                                                                                                                                      • End Loop
                                                                                                                                                      • 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: [Split Pages]Next Script: [Search Pages]
                                                                                                                                                          Script NameSelect
                                                                                                                                                          Run script with full access privilegesOff
                                                                                                                                                          Include In MenuNo
                                                                                                                                                          Layouts that use this script
                                                                                                                                                          Scripts that use this script
                                                                                                                                                            Script Definition
                                                                                                                                                            Script Steps
                                                                                                                                                            • #Search the relate pages and start the highlighting script
                                                                                                                                                            • Go to Layout [ “PDF” (PDF) ]
                                                                                                                                                            • Set Variable [ $Search; Value:PDF::SearchField ]
                                                                                                                                                            • Go to Related Record [ From table: “Pages”; Using layout: “Pages” (Pages) ] [ Show only related records ]
                                                                                                                                                            • If [ $Search ≠ "" ]
                                                                                                                                                            • Set Field [ Pages::P_Searchfield; $Search ]
                                                                                                                                                            • Enter Find Mode [ ]
                                                                                                                                                            • Set Field [ Pages::P_Text; "*" & $Search & "*" ]
                                                                                                                                                            • Constrain Found Set [ ]
                                                                                                                                                            • Enter Browse Mode
                                                                                                                                                            • Perform Script [ “Search Pages” ]
                                                                                                                                                            • Go to Record/Request/Page [ First ]
                                                                                                                                                            • Else
                                                                                                                                                            • #Make sure you see the page pictures without highlights
                                                                                                                                                            • Go to Record/Request/Page [ First ]
                                                                                                                                                            • Loop
                                                                                                                                                            • Set Variable [ $$PageHighlight[Pages::P_PageNumber]; Value:"" ]
                                                                                                                                                            • Go to Record/Request/Page [ Next; Exit after last ]
                                                                                                                                                            • End Loop
                                                                                                                                                            • Go to Record/Request/Page [ First ]
                                                                                                                                                            • 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: [Select]Next Script: [Go Back]
                                                                                                                                                                Script NameSearch Pages
                                                                                                                                                                Run script with full access privilegesOff
                                                                                                                                                                Include In MenuNo
                                                                                                                                                                Layouts that use this script
                                                                                                                                                                  Scripts that use this script
                                                                                                                                                                  Script Definition
                                                                                                                                                                  Script Steps
                                                                                                                                                                  • Set Variable [ $r; Value:MBS("Trace") ]
                                                                                                                                                                  • Go to Record/Request/Page [ First ]
                                                                                                                                                                  • Loop
                                                                                                                                                                  • #Initialize DynaPDF if needed
                                                                                                                                                                  • If [ MBS("DynaPDF.IsInitialized") ≠ 1 ]
                                                                                                                                                                  • Perform Script [ “InitDynaPDF” ]
                                                                                                                                                                  • End If
                                                                                                                                                                  • Set Variable [ $Hit1; Value:0 ]
                                                                                                                                                                  • Set Variable [ $Hit2; Value:0 ]
                                                                                                                                                                  • #Clear current PDF document
                                                                                                                                                                  • Set Variable [ $pdf; Value:MBS("DynaPDF.New") ]
                                                                                                                                                                  • #Load PDF from container
                                                                                                                                                                  • Set Variable [ $r; Value:MBS("DynaPDF.OpenPDFFromContainer"; $pdf;Pages::P_PageOriginalPDF) ]
                                                                                                                                                                  • #import a page
                                                                                                                                                                  • Set Variable [ $r; Value:MBS("DynaPDF.ImportPDFFile"; $pdf) ]
                                                                                                                                                                  • Set Variable [ $r; Value:MBS("DynaPDF.EditPage"; $pdf; 1) ]
                                                                                                                                                                  • Set Variable [ $r; Value:MBS( "DynaPDF.SetFont"; $pdf; "Arial"; 0; 12; 1; "unicode" ) ]
                                                                                                                                                                  • #highlight in the first stepp to example "John" and then "john"
                                                                                                                                                                  • Set Variable [ $Hit1; Value:MBS("DynaPDF.HighlightPattern"; $pdf; Pages::P_Searchfield) ]
                                                                                                                                                                  • Set Variable [ $Hit2; Value:MBS("DynaPDF.HighlightPattern"; $pdf; Lower (Pages::P_Searchfield)) ]
                                                                                                                                                                  • If [ MBS("IsError") ]
                                                                                                                                                                  • Set Field [ Pages::P_Hit; 0 ]
                                                                                                                                                                  • End If
                                                                                                                                                                  • Set Variable [ $r; Value:MBS("DynaPDF.EndPage"; $pdf) ]
                                                                                                                                                                  • Set Variable [ $pdf; Value:MBS( "DynaPDF.RenderPage"; $pdf; 1) ]
                                                                                                                                                                  • Set Variable [ $$PageHighlight[Pages::P_PageNumber]; Value:$pdf ]
                                                                                                                                                                  • Set Field [ Pages::P_Hit; $Hit1+$Hit2 ]
                                                                                                                                                                  • #Cleanup
                                                                                                                                                                  • Set Variable [ $r; Value:MBS("DynaPDF.Release"; $pdf) ]
                                                                                                                                                                  • Go to Record/Request/Page [ Next; Exit after last ]
                                                                                                                                                                  • End Loop
                                                                                                                                                                  • Go to Record/Request/Page [ First ]
                                                                                                                                                                  • Refresh Window
                                                                                                                                                                  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: [Search Pages]Next Script: [Documents]
                                                                                                                                                                        Script NameGo Back
                                                                                                                                                                        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 Related Record [ From table: “PDF”; Using layout: “PDF” (PDF) ]
                                                                                                                                                                          • If [ Get(LastError) = 101 ]
                                                                                                                                                                          • #no related record, so just go back to layout
                                                                                                                                                                          • Go to Layout [ “PDF” (PDF) ]
                                                                                                                                                                          • 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: [Go Back]Next Script: [Exit Searchmode]
                                                                                                                                                                                    Script NameDocuments
                                                                                                                                                                                    Run script with full access privilegesOff
                                                                                                                                                                                    Include In MenuNo
                                                                                                                                                                                    Layouts that use this script
                                                                                                                                                                                    Scripts that use this script
                                                                                                                                                                                    Script Definition
                                                                                                                                                                                    Script Steps
                                                                                                                                                                                    • #Search in the documents (Layout Pages)
                                                                                                                                                                                    • Show All Records
                                                                                                                                                                                    • Enter Find Mode [ ]
                                                                                                                                                                                    • Set Field [ Pages::P_Text; "*" & PDF::SearchField & "*" ]
                                                                                                                                                                                    • Constrain Found Set [ ]
                                                                                                                                                                                    • Enter Browse Mode
                                                                                                                                                                                    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: [Documents]Next Script: [SearchReturn]
                                                                                                                                                                                            Script NameExit Searchmode
                                                                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                                                                            Include In MenuNo
                                                                                                                                                                                            Layouts that use this script
                                                                                                                                                                                            Scripts that use this script
                                                                                                                                                                                              Script Definition
                                                                                                                                                                                              Script Steps
                                                                                                                                                                                              • #Quit the Searchmode
                                                                                                                                                                                              • Show All Records
                                                                                                                                                                                              • Set Field [ PDF::SearchField; "" ]
                                                                                                                                                                                              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: [Exit Searchmode]Next Script: [SearchButtonLayoutPages]
                                                                                                                                                                                                      Script NameSearchReturn
                                                                                                                                                                                                      Run script with full access privilegesOff
                                                                                                                                                                                                      Include In MenuNo
                                                                                                                                                                                                      Layouts that use this script
                                                                                                                                                                                                        Scripts that use this script
                                                                                                                                                                                                          Script Definition
                                                                                                                                                                                                          Script Steps
                                                                                                                                                                                                          • Set Variable [ $key; Value:Get ( TriggerKeystroke ) ]
                                                                                                                                                                                                          • If [ Code ( $key ) = 13 or Code($key) = 10 ]
                                                                                                                                                                                                          • If [ Get(LayoutName) = "PDF" ]
                                                                                                                                                                                                          • Perform Script [ “Documents” ]
                                                                                                                                                                                                          • Else If [ Get(LayoutName) = "Pages" ]
                                                                                                                                                                                                          • Perform Script [ “SearchButtonLayoutPages” ]
                                                                                                                                                                                                          • End If
                                                                                                                                                                                                          • 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: [SearchReturn]Next Script: [Clear All]
                                                                                                                                                                                                                      Script NameSearchButtonLayoutPages
                                                                                                                                                                                                                      Run script with full access privilegesOff
                                                                                                                                                                                                                      Include In MenuNo
                                                                                                                                                                                                                      Layouts that use this script
                                                                                                                                                                                                                      Scripts that use this script
                                                                                                                                                                                                                      Script Definition
                                                                                                                                                                                                                      Script Steps
                                                                                                                                                                                                                      • #Search Button Layout Pages
                                                                                                                                                                                                                      • Set Variable [ $ID; Value:Pages::P_PDFID ]
                                                                                                                                                                                                                      • Show All Records
                                                                                                                                                                                                                      • Enter Find Mode [ ]
                                                                                                                                                                                                                      • Set Field [ Pages::P_PDFID; $ID ]
                                                                                                                                                                                                                      • Set Field [ Pages::P_Text; "*" & Pages::P_Searchfield & "*" ]
                                                                                                                                                                                                                      • Constrain Found Set [ ]
                                                                                                                                                                                                                      • Enter Browse Mode
                                                                                                                                                                                                                      • Perform Script [ “Search Pages” ]
                                                                                                                                                                                                                      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: [SearchButtonLayoutPages]
                                                                                                                                                                                                                            Script NameClear All
                                                                                                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                                                                                                            Include In MenuYes
                                                                                                                                                                                                                            Layouts that use this script
                                                                                                                                                                                                                              Scripts that use this script
                                                                                                                                                                                                                                Script Definition
                                                                                                                                                                                                                                Script Steps
                                                                                                                                                                                                                                • Truncate Table [ No dialog; Table: “PDF” ]
                                                                                                                                                                                                                                • Truncate Table [ No dialog; Table: “Pages” ]
                                                                                                                                                                                                                                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: PDF Library

                                                                                                                                                                                                                                              Used functions:




                                                                                                                                                                                                                                              Links
                                                                                                                                                                                                                                              MBS FileMaker tutorial videos