MBS FileMaker Plugin Example Databases

Audit

All examples are included with download of MBS FileMaker Plugin.

Audit.fmp12

Overview
Tables2
Relationships0
Layouts2
Scripts5
Value Lists0
Custom Functions0
Custom Menus33
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
Audit
8 fields defined, 3 records
Audit
AuditLog
18 fields defined, 25 records
AuditLog

Fields

Table Name: Audit - 8 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
SomeTextNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      SomeNumberNormal, NumberAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
            SomeDateNormal, DateAuto-Enter:
            • Allow editing
            Validation:
            • Only during data entry
            Storage:
            • Repetitions: 1
            • Indexing: None
            • Automatically create indexes as needed
            • Index Language: German
                  SomeTimeNormal, TimeAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                        SomeTimeStampNormal, TimestampAuto-Enter:
                        • Allow editing
                        Validation:
                        • Only during data entry
                        Storage:
                        • Repetitions: 1
                        • Indexing: None
                        • Automatically create indexes as needed
                        • Index Language: German
                            SomeContainerNormal, BinaryAuto-Enter:
                            • Allow editing
                            Validation:
                            • Only during data entry
                            Storage:
                            • Repetitions: 1
                                  AuditTimeStampNormal, TimestampAuto-Enter:
                                  • Modification timestamp
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      AuditStateNormal, TextAuto-Enter: Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German

                                            Table Name: AuditLog - 18 Fields
                                            Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
                                            TableNameNormal, TextAuto-Enter:
                                            • Allow editing
                                            Validation:
                                            • Only during data entry
                                            Storage:
                                            • Repetitions: 1
                                            • Indexing: Minimal
                                            • Automatically create indexes as needed
                                            • Index Language: German
                                                  RecordIDNormal, TextAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: Minimal
                                                  • Automatically create indexes as needed
                                                  • Index Language: German
                                                        FieldHashNormal, TextAuto-Enter:
                                                        • Allow editing
                                                        Validation:
                                                        • Only during data entry
                                                        Storage:
                                                        • Repetitions: 1
                                                        • Indexing: None
                                                        • Automatically create indexes as needed
                                                        • Index Language: German
                                                              FieldNameNormal, TextAuto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                              • Indexing: Minimal
                                                              • Automatically create indexes as needed
                                                              • Index Language: German
                                                                    FieldValueNormal, TextAuto-Enter:
                                                                    • Allow editing
                                                                    Validation:
                                                                    • Only during data entry
                                                                    Storage:
                                                                    • Repetitions: 1
                                                                    • Indexing: None
                                                                    • Automatically create indexes as needed
                                                                    • Index Language: German
                                                                          FieldOldValueNormal, TextAuto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: None
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German
                                                                                FieldTypeNormal, 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
                                                                                                  TimeStampNormal, TextAuto-Enter:
                                                                                                  • Allow editing
                                                                                                  Validation:
                                                                                                  • Only during data entry
                                                                                                  Storage:
                                                                                                  • Repetitions: 1
                                                                                                  • Indexing: None
                                                                                                  • Automatically create indexes as needed
                                                                                                  • Index Language: German
                                                                                                        ActionNormal, TextAuto-Enter:
                                                                                                        • Allow editing
                                                                                                        Validation:
                                                                                                        • Only during data entry
                                                                                                        Storage:
                                                                                                        • Repetitions: 1
                                                                                                        • Indexing: None
                                                                                                        • Automatically create indexes as needed
                                                                                                        • Index Language: German
                                                                                                              CurrentHostTimeStampNormal, TextAuto-Enter:
                                                                                                              • Allow editing
                                                                                                              Validation:
                                                                                                              • Only during data entry
                                                                                                              Storage:
                                                                                                              • Repetitions: 1
                                                                                                              • Indexing: None
                                                                                                              • Automatically create indexes as needed
                                                                                                              • Index Language: German
                                                                                                                    PrivilegeSetNameNormal, TextAuto-Enter:
                                                                                                                    • Allow editing
                                                                                                                    Validation:
                                                                                                                    • Only during data entry
                                                                                                                    Storage:
                                                                                                                    • Repetitions: 1
                                                                                                                    • Indexing: None
                                                                                                                    • 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
                                                                                                                                LayoutNumberNormal, TextAuto-Enter:
                                                                                                                                • Allow editing
                                                                                                                                Validation:
                                                                                                                                • Only during data entry
                                                                                                                                Storage:
                                                                                                                                • Repetitions: 1
                                                                                                                                • Indexing: None
                                                                                                                                • Automatically create indexes as needed
                                                                                                                                • Index Language: German
                                                                                                                                      WindowNameNormal, TextAuto-Enter:
                                                                                                                                      • Allow editing
                                                                                                                                      Validation:
                                                                                                                                      • Only during data entry
                                                                                                                                      Storage:
                                                                                                                                      • Repetitions: 1
                                                                                                                                      • Indexing: None
                                                                                                                                      • Automatically create indexes as needed
                                                                                                                                      • Index Language: German
                                                                                                                                            InsideScriptNormal, TextAuto-Enter:
                                                                                                                                            • Allow editing
                                                                                                                                            Validation:
                                                                                                                                            • Only during data entry
                                                                                                                                            Storage:
                                                                                                                                            • Repetitions: 1
                                                                                                                                            • Indexing: None
                                                                                                                                            • Automatically create indexes as needed
                                                                                                                                            • Index Language: German
                                                                                                                                                  ServerUserNameNormal, TextAuto-Enter:
                                                                                                                                                  • Allow editing
                                                                                                                                                  Validation:
                                                                                                                                                  • Only during data entry
                                                                                                                                                  Storage:
                                                                                                                                                  • Repetitions: 1
                                                                                                                                                  • Indexing: None
                                                                                                                                                  • Automatically create indexes as needed
                                                                                                                                                  • Index Language: German

                                                                                                                                                        Layout Objects: Audit

                                                                                                                                                        Regular Fields

                                                                                                                                                        Field Name: Audit::SomeText
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 28 pt
                                                                                                                                                        • Left: 146 pt
                                                                                                                                                        • Bottom: 47 pt
                                                                                                                                                        • Right: 404 pt
                                                                                                                                                        • Anchoring: Left and Right, 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: Audit::SomeNumber
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 51 pt
                                                                                                                                                        • Left: 146 pt
                                                                                                                                                        • Bottom: 70 pt
                                                                                                                                                        • Right: 404 pt
                                                                                                                                                        • Anchoring: Left and Right, 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: Audit::SomeDate
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 74 pt
                                                                                                                                                        • Left: 146 pt
                                                                                                                                                        • Bottom: 93 pt
                                                                                                                                                        • Right: 404 pt
                                                                                                                                                        • Anchoring: Left and Right, 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: Audit::SomeTime
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 97 pt
                                                                                                                                                        • Left: 146 pt
                                                                                                                                                        • Bottom: 116 pt
                                                                                                                                                        • Right: 404 pt
                                                                                                                                                        • Anchoring: Left and Right, 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: Audit::SomeTimeStamp
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 120 pt
                                                                                                                                                        • Left: 146 pt
                                                                                                                                                        • Bottom: 139 pt
                                                                                                                                                        • Right: 404 pt
                                                                                                                                                        • Anchoring: Left and Right, 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: Audit::SomeContainer
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 143 pt
                                                                                                                                                        • Left: 146 pt
                                                                                                                                                        • Bottom: 268 pt
                                                                                                                                                        • Right: 404 pt
                                                                                                                                                        • Anchoring: Left and Right, Top and Bottom
                                                                                                                                                        Field Format:
                                                                                                                                                        • Edit Box
                                                                                                                                                        Field Behavior:
                                                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                                                        • Touch keyboard type: Default for Data Type
                                                                                                                                                        • Go to next field using: Tab key
                                                                                                                                                        No

                                                                                                                                                        Field Name: Audit::AuditTimeStamp
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 272 pt
                                                                                                                                                        • Left: 146 pt
                                                                                                                                                        • Bottom: 291 pt
                                                                                                                                                        • Right: 404 pt
                                                                                                                                                        • Anchoring: Left and Right, Bottom
                                                                                                                                                        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: Audit::AuditState
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 295 pt
                                                                                                                                                        • Left: 146 pt
                                                                                                                                                        • Bottom: 314 pt
                                                                                                                                                        • Right: 404 pt
                                                                                                                                                        • Anchoring: Left and Right, Bottom
                                                                                                                                                        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: AuditLog

                                                                                                                                                        Regular Fields

                                                                                                                                                        Field Name: AuditLog::TableName
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 23 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 42 pt
                                                                                                                                                        • Right: 396 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: AuditLog::RecordID
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 46 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 65 pt
                                                                                                                                                        • Right: 396 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: AuditLog::FieldHash
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 69 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 88 pt
                                                                                                                                                        • Right: 396 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: AuditLog::FieldName
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 92 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 111 pt
                                                                                                                                                        • Right: 396 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: AuditLog::FieldValue
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 115 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 134 pt
                                                                                                                                                        • Right: 396 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: AuditLog::FieldOldValue
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 138 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 157 pt
                                                                                                                                                        • Right: 396 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: AuditLog::FieldType
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 161 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 180 pt
                                                                                                                                                        • Right: 396 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: AuditLog::UserName
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 184 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 203 pt
                                                                                                                                                        • Right: 396 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: AuditLog::IP
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 207 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 226 pt
                                                                                                                                                        • Right: 396 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: AuditLog::TimeStamp
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 230 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 249 pt
                                                                                                                                                        • Right: 396 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: AuditLog::Action
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 253 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 272 pt
                                                                                                                                                        • Right: 396 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: AuditLog::CurrentHostTimeStamp
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 276 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 295 pt
                                                                                                                                                        • Right: 396 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: AuditLog::PrivilegeSetName
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 299 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 318 pt
                                                                                                                                                        • Right: 396 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: AuditLog::AccountName
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 322 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 341 pt
                                                                                                                                                        • Right: 396 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: AuditLog::LayoutNumber
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 345 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 364 pt
                                                                                                                                                        • Right: 396 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: AuditLog::WindowName
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 368 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 387 pt
                                                                                                                                                        • Right: 396 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: AuditLog::InsideScript
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 391 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 410 pt
                                                                                                                                                        • Right: 396 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: AuditLog::ServerUserName
                                                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                                                        • Top: 414 pt
                                                                                                                                                        • Left: 143 pt
                                                                                                                                                        • Bottom: 433 pt
                                                                                                                                                        • Right: 396 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

                                                                                                                                                        Login
                                                                                                                                                        ChangeTextByScript
                                                                                                                                                        Audit on server
                                                                                                                                                        Trigger Audit
                                                                                                                                                        Trigger Audit on Server

                                                                                                                                                        Next Script: [ChangeTextByScript]
                                                                                                                                                        Script NameLogin
                                                                                                                                                        Run script with full access privilegesOff
                                                                                                                                                        Include In MenuYes
                                                                                                                                                        Layouts that use this script
                                                                                                                                                          Scripts that use this script
                                                                                                                                                            Script Definition
                                                                                                                                                            Script Steps
                                                                                                                                                            • Re-Login [ ]
                                                                                                                                                            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: [Login]Next Script: [Audit on server]
                                                                                                                                                                          Script NameChangeTextByScript
                                                                                                                                                                          Run script with full access privilegesOff
                                                                                                                                                                          Include In MenuYes
                                                                                                                                                                          Layouts that use this script
                                                                                                                                                                            Scripts that use this script
                                                                                                                                                                              Script Definition
                                                                                                                                                                              Script Steps
                                                                                                                                                                              • #Start
                                                                                                                                                                              • Set Variable [ $$InsideScript; Value:Get ( ScriptName ) ]
                                                                                                                                                                              • #Do something
                                                                                                                                                                              • Set Field [ Audit::SomeText; Get ( CurrentDate ) ]
                                                                                                                                                                              • Set Field [ Audit::SomeTimeStamp; Get ( CurrentTimestamp ) ]
                                                                                                                                                                              • Commit Records/Requests [ No dialog ]
                                                                                                                                                                              • #End
                                                                                                                                                                              • Set Variable [ $$InsideScript; Value:"" ]
                                                                                                                                                                              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: [ChangeTextByScript]Next Script: [Trigger Audit]
                                                                                                                                                                                      Script NameAudit on server
                                                                                                                                                                                      Run script with full access privilegesOff
                                                                                                                                                                                      Include In MenuNo
                                                                                                                                                                                      Layouts that use this script
                                                                                                                                                                                        Scripts that use this script
                                                                                                                                                                                        Script Definition
                                                                                                                                                                                        Script Steps
                                                                                                                                                                                        • #give FileMaker Go some time to save
                                                                                                                                                                                        • Pause/Resume Script [ Duration (seconds): ,5 ]
                                                                                                                                                                                        • #get parameter with layout and record id
                                                                                                                                                                                        • Set Variable [ $Param; Value:Get(ScriptParameter) ]
                                                                                                                                                                                        • Set Variable [ $LayoutName; Value:GetValue($Param; 1) ]
                                                                                                                                                                                        • Set Variable [ $RecordID; Value:GetValue($Param; 2) ]
                                                                                                                                                                                        • Set Variable [ $UserName; Value:GetValue($Param; 3) ]
                                                                                                                                                                                        • #go to record
                                                                                                                                                                                        • Go to Layout [ $LayoutName ]
                                                                                                                                                                                        • Go to Record/Request/Page [ $RecordID ] [ No dialog ]
                                                                                                                                                                                        • #log changes
                                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Audit.Changed"; Audit::AuditTimeStamp; "Audit"; "ServerUserName|" & $UserName) ]
                                                                                                                                                                                        • Exit Script [ Result: $r ]
                                                                                                                                                                                        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: [Audit on server]Next Script: [Trigger Audit on Server]
                                                                                                                                                                                                Script NameTrigger Audit
                                                                                                                                                                                                Run script with full access privilegesOff
                                                                                                                                                                                                Include In MenuNo
                                                                                                                                                                                                Layouts that use this script
                                                                                                                                                                                                  Scripts that use this script
                                                                                                                                                                                                    Script Definition
                                                                                                                                                                                                    Script Steps
                                                                                                                                                                                                    • #run it locally to test
                                                                                                                                                                                                    • Perform Script [ “Audit on server”; Parameter: Get(LayoutName) & ¶ & Get(RecordID) & ¶ & Get(UserName) ]
                                                                                                                                                                                                    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: [Trigger Audit]
                                                                                                                                                                                                                Script NameTrigger Audit on Server
                                                                                                                                                                                                                Run script with full access privilegesOff
                                                                                                                                                                                                                Include In MenuNo
                                                                                                                                                                                                                Layouts that use this script
                                                                                                                                                                                                                  Scripts that use this script
                                                                                                                                                                                                                    Script Definition
                                                                                                                                                                                                                    Script Steps
                                                                                                                                                                                                                    • Set Error Capture [ On ]
                                                                                                                                                                                                                    • #check for missing plugin, e.g. on FileMaker Go
                                                                                                                                                                                                                    • If [ GetAsText(MBS("Version")) = "?" ]
                                                                                                                                                                                                                    • Perform Script on Server [ “Audit on server”; Parameter: Get(LayoutName) & ¶ & Get(RecordID) & ¶ & Get(UserName) ]
                                                                                                                                                                                                                    • End If
                                                                                                                                                                                                                    • Exit Script [ Result: 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

                                                                                                                                                                                                                                Download example: Audit

                                                                                                                                                                                                                                Used functions:




                                                                                                                                                                                                                                Links
                                                                                                                                                                                                                                MBS FileMaker tutorial videos