MBS FileMaker Plugin Example Databases

Custom Functions to Log Scriptcalls

All examples are included with download of MBS FileMaker Plugin.

Custom Functions to Log Scriptcalls.fmp12

Overview
Tables3
Relationships2
Layouts3
Scripts7
Value Lists0
Custom Functions3
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
TestTable
5 fields defined, 1 record
TestTable
ScriptCallLog
18 fields defined, 12 records
ScriptCallLog
ScriptCallCounter
7 fields defined, 3 records
ScriptCallCounter

Fields

Table Name: TestTable - 5 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
PrimaryKeyNormal, TextAuto-Enter:
  • Context table: TestTable
    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
Unique identifier of each record in this table
        CreationTimestampNormal, TimestampAuto-Enter:
        • Creation timestamp
        Validation:
        • Only during data entry
        • Strict data type: 4 digit year
        • Not empty
        • Strict validation
        Storage:
        • Repetitions: 1
        • Indexing: None
        • Automatically create indexes as needed
        • Index Language: German
        Date and time each record was created
                CreatedByNormal, TextAuto-Enter:
                • Creation account name
                Validation:
                • Only during data entry
                • Not empty
                • Strict validation
                Storage:
                • Repetitions: 1
                • Indexing: None
                • Automatically create indexes as needed
                • Index Language: German
                Account name of the user who created each record
                        ModificationTimestampNormal, TimestampAuto-Enter:
                        • Modification timestamp
                        Validation:
                        • Only during data entry
                        • Strict data type: 4 digit year
                        • Not empty
                        • Strict validation
                        Storage:
                        • Repetitions: 1
                        • Indexing: None
                        • Automatically create indexes as needed
                        • Index Language: German
                        Date and time each record was last modified
                                ModifiedByNormal, TextAuto-Enter:
                                • Modification account name
                                Validation:
                                • Only during data entry
                                • Not empty
                                • Strict validation
                                Storage:
                                • Repetitions: 1
                                • Indexing: None
                                • Automatically create indexes as needed
                                • Index Language: German
                                Account name of the user who last modified each record

                                        Table Name: ScriptCallLog - 18 Fields
                                        Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
                                        PrimaryKeyNormal, TextAuto-Enter: Validation:
                                        • Only during data entry
                                        • Not empty
                                        • Unique
                                        • Strict validation
                                        Storage:
                                        • Repetitions: 1
                                        • Indexing: Minimal
                                        • Automatically create indexes as needed
                                        • Index Language: Unicode Raw
                                        Unique identifier of each record in this table
                                              CreationTimestampNormal, TimestampAuto-Enter:
                                              • Creation timestamp
                                              Validation:
                                              • Only during data entry
                                              • Strict data type: 4 digit year
                                              • Not empty
                                              • Strict validation
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German
                                              Date and time each record was created
                                                    CreatedByNormal, TextAuto-Enter:
                                                    • Creation account name
                                                    Validation:
                                                    • Only during data entry
                                                    • Not empty
                                                    • Strict validation
                                                    Storage:
                                                    • Repetitions: 1
                                                    • Indexing: None
                                                    • Automatically create indexes as needed
                                                    • Index Language: German
                                                    Account name of the user who created each record
                                                            ModificationTimestampNormal, TimestampAuto-Enter:
                                                            • Modification timestamp
                                                            Validation:
                                                            • Only during data entry
                                                            • Strict data type: 4 digit year
                                                            • Not empty
                                                            • Strict validation
                                                            Storage:
                                                            • Repetitions: 1
                                                            • Indexing: None
                                                            • Automatically create indexes as needed
                                                            • Index Language: German
                                                            Date and time each record was last modified
                                                                    ModifiedByNormal, TextAuto-Enter:
                                                                    • Modification account name
                                                                    Validation:
                                                                    • Only during data entry
                                                                    • Not empty
                                                                    • Strict validation
                                                                    Storage:
                                                                    • Repetitions: 1
                                                                    • Indexing: None
                                                                    • Automatically create indexes as needed
                                                                    • Index Language: German
                                                                    Account name of the user who last modified each record
                                                                            FileNameNormal, TextAuto-Enter:
                                                                            • Allow editing
                                                                            Validation:
                                                                            • Only during data entry
                                                                            Storage:
                                                                            • Repetitions: 1
                                                                            • Indexing: Minimal
                                                                            • Automatically create indexes as needed
                                                                            • Index Language: German
                                                                                  TableNameNormal, TextAuto-Enter:
                                                                                  • Allow editing
                                                                                  Validation:
                                                                                  • Only during data entry
                                                                                  Storage:
                                                                                  • Repetitions: 1
                                                                                  • Indexing: None
                                                                                  • Automatically create indexes as needed
                                                                                  • Index Language: German
                                                                                        LayoutNameNormal, TextAuto-Enter:
                                                                                        • Allow editing
                                                                                        Validation:
                                                                                        • Only during data entry
                                                                                        Storage:
                                                                                        • Repetitions: 1
                                                                                        • Indexing: None
                                                                                        • Automatically create indexes as needed
                                                                                        • Index Language: German
                                                                                              ScriptNameNormal, TextAuto-Enter:
                                                                                              • Allow editing
                                                                                              Validation:
                                                                                              • Only during data entry
                                                                                              Storage:
                                                                                              • Repetitions: 1
                                                                                              • Indexing: None
                                                                                              • Automatically create indexes as needed
                                                                                              • Index Language: German
                                                                                                    ScriptParameterNormal, TextAuto-Enter:
                                                                                                    • Allow editing
                                                                                                    Validation:
                                                                                                    • Only during data entry
                                                                                                    Storage:
                                                                                                    • Repetitions: 1
                                                                                                    • Indexing: None
                                                                                                    • Automatically create indexes as needed
                                                                                                    • Index Language: German
                                                                                                          ScriptResultNormal, TextAuto-Enter:
                                                                                                          • Allow editing
                                                                                                          Validation:
                                                                                                          • Only during data entry
                                                                                                          Storage:
                                                                                                          • Repetitions: 1
                                                                                                          • Indexing: None
                                                                                                          • Automatically create indexes as needed
                                                                                                          • Index Language: German
                                                                                                                ScriptCallIDNormal, TextAuto-Enter:
                                                                                                                • Allow editing
                                                                                                                Validation:
                                                                                                                • Always Validate
                                                                                                                • Unique
                                                                                                                • Strict validation
                                                                                                                Storage:
                                                                                                                • Repetitions: 1
                                                                                                                • Indexing: Minimal
                                                                                                                • Automatically create indexes as needed
                                                                                                                • Index Language: German
                                                                                                                      AccountNameNormal, TextAuto-Enter:
                                                                                                                      • Allow editing
                                                                                                                      Validation:
                                                                                                                      • Only during data entry
                                                                                                                      Storage:
                                                                                                                      • Repetitions: 1
                                                                                                                      • Indexing: None
                                                                                                                      • Automatically create indexes as needed
                                                                                                                      • Index Language: German
                                                                                                                            UserNameNormal, TextAuto-Enter:
                                                                                                                            • Allow editing
                                                                                                                            Validation:
                                                                                                                            • Only during data entry
                                                                                                                            Storage:
                                                                                                                            • Repetitions: 1
                                                                                                                            • Indexing: None
                                                                                                                            • Automatically create indexes as needed
                                                                                                                            • Index Language: German
                                                                                                                                  IPNormal, TextAuto-Enter:
                                                                                                                                  • Allow editing
                                                                                                                                  Validation:
                                                                                                                                  • Only during data entry
                                                                                                                                  Storage:
                                                                                                                                  • Repetitions: 1
                                                                                                                                  • Indexing: None
                                                                                                                                  • Automatically create indexes as needed
                                                                                                                                  • Index Language: German
                                                                                                                                        CallStackNormal, TextAuto-Enter:
                                                                                                                                        • Allow editing
                                                                                                                                        Validation:
                                                                                                                                        • Only during data entry
                                                                                                                                        Storage:
                                                                                                                                        • Repetitions: 1
                                                                                                                                        • Indexing: None
                                                                                                                                        • Automatically create indexes as needed
                                                                                                                                        • Index Language: German
                                                                                                                                              StartTimeNormal, TimestampAuto-Enter:
                                                                                                                                              • Allow editing
                                                                                                                                              Validation:
                                                                                                                                              • Only during data entry
                                                                                                                                              Storage:
                                                                                                                                              • Repetitions: 1
                                                                                                                                              • Indexing: None
                                                                                                                                              • Automatically create indexes as needed
                                                                                                                                              • Index Language: German
                                                                                                                                                    EndTimeNormal, TimestampAuto-Enter:
                                                                                                                                                    • Allow editing
                                                                                                                                                    Validation:
                                                                                                                                                    • Only during data entry
                                                                                                                                                    Storage:
                                                                                                                                                    • Repetitions: 1
                                                                                                                                                    • Indexing: None
                                                                                                                                                    • Automatically create indexes as needed
                                                                                                                                                    • Index Language: German

                                                                                                                                                          Table Name: ScriptCallCounter - 7 Fields
                                                                                                                                                          Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
                                                                                                                                                          PrimaryKeyNormal, TextAuto-Enter: Validation:
                                                                                                                                                          • Only during data entry
                                                                                                                                                          • Not empty
                                                                                                                                                          • Unique
                                                                                                                                                          • Strict validation
                                                                                                                                                          Storage:
                                                                                                                                                          • Repetitions: 1
                                                                                                                                                          • Indexing: Minimal
                                                                                                                                                          • Automatically create indexes as needed
                                                                                                                                                          • Index Language: Unicode Raw
                                                                                                                                                          Unique identifier of each record in this table
                                                                                                                                                              FileNameNormal, TextAuto-Enter:
                                                                                                                                                              • Allow editing
                                                                                                                                                              Validation:
                                                                                                                                                              • Only during data entry
                                                                                                                                                              Storage:
                                                                                                                                                              • Repetitions: 1
                                                                                                                                                              • Indexing: Minimal
                                                                                                                                                              • Automatically create indexes as needed
                                                                                                                                                              • Index Language: German
                                                                                                                                                                    ScriptNameNormal, TextAuto-Enter:
                                                                                                                                                                    • Allow editing
                                                                                                                                                                    Validation:
                                                                                                                                                                    • Only during data entry
                                                                                                                                                                    Storage:
                                                                                                                                                                    • Repetitions: 1
                                                                                                                                                                    • Indexing: Minimal
                                                                                                                                                                    • Automatically create indexes as needed
                                                                                                                                                                    • Index Language: German
                                                                                                                                                                          KeyNormal, TextAuto-Enter: Validation:
                                                                                                                                                                          • Always Validate
                                                                                                                                                                          • Unique
                                                                                                                                                                          Storage:
                                                                                                                                                                          • Repetitions: 1
                                                                                                                                                                          • Indexing: Minimal
                                                                                                                                                                          • Automatically create indexes as needed
                                                                                                                                                                          • Index Language: German
                                                                                                                                                                                CounterNormal, NumberAuto-Enter:
                                                                                                                                                                                • Allow editing
                                                                                                                                                                                Validation:
                                                                                                                                                                                • Only during data entry
                                                                                                                                                                                Storage:
                                                                                                                                                                                • Repetitions: 1
                                                                                                                                                                                • Indexing: None
                                                                                                                                                                                • Automatically create indexes as needed
                                                                                                                                                                                • Index Language: German
                                                                                                                                                                                      CreationTimestampNormal, TimestampAuto-Enter:
                                                                                                                                                                                      • Creation timestamp
                                                                                                                                                                                      Validation:
                                                                                                                                                                                      • Only during data entry
                                                                                                                                                                                      • Strict data type: 4 digit year
                                                                                                                                                                                      • Not empty
                                                                                                                                                                                      • Strict validation
                                                                                                                                                                                      Storage:
                                                                                                                                                                                      • Repetitions: 1
                                                                                                                                                                                      • Indexing: None
                                                                                                                                                                                      • Automatically create indexes as needed
                                                                                                                                                                                      • Index Language: German
                                                                                                                                                                                      Date and time each record was created
                                                                                                                                                                                            ModificationTimestampNormal, TimestampAuto-Enter:
                                                                                                                                                                                            • Modification timestamp
                                                                                                                                                                                            Validation:
                                                                                                                                                                                            • Only during data entry
                                                                                                                                                                                            • Strict data type: 4 digit year
                                                                                                                                                                                            • Not empty
                                                                                                                                                                                            • Strict validation
                                                                                                                                                                                            Storage:
                                                                                                                                                                                            • Repetitions: 1
                                                                                                                                                                                            • Indexing: None
                                                                                                                                                                                            • Automatically create indexes as needed
                                                                                                                                                                                            • Index Language: German
                                                                                                                                                                                            Date and time each record was last modified

                                                                                                                                                                                                  Relationship: ScriptCallLog!=TestTable

                                                                                                                                                                                                  Table OccurrenceScriptCallLogTestTable
                                                                                                                                                                                                  FieldPrimaryKey!=PrimaryKey
                                                                                                                                                                                                  Source TableScriptCallLogTestTable
                                                                                                                                                                                                  Source FileCustom Functions to Log Scriptcalls.fmp12Custom Functions to Log Scriptcalls.fmp12
                                                                                                                                                                                                  Allow creation of records via this relationshipOffOff
                                                                                                                                                                                                  Delete related records in this table when a record is deleted in the other tableOffOff
                                                                                                                                                                                                  Sort records

                                                                                                                                                                                                  Off

                                                                                                                                                                                                  Off

                                                                                                                                                                                                  Layouts

                                                                                                                                                                                                  Layout Hierarchy

                                                                                                                                                                                                  TestLayout
                                                                                                                                                                                                  ScriptCallLog
                                                                                                                                                                                                  ScriptCallCounter


                                                                                                                                                                                                  Layout NameInclude In MenuQuick Find# of ObjectsShow Records FromSave record changes automaticallyShow field frames when record is activeShow field frames only on current recordShow current record indicator in List ViewUsed in ScriptsCustom Menu SetScript TriggersTheme ID
                                                                                                                                                                                                  TestLayoutYesYes TestTableOnOffOnOff[File Default]01
                                                                                                                                                                                                  ScriptCallLogYesYes ScriptCallLogOnOffOnOn[File Default]01
                                                                                                                                                                                                  ScriptCallCounterYesYes ScriptCallCounterOnOffOnOn[File Default]01

                                                                                                                                                                                                  Layout Objects: TestLayout

                                                                                                                                                                                                  Regular Fields

                                                                                                                                                                                                  Field Name: ScriptCallCounter::FileName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 125 pt
                                                                                                                                                                                                  • Left: 16 pt
                                                                                                                                                                                                  • Bottom: 146 pt
                                                                                                                                                                                                  • Right: 267 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: ScriptCallCounter::ScriptName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 125 pt
                                                                                                                                                                                                  • Left: 269 pt
                                                                                                                                                                                                  • Bottom: 146 pt
                                                                                                                                                                                                  • Right: 520 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: ScriptCallCounter::Counter
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 125 pt
                                                                                                                                                                                                  • Left: 522 pt
                                                                                                                                                                                                  • Bottom: 146 pt
                                                                                                                                                                                                  • Right: 773 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: ScriptCallCounter::CreationTimestamp
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 125 pt
                                                                                                                                                                                                  • Left: 775 pt
                                                                                                                                                                                                  • Bottom: 146 pt
                                                                                                                                                                                                  • Right: 1026 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: ScriptCallCounter::ModificationTimestamp
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 125 pt
                                                                                                                                                                                                  • Left: 1028 pt
                                                                                                                                                                                                  • Bottom: 146 pt
                                                                                                                                                                                                  • Right: 1279 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: ScriptCallLog::FileName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 19 pt
                                                                                                                                                                                                  • Bottom: 303 pt
                                                                                                                                                                                                  • Right: 124 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: ScriptCallLog::TableName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 126 pt
                                                                                                                                                                                                  • Bottom: 276 pt
                                                                                                                                                                                                  • Right: 230 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: ScriptCallLog::LayoutName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 282 pt
                                                                                                                                                                                                  • Left: 126 pt
                                                                                                                                                                                                  • Bottom: 303 pt
                                                                                                                                                                                                  • Right: 231 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: ScriptCallLog::ScriptName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 233 pt
                                                                                                                                                                                                  • Bottom: 303 pt
                                                                                                                                                                                                  • Right: 337 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: ScriptCallLog::ScriptParameter
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 339 pt
                                                                                                                                                                                                  • Bottom: 303 pt
                                                                                                                                                                                                  • Right: 494 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: ScriptCallLog::ScriptResult
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 504 pt
                                                                                                                                                                                                  • Bottom: 303 pt
                                                                                                                                                                                                  • Right: 659 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: ScriptCallLog::AccountName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 282 pt
                                                                                                                                                                                                  • Left: 659 pt
                                                                                                                                                                                                  • Bottom: 303 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
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::UserName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 659 pt
                                                                                                                                                                                                  • Bottom: 276 pt
                                                                                                                                                                                                  • Right: 764 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: ScriptCallLog::IP
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 766 pt
                                                                                                                                                                                                  • Bottom: 306 pt
                                                                                                                                                                                                  • Right: 870 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: ScriptCallLog::CallStack
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 872 pt
                                                                                                                                                                                                  • Bottom: 306 pt
                                                                                                                                                                                                  • Right: 1085 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: ScriptCallLog::StartTime
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 255 pt
                                                                                                                                                                                                  • Left: 1086 pt
                                                                                                                                                                                                  • Bottom: 276 pt
                                                                                                                                                                                                  • Right: 1279 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: ScriptCallLog::EndTime
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 282 pt
                                                                                                                                                                                                  • Left: 1085 pt
                                                                                                                                                                                                  • Bottom: 303 pt
                                                                                                                                                                                                  • Right: 1279 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: Run Test Script
                                                                                                                                                                                                  • Top: 58 pt
                                                                                                                                                                                                  • Left: 10 pt
                                                                                                                                                                                                  • Bottom: 94 pt
                                                                                                                                                                                                  • Right: 174 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Perform Script [ “Test Script”; Parameter: Get(CurrentTime) ]

                                                                                                                                                                                                  Scripts:


                                                                                                                                                                                                  Button PropertiesCoordinatesScript/Script Step
                                                                                                                                                                                                    Type:
                                                                                                                                                                                                  • Text: Open Custom Functions
                                                                                                                                                                                                  • Top: 58 pt
                                                                                                                                                                                                  • Left: 187 pt
                                                                                                                                                                                                  • Bottom: 94 pt
                                                                                                                                                                                                  • Right: 351 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Perform Script [ “Open Custom Functions Dialog” ]

                                                                                                                                                                                                  Scripts:


                                                                                                                                                                                                  Button PropertiesCoordinatesScript/Script Step
                                                                                                                                                                                                    Type:
                                                                                                                                                                                                  • Text: Enable Logging
                                                                                                                                                                                                  • Top: 58 pt
                                                                                                                                                                                                  • Left: 364 pt
                                                                                                                                                                                                  • Bottom: 94 pt
                                                                                                                                                                                                  • Right: 528 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Perform Script [ “Turn Logging on” ]

                                                                                                                                                                                                  Scripts:


                                                                                                                                                                                                  Button PropertiesCoordinatesScript/Script Step
                                                                                                                                                                                                    Type:
                                                                                                                                                                                                  • Text: Disable Logging
                                                                                                                                                                                                  • Top: 58 pt
                                                                                                                                                                                                  • Left: 541 pt
                                                                                                                                                                                                  • Bottom: 94 pt
                                                                                                                                                                                                  • Right: 705 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Perform Script [ “Turn Logging off” ]

                                                                                                                                                                                                  Scripts:


                                                                                                                                                                                                  Portals

                                                                                                                                                                                                  Portal PropertiesCoordinatesFieldsOptions
                                                                                                                                                                                                    Object Name:
                                                                                                                                                                                                  • counters
                                                                                                                                                                                                  • Top: 122 pt
                                                                                                                                                                                                  • Left: 13 pt
                                                                                                                                                                                                  • Bottom: 224 pt
                                                                                                                                                                                                  • Right: 1314 pt
                                                                                                                                                                                                  • Anchoring: Left and Right, Top
                                                                                                                                                                                                  Field Objects
                                                                                                                                                                                                  • Sort records: Off
                                                                                                                                                                                                  • Filter calculation: None
                                                                                                                                                                                                  • Initial Row: 1
                                                                                                                                                                                                  • Number of Rows: 4
                                                                                                                                                                                                  • Show vertical scroll bar

                                                                                                                                                                                                  Portal PropertiesCoordinatesFieldsOptions
                                                                                                                                                                                                    Object Name:
                                                                                                                                                                                                  • calls
                                                                                                                                                                                                  • Top: 252 pt
                                                                                                                                                                                                  • Left: 16 pt
                                                                                                                                                                                                  • Bottom: 519 pt
                                                                                                                                                                                                  • Right: 1314 pt
                                                                                                                                                                                                  • Anchoring: Left and Right, Top and Bottom
                                                                                                                                                                                                  Field Objects
                                                                                                                                                                                                  • Sort records: Off
                                                                                                                                                                                                  • Filter calculation: None
                                                                                                                                                                                                  • Initial Row: 1
                                                                                                                                                                                                  • Number of Rows: 5
                                                                                                                                                                                                  • Show vertical scroll bar

                                                                                                                                                                                                  Layout Objects: ScriptCallLog

                                                                                                                                                                                                  Regular Fields

                                                                                                                                                                                                  Field Name: ScriptCallLog::FileName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 52 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 73 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::TableName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 75 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 96 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::LayoutName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 98 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 119 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::ScriptName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 121 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 142 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::ScriptParameter
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 52 pt
                                                                                                                                                                                                  • Left: 523 pt
                                                                                                                                                                                                  • Bottom: 142 pt
                                                                                                                                                                                                  • Right: 776 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: ScriptCallLog::ScriptResult
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 142 pt
                                                                                                                                                                                                  • Left: 523 pt
                                                                                                                                                                                                  • Bottom: 232 pt
                                                                                                                                                                                                  • Right: 776 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: ScriptCallLog::AccountName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 144 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 165 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::UserName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 167 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 188 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::IP
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 190 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 211 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::CreationTimestamp
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 213 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 234 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallLog::ScriptCallID
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 235 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 256 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Layout Objects: ScriptCallCounter

                                                                                                                                                                                                  Regular Fields

                                                                                                                                                                                                  Field Name: ScriptCallCounter::FileName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 52 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 73 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

                                                                                                                                                                                                  Field Name: ScriptCallCounter::ScriptName
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 75 pt
                                                                                                                                                                                                  • Left: 138 pt
                                                                                                                                                                                                  • Bottom: 96 pt
                                                                                                                                                                                                  • Right: 391 pt
                                                                                                                                                                                                  • Anchoring: Left, Top
                                                                                                                                                                                                  Field Format:
                                                                                                                                                                                                  • Edit Box
                                                                                                                                                                                                  Field Behavior:
                                                                                                                                                                                                  • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                                                                  • Touch keyboard type: Default for Data Type
                                                                                                                                                                                                  • Go to next field using: Tab key
                                                                                                                                                                                                  Yes

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

                                                                                                                                                                                                  Field Name: ScriptCallCounter::Counter
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 146 pt
                                                                                                                                                                                                  • Left: 137 pt
                                                                                                                                                                                                  • Bottom: 167 pt
                                                                                                                                                                                                  • Right: 216 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: ScriptCallCounter::PrimaryKey
                                                                                                                                                                                                  Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                                                                  • Top: 179 pt
                                                                                                                                                                                                  • Left: 137 pt
                                                                                                                                                                                                  • Bottom: 200 pt
                                                                                                                                                                                                  • Right: 390 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

                                                                                                                                                                                                  Test Script
                                                                                                                                                                                                  Some sub script
                                                                                                                                                                                                  Other script
                                                                                                                                                                                                  Open Custom Functions Dialog
                                                                                                                                                                                                  Turn Logging on
                                                                                                                                                                                                  Turn Logging off
                                                                                                                                                                                                  Refresh window

                                                                                                                                                                                                  Next Script: [Some sub script]
                                                                                                                                                                                                  Script NameTest Script
                                                                                                                                                                                                  Run script with full access privilegesOff
                                                                                                                                                                                                  Include In MenuYes
                                                                                                                                                                                                  Layouts that use this script
                                                                                                                                                                                                  Scripts that use this script
                                                                                                                                                                                                    Script Definition
                                                                                                                                                                                                    Script Steps
                                                                                                                                                                                                    • #log call here to this script
                                                                                                                                                                                                    • Set Variable [ $r; Value:CountScriptCall & LogScriptCall ]
                                                                                                                                                                                                    • #do some work
                                                                                                                                                                                                    • Perform Script [ “Some sub script”; Parameter: "Calling subscript..." ]
                                                                                                                                                                                                    • #return and pass through result, but also log it to database
                                                                                                                                                                                                    • Exit Script [ Result: LogScriptResult("OK") ]
                                                                                                                                                                                                    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: [Test Script]Next Script: [Other script]
                                                                                                                                                                                                              Script NameSome sub script
                                                                                                                                                                                                              Run script with full access privilegesOff
                                                                                                                                                                                                              Include In MenuNo
                                                                                                                                                                                                              Layouts that use this script
                                                                                                                                                                                                                Scripts that use this script
                                                                                                                                                                                                                Script Definition
                                                                                                                                                                                                                Script Steps
                                                                                                                                                                                                                • #log call here to this script
                                                                                                                                                                                                                • Set Variable [ $r; Value:CountScriptCall & LogScriptCall ]
                                                                                                                                                                                                                • #do something in sub script
                                                                                                                                                                                                                • #return and pass through result, but also log it to database
                                                                                                                                                                                                                • Exit Script [ Result: LogScriptResult("OK subscript") ]
                                                                                                                                                                                                                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: [Some sub script]Next Script: [Open Custom Functions Dialog]
                                                                                                                                                                                                                            Script NameOther script
                                                                                                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                                                                                                            Include In MenuYes
                                                                                                                                                                                                                            Layouts that use this script
                                                                                                                                                                                                                              Scripts that use this script
                                                                                                                                                                                                                                Script Definition
                                                                                                                                                                                                                                Script Steps
                                                                                                                                                                                                                                • #log call here to this script
                                                                                                                                                                                                                                • Set Variable [ $r; Value:CountScriptCall & LogScriptCall ]
                                                                                                                                                                                                                                • Perform Script [ “Some sub script”; Parameter: "Calling subscript..." ]
                                                                                                                                                                                                                                • Set Variable [ $result; Value:"some result" ]
                                                                                                                                                                                                                                • #return and pass through result, but also log it to database
                                                                                                                                                                                                                                • Exit Script [ Result: LogScriptResult($result) ]
                                                                                                                                                                                                                                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: [Other script]Next Script: [Turn Logging on]
                                                                                                                                                                                                                                          Script NameOpen Custom Functions Dialog
                                                                                                                                                                                                                                          Run script with full access privilegesOff
                                                                                                                                                                                                                                          Include In MenuYes
                                                                                                                                                                                                                                          Layouts that use this script
                                                                                                                                                                                                                                          Scripts that use this script
                                                                                                                                                                                                                                            Script Definition
                                                                                                                                                                                                                                            Script Steps
                                                                                                                                                                                                                                            Fields used in this script
                                                                                                                                                                                                                                              Scripts used in this script
                                                                                                                                                                                                                                                Layouts used in this script
                                                                                                                                                                                                                                                  Tables used in this script
                                                                                                                                                                                                                                                    Table occurrences used by this script
                                                                                                                                                                                                                                                      Custom Functions used by this script
                                                                                                                                                                                                                                                        Custom menu set used by this script

                                                                                                                                                                                                                                                          Previous Script: [Open Custom Functions Dialog]Next Script: [Turn Logging off]
                                                                                                                                                                                                                                                          Script NameTurn Logging on
                                                                                                                                                                                                                                                          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 [ $$LogScriptCalls; Value:1 ]
                                                                                                                                                                                                                                                            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: [Turn Logging on]Next Script: [Refresh window]
                                                                                                                                                                                                                                                                          Script NameTurn Logging off
                                                                                                                                                                                                                                                                          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 [ $$LogScriptCalls; Value:0 ]
                                                                                                                                                                                                                                                                            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: [Turn Logging off]
                                                                                                                                                                                                                                                                                          Script NameRefresh window
                                                                                                                                                                                                                                                                                          Run script with full access privilegesOff
                                                                                                                                                                                                                                                                                          Include In MenuYes
                                                                                                                                                                                                                                                                                          Layouts that use this script
                                                                                                                                                                                                                                                                                            Scripts that use this script
                                                                                                                                                                                                                                                                                              Script Definition
                                                                                                                                                                                                                                                                                              Script Steps
                                                                                                                                                                                                                                                                                              • Refresh Window [ Flush cached join results; Flush cached external data ]
                                                                                                                                                                                                                                                                                              • Refresh Portal [ Object Name: "counters" ]
                                                                                                                                                                                                                                                                                              • Refresh Portal [ Object Name: "calls" ]
                                                                                                                                                                                                                                                                                              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

                                                                                                                                                                                                                                                                                                            Custom Functions

                                                                                                                                                                                                                                                                                                            Function NameParametersAvailabilityDefinitionIn Field DefinitionsIn Scripts
                                                                                                                                                                                                                                                                                                            CountScriptCallAll accountsIf($$LogScriptCalls; Let ( [ FileName = Get(FileName); ScriptName = Get(ScriptName); // try to insert new record r = MBS( "FM.InsertRecord"; FileName; "ScriptCallCounter"; "Counter"; 1; "ScriptName"; ScriptName; "FileName"; FileName ); // r shows OK or "[MBS] ERROR: (504): Field failed unique value validation test" in case of duplicate // check for error: 504 p = Position ( r ; "(504)" ; 1 ; 1 ); // update existing call on error r = If( p > 0; MBS( "FM.ExecuteFileSQL"; FileName; "UPDATE \"ScriptCallCounter\" SET \"Counter\" = \"Counter\" + 1 WHERE \"ScriptName\" = ? AND \"FileName\" = ?"; 9; 13; ScriptName; FileName ); r) ]; r ); "")
                                                                                                                                                                                                                                                                                                              LogScriptCallAll accountsIf($$LogScriptCalls; Let ( [ // query some values about current context FileName = Get(FileName); ScriptName = Get(ScriptName); TableName = Get(LayoutTableName); AccountName = Get(AccountName); LayoutName = Get(LayoutName); UserName = Get(UserName); IP = Get(SystemIPAddress); ScriptParameter = Get(ScriptParameter); // make an unique key for later $ScriptCallID = Get(UUID); // and build call stack $$CallStack = $$CallStack & ScriptName & ¶; // now log it. r = MBS( "FM.InsertRecord"; FileName; "ScriptCallLog"; "ScriptCallID"; $ScriptCallID; "ScriptName"; ScriptName; "FileName"; FileName; "TableName"; TableName; "LayoutName"; LayoutName; "AccountName"; AccountName; "UserName"; UserName; "IP"; IP; "ScriptParameter"; GetAsText(ScriptParameter); "CallStack"; $$CallStack; "StartTime"; Get ( CurrentTimestamp )) ]; r ); "")
                                                                                                                                                                                                                                                                                                                LogScriptResultResultAll accountsIf(not IsEmpty($ScriptCallID); Let ( [ // remove us from call stack $$CallStack = LeftValues ( $$CallStack ; ValueCount ( $$CallStack ) - 1 ); // now updat entry in log to show result. FileName = Get(FileName); r = MBS( "FM.ExecuteFileSQL"; FileName; "UPDATE \"ScriptCallLog\" SET \"ScriptResult\" = ?, \"EndTime\" = ? WHERE \"ScriptCallID\" = ?"; 9; 13; GetAsText( Result ); Get(CurrentTimestamp); $ScriptCallID ) ]; Result ); Result)

                                                                                                                                                                                                                                                                                                                  Custom Menu Sets

                                                                                                                                                                                                                                                                                                                  Menu SetsMenusIn ScriptsIn LayoutsComments
                                                                                                                                                                                                                                                                                                                  [Standard FileMaker Menus]
                                                                                                                                                                                                                                                                                                                  • All Standard Menus

                                                                                                                                                                                                                                                                                                                  Download example: Custom Functions to Log Scriptcalls

                                                                                                                                                                                                                                                                                                                  Used functions:




                                                                                                                                                                                                                                                                                                                  Links
                                                                                                                                                                                                                                                                                                                  MBS Xojo Plugins