MBS FileMaker Plugin Example Databases

Merge Fields

All examples are included with download of MBS FileMaker Plugin.

Merge Fields.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts1
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
Merge Fields
4 fields defined, 1 record
Merge Fields

Fields

Table Name: Merge Fields - 4 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
FirstNameNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
        LastNameNormal, TextAuto-Enter:
        • Allow editing
        Validation:
        • Only during data entry
        Storage:
        • Repetitions: 1
        • Indexing: None
        • Automatically create indexes as needed
        • Index Language: German
              InputNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  OutputNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German

                      Layout Objects: Merge Fields

                      Regular Fields

                      Field Name: Merge Fields::FirstName
                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                      • Top: 67 pt
                      • Left: 119 pt
                      • Bottom: 88 pt
                      • Right: 372 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: Merge Fields::LastName
                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                      • Top: 90 pt
                      • Left: 119 pt
                      • Bottom: 111 pt
                      • Right: 372 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: Merge Fields::Input
                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                      • Top: 253 pt
                      • Left: 119 pt
                      • Bottom: 375 pt
                      • Right: 372 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: Merge Fields::Output
                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                      • Top: 382 pt
                      • Left: 119 pt
                      • Bottom: 504 pt
                      • Right: 372 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: Merge Fields
                      • Top: 261 pt
                      • Left: 447 pt
                      • Bottom: 289 pt
                      • Right: 622 pt
                      • Anchoring: Left, Top
                      Perform Script [ “Merge”; Parameter: 0 ]

                      Scripts:


                      Button PropertiesCoordinatesScript/Script Step
                        Type:
                      • Text: Merge Fields for XML
                      • Top: 300 pt
                      • Left: 447 pt
                      • Bottom: 328 pt
                      • Right: 622 pt
                      • Anchoring: Left, Top
                      Perform Script [ “Merge”; Parameter: 16 ]

                      Scripts:


                      Button PropertiesCoordinatesScript/Script Step
                        Type:
                      • Text: Merge Fields for HTML
                      • Top: 339 pt
                      • Left: 447 pt
                      • Bottom: 367 pt
                      • Right: 622 pt
                      • Anchoring: Left, Top
                      Perform Script [ “Merge”; Parameter: 32 ]

                      Scripts:


                      Script Hierarchy

                      Merge

                      Script NameMerge
                      Run script with full access privilegesOff
                      Include In MenuYes
                      Layouts that use this script
                      Scripts that use this script
                        Script Definition
                        Script Steps
                        • Set Variable [ $Message; Value:"Just a test Message with \" and < in text" ]
                        • Set Variable [ $p; Value:Get(ScriptParameter) ]
                        • Set Field [ Merge Fields::Output; MBS("Text.MergeFields"; Merge Fields::Input; 1+ // allow fields 2+ // allow variables 4+ // allow evaluate $p) // 32 for HTML or 16 for XML ]
                        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: Merge Fields

                                Used functions:




                                Links
                                MBS Xojo Plugins