MBS FileMaker Plugin Example Databases

Trigger Script On Record Exit

All examples are included with download of MBS FileMaker Plugin.

Trigger Script On Record Exit.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts1
Value Lists0
Custom Functions0
Custom Menus31
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
Script Triggers
3 fields defined, 2 records
Script Triggers

Fields

Table Name: Script Triggers - 3 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
FirstNameNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
  • Context table: Script Triggers
    Calculation: Let( [ x= MBS( "FM.RunScript" ; "Trigger Script On Record Exit.fp7"; "On Record Exit"; "EXIT RECORD" ) ]; 1 /*the "1" is necessary for any edits to be valid*/ ) // make sure the "Validate only if field has been Modified" Check Box is checked
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: English
        LastNameNormal, TextAuto-Enter:
        • Allow editing
        Validation:
        • Only during data entry
        Storage:
        • Repetitions: 1
        • Indexing: None
        • Automatically create indexes as needed
        • Index Language: English
              BirthDayNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: English

                    Layout Objects: Script Triggers

                    Regular Fields

                    Field Name: Script Triggers::FirstName
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 434 pt
                    • Left: 216 pt
                    • Bottom: 451 pt
                    • Right: 469 pt
                    • Anchoring: Left, Top
                    Field Format:
                    • Edit Box
                    Field Behavior:
                    • Allow field to be entered: In Find mode, In Browse mode
                    • Touch keyboard type: System Default
                    • Go to next field using: Tab key
                    Yes

                    Field Name: Script Triggers::LastName
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 452 pt
                    • Left: 216 pt
                    • Bottom: 469 pt
                    • Right: 469 pt
                    • Anchoring: Left, Top
                    Field Format:
                    • Edit Box
                    Field Behavior:
                    • Allow field to be entered: In Find mode, In Browse mode
                    • Touch keyboard type: System Default
                    • Go to next field using: Tab key
                    Yes

                    Field Name: Script Triggers::BirthDay
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 470 pt
                    • Left: 216 pt
                    • Bottom: 487 pt
                    • Right: 361 pt
                    • Anchoring: Left, Top
                    Field Format:
                    • Drop-down Calendar
                    • Include icon to show and hide calendar
                    Field Behavior:
                    • Allow field to be entered: In Find mode, In Browse mode
                    • Touch keyboard type: System Default
                    • Go to next field using: Tab key
                    Yes

                    Group Buttons

                    Button PropertiesCoordinatesScript/Script Step
                      Type:
                    • Text: To See how this works open "Define Fields" and examine the Validation calculation of the field "FirstName".
                      Additional Properties:
                    • Change to hand cursor over button
                    • Rectangular
                    • Top: 521 pt
                    • Left: 65 pt
                    • Bottom: 541 pt
                    • Right: 622 pt
                    • Anchoring: Left, Top
                    Open Manage Database

                    Script Hierarchy

                    On Record Exit

                    Script NameOn Record Exit
                    Run script with full access privilegesOff
                    Include In MenuYes
                    Layouts that use this script
                      Scripts that use this script
                        Script Definition
                        Script Steps
                        • Show Custom Dialog [ Title: "Triggered on Record Exit"; Message: "This is the script parameter: " &Get(ScriptParameter); Default Button: “OK”, Commit: “Yes” ]
                        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: Trigger Script On Record Exit

                                      Used functions:




                                      Links
                                      MBS Xojo Plugins