MBS FileMaker Plugin Example Databases

Event Management AuditLog

All examples are included with download of MBS FileMaker Plugin.

Event Management AuditLog.fmp12

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

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
AuditLog
14 fields defined, 58 records
AuditLog

Fields

Table Name: AuditLog - 14 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
TableNameNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: Minimal
  • Automatically create indexes as needed
  • Index Language: German
        RecordIDNormal, TextAuto-Enter:
        • Allow editing
        Validation:
        • Only during data entry
        Storage:
        • Repetitions: 1
        • Indexing: Minimal
        • Automatically create indexes as needed
        • Index Language: German
              FieldHashNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                    FieldNameNormal, TextAuto-Enter:
                    • Allow editing
                    Validation:
                    • Only during data entry
                    Storage:
                    • Repetitions: 1
                    • Indexing: Minimal
                    • Automatically create indexes as needed
                    • Index Language: German
                          FieldValueNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                                FieldOldValueNormal, TextAuto-Enter:
                                • Allow editing
                                Validation:
                                • Only during data entry
                                Storage:
                                • Repetitions: 1
                                • Indexing: None
                                • Automatically create indexes as needed
                                • Index Language: German
                                      UserNameNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                            IPNormal, TextAuto-Enter:
                                            • Allow editing
                                            Validation:
                                            • Only during data entry
                                            Storage:
                                            • Repetitions: 1
                                            • Indexing: None
                                            • Automatically create indexes as needed
                                            • Index Language: German
                                                  TimeStampNormal, TextAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: German
                                                        ActionNormal, TextAuto-Enter:
                                                        • Allow editing
                                                        Validation:
                                                        • Only during data entry
                                                        Storage:
                                                        • Repetitions: 1
                                                        • Indexing: Minimal
                                                        • Automatically create indexes as needed
                                                        • Index Language: German
                                                              AccountNameNormal, TextAuto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                              • Indexing: None
                                                              • Automatically create indexes as needed
                                                              • Index Language: German
                                                                    WindowNameNormal, TextAuto-Enter:
                                                                    • Allow editing
                                                                    Validation:
                                                                    • Only during data entry
                                                                    Storage:
                                                                    • Repetitions: 1
                                                                    • Indexing: None
                                                                    • Automatically create indexes as needed
                                                                    • Index Language: German
                                                                          EventIDNormal, TextAuto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: Minimal
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German
                                                                                  ContactIDNormal, TextAuto-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 PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 52 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 73 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          Field Behavior:
                                                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                                                          • Touch keyboard type: Default for Data Type
                                                                                          • Go to next field using: Tab key
                                                                                          Yes

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

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

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

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

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

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

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

                                                                                          Field Name: AuditLog::RecordID
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick 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 PropertiesCoordinatesField FormatField BehaviorQuick 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 PropertiesCoordinatesField FormatField BehaviorQuick 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 PropertiesCoordinatesField FormatField BehaviorQuick 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

                                                                                          Download example: Event Management AuditLog




                                                                                          Links
                                                                                          MBS Xojo Plugins