Monkeybread Software - MBS FileMaker Plugin: Event Management AuditLog

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	0

File Options
Default custom menu set	[Standard FileMaker Menus]
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

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

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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog
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		AuditLog

Layout Objects: AuditLog

Field Name: AuditLog::FieldHash

Field Properties

Layout Name:

AuditLog

Top: 52 pt
Left: 138 pt
Bottom: 73 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::FieldName

Field Properties

Layout Name:

AuditLog

Top: 75 pt
Left: 138 pt
Bottom: 96 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::FieldValue

Field Properties

Layout Name:

AuditLog

Top: 98 pt
Left: 138 pt
Bottom: 119 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::TableName

Field Properties

Layout Name:

AuditLog

Top: 121 pt
Left: 138 pt
Bottom: 142 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::UserName

Field Properties

Layout Name:

AuditLog

Top: 144 pt
Left: 138 pt
Bottom: 165 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::IP

Field Properties

Layout Name:

AuditLog

Top: 167 pt
Left: 138 pt
Bottom: 188 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::TimeStamp

Field Properties

Layout Name:

AuditLog

Top: 190 pt
Left: 138 pt
Bottom: 211 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::Action

Field Properties

Layout Name:

AuditLog

Top: 213 pt
Left: 138 pt
Bottom: 234 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::RecordID

Field Properties

Layout Name:

AuditLog

Top: 236 pt
Left: 138 pt
Bottom: 257 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::AccountName

Field Properties

Layout Name:

AuditLog

Top: 259 pt
Left: 138 pt
Bottom: 280 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::WindowName

Field Properties

Layout Name:

AuditLog

Top: 282 pt
Left: 138 pt
Bottom: 303 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::FieldOldValue

Field Properties

Layout Name:

AuditLog

Top: 305 pt
Left: 138 pt
Bottom: 326 pt
Right: 391 pt

Anchoring: Left, Top

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

Field Name: AuditLog::EventID

Field Properties

Layout Name:

AuditLog

Top: 280 pt
Left: 591 pt
Bottom: 301 pt
Right: 844 pt

Anchoring: Left, Top

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

Field Name: AuditLog::ContactID

Field Properties

Layout Name:

AuditLog

Top: 303 pt
Left: 591 pt
Bottom: 324 pt
Right: 844 pt

Anchoring: Left, Top

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

Download example: Event Management AuditLog