Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

MBS FileMaker Plugin Example Databases

Audit

All examples are included with download of MBS FileMaker Plugin.

Audit.fmp12

Overview
Tables 2
Relationships 0
Layouts 2
Scripts 7
Value Lists 0
Custom Functions 0
Custom Menus 33
File Options
Default custom menu set [Standard FileMaker Menus]
Default theme Apex Blue
When opening file
Minimum allowed version 12.0
Login using Account Name; Account= admin
Allow user to save password On
Require iOS passcode Off
Show Sign-in fields Off
Switch to layout Off
Hide all toolbars Off
Script triggers
OnFirstWindowOpen Off
OnLastWindowClose Off
OnWindowOpen Off
OnWindowClose Off
OnFileAVPlayerChange Off
OnWindowTransaction Off
Thumbnail Settings
Generate Thumbnails On; Temporary

 

Tables

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

Fields

Table Name: Audit - 8 Fields
Field Name Type Options Comments On Layouts In Relationships In Scripts In Value Lists
SomeText Normal, Text Auto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      SomeNumber Normal, Number Auto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
            SomeDate Normal, Date Auto-Enter:
            • Allow editing
            Validation:
            • Only during data entry
            Storage:
            • Repetitions: 1
            • Indexing: None
            • Automatically create indexes as needed
            • Index Language: German
                  SomeTime Normal, Time Auto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                        SomeTimeStamp Normal, Timestamp Auto-Enter:
                        • Allow editing
                        Validation:
                        • Only during data entry
                        Storage:
                        • Repetitions: 1
                        • Indexing: None
                        • Automatically create indexes as needed
                        • Index Language: German
                            SomeContainer Normal, Binary Auto-Enter:
                            • Allow editing
                            Validation:
                            • Only during data entry
                            Storage:
                            • Repetitions: 1
                                  AuditTimeStamp Normal, Timestamp Auto-Enter:
                                  • Modification timestamp
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      AuditState Normal, Text Auto-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 Name Type Options Comments On Layouts In Relationships In Scripts In Value Lists
                                            TableName Normal, Text Auto-Enter:
                                            • Allow editing
                                            Validation:
                                            • Only during data entry
                                            Storage:
                                            • Repetitions: 1
                                            • Indexing: Minimal
                                            • Automatically create indexes as needed
                                            • Index Language: German
                                                  RecordID Normal, Text Auto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: Minimal
                                                  • Automatically create indexes as needed
                                                  • Index Language: German
                                                        FieldHash Normal, Text Auto-Enter:
                                                        • Allow editing
                                                        Validation:
                                                        • Only during data entry
                                                        Storage:
                                                        • Repetitions: 1
                                                        • Indexing: None
                                                        • Automatically create indexes as needed
                                                        • Index Language: German
                                                              FieldName Normal, Text Auto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                              • Indexing: Minimal
                                                              • Automatically create indexes as needed
                                                              • Index Language: German
                                                                    FieldValue Normal, Text Auto-Enter:
                                                                    • Allow editing
                                                                    Validation:
                                                                    • Only during data entry
                                                                    Storage:
                                                                    • Repetitions: 1
                                                                    • Indexing: None
                                                                    • Automatically create indexes as needed
                                                                    • Index Language: German
                                                                          FieldOldValue Normal, Text Auto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: None
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German
                                                                                FieldType Normal, Text Auto-Enter:
                                                                                • Allow editing
                                                                                Validation:
                                                                                • Only during data entry
                                                                                Storage:
                                                                                • Repetitions: 1
                                                                                • Indexing: None
                                                                                • Automatically create indexes as needed
                                                                                • Index Language: German
                                                                                      UserName Normal, Text Auto-Enter:
                                                                                      • Allow editing
                                                                                      Validation:
                                                                                      • Only during data entry
                                                                                      Storage:
                                                                                      • Repetitions: 1
                                                                                      • Indexing: None
                                                                                      • Automatically create indexes as needed
                                                                                      • Index Language: German
                                                                                            IP Normal, Text Auto-Enter:
                                                                                            • Allow editing
                                                                                            Validation:
                                                                                            • Only during data entry
                                                                                            Storage:
                                                                                            • Repetitions: 1
                                                                                            • Indexing: None
                                                                                            • Automatically create indexes as needed
                                                                                            • Index Language: German
                                                                                                  TimeStamp Normal, Text Auto-Enter:
                                                                                                  • Allow editing
                                                                                                  Validation:
                                                                                                  • Only during data entry
                                                                                                  Storage:
                                                                                                  • Repetitions: 1
                                                                                                  • Indexing: None
                                                                                                  • Automatically create indexes as needed
                                                                                                  • Index Language: German
                                                                                                        Action Normal, Text Auto-Enter:
                                                                                                        • Allow editing
                                                                                                        Validation:
                                                                                                        • Only during data entry
                                                                                                        Storage:
                                                                                                        • Repetitions: 1
                                                                                                        • Indexing: None
                                                                                                        • Automatically create indexes as needed
                                                                                                        • Index Language: German
                                                                                                              CurrentHostTimeStamp Normal, Text Auto-Enter:
                                                                                                              • Allow editing
                                                                                                              Validation:
                                                                                                              • Only during data entry
                                                                                                              Storage:
                                                                                                              • Repetitions: 1
                                                                                                              • Indexing: None
                                                                                                              • Automatically create indexes as needed
                                                                                                              • Index Language: German
                                                                                                                    PrivilegeSetName Normal, Text Auto-Enter:
                                                                                                                    • Allow editing
                                                                                                                    Validation:
                                                                                                                    • Only during data entry
                                                                                                                    Storage:
                                                                                                                    • Repetitions: 1
                                                                                                                    • Indexing: None
                                                                                                                    • Automatically create indexes as needed
                                                                                                                    • Index Language: German
                                                                                                                          AccountName Normal, Text Auto-Enter:
                                                                                                                          • Allow editing
                                                                                                                          Validation:
                                                                                                                          • Only during data entry
                                                                                                                          Storage:
                                                                                                                          • Repetitions: 1
                                                                                                                          • Indexing: None
                                                                                                                          • Automatically create indexes as needed
                                                                                                                          • Index Language: German
                                                                                                                                LayoutNumber Normal, Text Auto-Enter:
                                                                                                                                • Allow editing
                                                                                                                                Validation:
                                                                                                                                • Only during data entry
                                                                                                                                Storage:
                                                                                                                                • Repetitions: 1
                                                                                                                                • Indexing: None
                                                                                                                                • Automatically create indexes as needed
                                                                                                                                • Index Language: German
                                                                                                                                      WindowName Normal, Text Auto-Enter:
                                                                                                                                      • Allow editing
                                                                                                                                      Validation:
                                                                                                                                      • Only during data entry
                                                                                                                                      Storage:
                                                                                                                                      • Repetitions: 1
                                                                                                                                      • Indexing: None
                                                                                                                                      • Automatically create indexes as needed
                                                                                                                                      • Index Language: German
                                                                                                                                            InsideScript Normal, Text Auto-Enter:
                                                                                                                                            • Allow editing
                                                                                                                                            Validation:
                                                                                                                                            • Only during data entry
                                                                                                                                            Storage:
                                                                                                                                            • Repetitions: 1
                                                                                                                                            • Indexing: None
                                                                                                                                            • Automatically create indexes as needed
                                                                                                                                            • Index Language: German
                                                                                                                                                  ServerUserName Normal, Text Auto-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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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 Properties Coordinates Field Format Field Behavior Quick 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
                                                                                                                                                        Build caches
                                                                                                                                                        Statistics

                                                                                                                                                        Next Script: [ChangeTextByScript]
                                                                                                                                                        Script Name Login
                                                                                                                                                        Run script with full access privileges Off
                                                                                                                                                        Siri Shortcut Visible Off
                                                                                                                                                        Include In Menu Yes
                                                                                                                                                        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 Name ChangeTextByScript
                                                                                                                                                                          Run script with full access privileges Off
                                                                                                                                                                          Siri Shortcut Visible Off
                                                                                                                                                                          Include In Menu Yes
                                                                                                                                                                          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 Name Audit on server
                                                                                                                                                                                      Run script with full access privileges Off
                                                                                                                                                                                      Siri Shortcut Visible Off
                                                                                                                                                                                      Include In Menu No
                                                                                                                                                                                      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 Name Trigger Audit
                                                                                                                                                                                                Run script with full access privileges Off
                                                                                                                                                                                                Siri Shortcut Visible Off
                                                                                                                                                                                                Include In Menu Yes
                                                                                                                                                                                                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] Next Script: [Build caches]
                                                                                                                                                                                                                Script Name Trigger Audit on Server
                                                                                                                                                                                                                Run script with full access privileges Off
                                                                                                                                                                                                                Siri Shortcut Visible Off
                                                                                                                                                                                                                Include In Menu No
                                                                                                                                                                                                                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

                                                                                                                                                                                                                                Previous Script: [Trigger Audit on Server] Next Script: [Statistics]
                                                                                                                                                                                                                                Script Name Build caches
                                                                                                                                                                                                                                Run script with full access privileges Off
                                                                                                                                                                                                                                Siri Shortcut Visible Off
                                                                                                                                                                                                                                Include In Menu Yes
                                                                                                                                                                                                                                Layouts that use this script
                                                                                                                                                                                                                                  Scripts that use this script
                                                                                                                                                                                                                                    Script Definition
                                                                                                                                                                                                                                    Script Steps
                                                                                                                                                                                                                                    • #Usually not needed as it happens automatically.
                                                                                                                                                                                                                                    • Set Variable [ $r; Value:MBS("Audit.BuildCaches") ]
                                                                                                                                                                                                                                    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: [Build caches]
                                                                                                                                                                                                                                                  Script Name Statistics
                                                                                                                                                                                                                                                  Run script with full access privileges Off
                                                                                                                                                                                                                                                  Siri Shortcut Visible Off
                                                                                                                                                                                                                                                  Include In Menu Yes
                                                                                                                                                                                                                                                  Layouts that use this script
                                                                                                                                                                                                                                                    Scripts that use this script
                                                                                                                                                                                                                                                      Script Definition
                                                                                                                                                                                                                                                      Script Steps
                                                                                                                                                                                                                                                      • #Usually not needed as it happens automatically.
                                                                                                                                                                                                                                                      • Set Variable [ $r; Value:MBS("Audit.Statistics") ]
                                                                                                                                                                                                                                                      • Show Custom Dialog [ Title: "Audit Statistics"; Message: $r; Default Button: “OK”, Commit: “Yes” ]
                                                                                                                                                                                                                                                      Fields used in this script
                                                                                                                                                                                                                                                        Scripts used in this script
                                                                                                                                                                                                                                                          Layouts used in this script
                                                                                                                                                                                                                                                            Tables used in this script
                                                                                                                                                                                                                                                              Table occurrences used by this script
                                                                                                                                                                                                                                                                Custom Functions used by this script
                                                                                                                                                                                                                                                                  Custom menu set used by this script

                                                                                                                                                                                                                                                                    Download example: Audit

                                                                                                                                                                                                                                                                    Used functions: