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

MBS FileMaker Plugin Example Databases

Event Management AuditLog

All examples are included with download of MBS FileMaker Plugin.

Event Management AuditLog.fmp12

Overview
Tables 1
Relationships 0
Layouts 1
Scripts 0
Value Lists 0
Custom Functions 0
Custom Menus 24
File Options
Default custom menu set [Standard FileMaker Menus]
Default theme Enlightened
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
Comments
 Occurrences in Relationship Graph
AuditLog
14 fields defined, 58 records
 AuditLog

Fields

Table Name: AuditLog - 14 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
                                      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: Minimal
                                                        • 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
                                                                    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
                                                                          EventID Normal, Text Auto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: Minimal
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German
                                                                                ContactID 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: AuditLog

                                                                                      Regular Fields

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

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

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

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

                                                                                      Field Name: AuditLog::UserName
                                                                                      Field Properties Coordinates Field Format Field Behavior Quick Find
                                                                                      • Top: 144 pt
                                                                                      • Left: 138 pt
                                                                                      • Bottom: 165 pt
                                                                                      • Right: 391 pt
                                                                                      • Anchoring: Left, Top
                                                                                      		 Field Format:
                                                                                      • Edit Box
                                                                                      		 Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      		 Yes

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

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

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

                                                                                      Field Name: AuditLog::RecordID
                                                                                      Field Properties Coordinates Field Format Field Behavior Quick Find
                                                                                      • Top: 236 pt
                                                                                      • Left: 138 pt
                                                                                      • Bottom: 257 pt
                                                                                      • Right: 391 pt
                                                                                      • Anchoring: Left, Top
                                                                                      		 Field Format:
                                                                                      • Edit Box
                                                                                      		 Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      		 Yes

                                                                                      Field Name: AuditLog::AccountName
                                                                                      Field Properties Coordinates Field Format Field Behavior Quick Find
                                                                                      • Top: 259 pt
                                                                                      • Left: 138 pt
                                                                                      • Bottom: 280 pt
                                                                                      • Right: 391 pt
                                                                                      • Anchoring: Left, Top
                                                                                      		 Field Format:
                                                                                      • Edit Box
                                                                                      		 Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      		 Yes

                                                                                      Field Name: AuditLog::WindowName
                                                                                      Field Properties Coordinates Field Format Field Behavior Quick Find
                                                                                      • Top: 282 pt
                                                                                      • Left: 138 pt
                                                                                      • Bottom: 303 pt
                                                                                      • Right: 391 pt
                                                                                      • Anchoring: Left, Top
                                                                                      		 Field Format:
                                                                                      • Edit Box
                                                                                      		 Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      		 Yes

                                                                                      Field Name: AuditLog::FieldOldValue
                                                                                      Field Properties Coordinates Field Format Field Behavior Quick Find
                                                                                      • Top: 305 pt
                                                                                      • Left: 138 pt
                                                                                      • Bottom: 326 pt
                                                                                      • Right: 391 pt
                                                                                      • Anchoring: Left, Top
                                                                                      		 Field Format:
                                                                                      • Edit Box
                                                                                      		 Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      		 Yes

                                                                                      Field Name: AuditLog::EventID
                                                                                      Field Properties Coordinates Field Format Field Behavior Quick Find
                                                                                      • Top: 280 pt
                                                                                      • Left: 591 pt
                                                                                      • Bottom: 301 pt
                                                                                      • Right: 844 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::ContactID
                                                                                      Field Properties Coordinates Field Format Field Behavior Quick Find
                                                                                      • Top: 303 pt
                                                                                      • Left: 591 pt
                                                                                      • Bottom: 324 pt
                                                                                      • Right: 844 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

                                                                                      Download example: Event Management AuditLog