Monkeybread Software - MBS FileMaker Plugin: Event Management with Audit

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 with Audit

All examples are included with download of MBS FileMaker Plugin.

Event Management with Audit.fmp12

Overview
Tables	6
Relationships	9
Layouts	11
Scripts	14
Value Lists	18
Custom Functions	2
Custom Menus	25

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

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Events	34 fields defined, 1 record	Events, Venue Looked Up
Contacts	30 fields defined, 1 record	Guests \| Contacts, Contacts
Contributors	11 fields defined, 1 record	Assignees \| Contributors, Contributors
Tasks	12 fields defined, 1 record	Tasks
Guests	10 fields defined, 1 record	Guests
Agenda	9 fields defined, 0 record	Agenda

Fields

Table Name: Events - 34 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
EVENT ID MATCH FIELD	Normal, Number	Auto-Enter: Allow editing Serial: Generate: On creation, Next value: 2, Increment: 1 Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German			Events=Tasks Events=Guests Events=Agenda Events=Contributors Events=AuditLog
Event	Normal, Text	Auto-Enter: Allow editing Context table: Events Calculation: If ( IsEmpty ( Self ) ; "New Event" ; Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Events Event Details Contact Details		Trigger \| Sort Event List
Type	Normal, Text	Auto-Enter: Constant data: Event Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Events Event Details			Type
Date	Normal, Date	Auto-Enter: Creation date Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Events Event Details Contact Details		Trigger \| Sort Event List
Venue	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Events Event Details Contact Details	Venue Looked Up=Events		Venue
Description	Normal, Text	Auto-Enter: Allow editing Lookup: Events::Description, Do not copy, Don't copy contents if empty Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Event Details Contact Details
Address	Normal, Text	Auto-Enter: Allow editing Lookup: Events::Address, Do not copy, Don't copy contents if empty Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details
City	Normal, Text	Auto-Enter: Allow editing Lookup: Events::City, Do not copy, Don't copy contents if empty Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Event Details Contact Details
State	Normal, Text	Auto-Enter: Allow editing Lookup: Events::State, Do not copy, Don't copy contents if empty Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Event Details
Postal Code	Normal, Text	Auto-Enter: Allow editing Lookup: Events::Postal Code, Do not copy, Don't copy contents if empty Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details
Country	Normal, Text	Auto-Enter: Allow editing Lookup: Events::Country, Do not copy, Don't copy contents if empty Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Event Details
Phone	Normal, Text	Auto-Enter: Allow editing Lookup: Events::Phone, Do not copy, Don't copy contents if empty Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details
Email	Normal, Text	Auto-Enter: Allow editing Lookup: Events::Email, Do not copy, Don't copy contents if empty Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details
Notes	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Event Details
Time Frame \| Sort Order	Calculated, Number	Calculation: Context table: Events Let ( now = Get ( CurrentDate ) ; Case ( Events::Date = now ; 0 ; Events::Date > now ; 1 ; Events::Date < now ; 2 ; ) ) // 0 = "Today" // 1 = "Upcoming" // 2 = "Past" Storage: Repetitions: 1 Do not store calculation results Index Language: German				Trigger \| Sort Event List
Time Frame	Calculated, Text	Calculation: Context table: Events Choose ( Events::Time Frame \| Sort Order ; "Today" "Upcoming" "Past" ) // 0 = "Today" // 1 = "Upcoming" // 2 = "Past" Storage: Repetitions: 1 Do not store calculation results Index Language: German
Layout Selector	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Events Contacts		Trigger \| Layout Selection Trigger \| Sort Event List Trigger \| Sort Contact List
Sort Selection	Normal, Text	Auto-Enter: Allow editing Context table: Events Calculation: If ( IsEmpty ( Self ) ; "Time Frame" ; Self ) Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Events		Trigger \| Sort Event List
Sort List Key	Calculated, Text	Calculation: Context table: Events GetField ( Events::Sort Selection ) Storage: Repetitions: 1 Do not store calculation results Index Language: German		Events		Trigger \| Sort Event List
Contributor Number \| All	Calculated, Number	Calculation: Context table: Events Count ( Contributors::EVENT ID MATCH FIELD ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Contributor Number \| Assigned	Calculated, Number	Calculation: Context table: Events If ( Events::Contributor Number \| All = 0 ; 0 ; Sum ( Contributors::Assignment ) ) Storage: Repetitions: 1 Do not store calculation results Index Language: German
Task Number \| All	Calculated, Number	Calculation: Context table: Events Count ( Tasks::EVENT ID MATCH FIELD ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Task Number \| To Do	Calculated, Number	Calculation: Context table: Events If ( Events::Task Number \| All = 0 ; 0 ; Sum ( Tasks::To Do ) ) Storage: Repetitions: 1 Do not store calculation results Index Language: German
Guest Number \| All	Calculated, Number	Calculation: Context table: Events Count ( Guests::EVENT ID MATCH FIELD ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Guest Number \| Attending	Calculated, Number	Calculation: Context table: Events If ( Events::Guest Number \| All = 0 ; 0 ; Sum ( Guests::Attending ) ) Storage: Repetitions: 1 Do not store calculation results Index Language: German
Agenda Item Number \| All	Calculated, Number	Calculation: Context table: Events Count ( Agenda::EVENT ID MATCH FIELD ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Agenda Item Number \| Current	Calculated, Number	Calculation: Context table: Events If ( Events::Agenda Item Number \| All = 0 ; 0 ; Sum ( Agenda::Time Frame Order ) ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Task Label Plural	Calculated, Text	Calculation: Context table: Events If ( Events::Task Number \| All = 1 ; "Task" ; "Tasks" ) Storage: Repetitions: 1 Do not store calculation results Index Language: German
Guest Label Plural	Calculated, Text	Calculation: Context table: Events If ( Events::Guest Number \| All = 1 ; "Guest" ; "Guests" ) Storage: Repetitions: 1 Do not store calculation results Index Language: German
Agenda Item Label Plural	Calculated, Text	Calculation: Context table: Events If ( Events::Agenda Item Number \| All = 1 ; "Item" ; "Items" ) Storage: Repetitions: 1 Do not store calculation results Index Language: German
Result Label Plural	Calculated, Text	Calculation: Context table: Events If ( Get ( FoundCount ) = 1 ; "Result" ; "Results" ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
QuickFind \| iOS	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German
AuditTimeStamp	Normal, Timestamp	Auto-Enter: Modification timestamp Allow editing Validation: Only during data entry Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
AuditState	Normal, Text	Auto-Enter: Allow editing Context table: Events Calculation: MBS("Audit.Changed2"; Events::AuditTimeStamp; "Events"; "Address"; "Agenda Item Label Plural"; "Agenda Item Number \| All"; "Agenda Item Number \| Current"; "City"; "Contributor Number \| All"; "Contributor Number \| Assigned"; "Country"; "Date"; "Description"; "EVENT ID MATCH FIELD"; "Email"; "Event"; "Guest Number \| All"; "Guest Number \| Attending"; "Layout Selector"; "Notes"; "Phone"; "Postal Code"; "Sort List Key"; "Sort Selection"; "State"; "Task Number \| All"; "Task Number \| To Do"; "Time Frame"; "Time Frame \| Sort Order"; "Type"; "Venue"; "EventID\|" & Events::EVENT ID MATCH FIELD) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German

Table Name: Contacts - 30 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
CONTACT ID MATCH FIELD	Normal, Number	Auto-Enter: Allow editing Serial: Generate: On creation, Next value: 2, Increment: 1 Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German
Title	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details			Title
First	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Last	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Initial	Calculated, Text	Calculation: Context table: Contacts Upper ( Case ( not IsEmpty ( Contacts::Last ) ; Left ( Contacts::Last ; 1 ) ; not IsEmpty ( Contacts::First ) ; Left ( Contacts::First ; 1 ) ; not IsEmpty ( Contacts::Company ) ; Left ( Contacts::Company ; 1 ) ; not IsEmpty ( Contacts::Work Phone & Contacts::Mobile Phone & Contacts::Home Phone & Contacts::Fax ) ; "#" ; not IsEmpty ( Contacts::Work Email & Contacts::Home Email ) ; "@" ) ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German		Contacts		Trigger \| Sort Contact List
Contacts \| MATCH FIELD	Calculated, Text	Calculation: Context table: Contacts Case ( IsEmpty ( Contacts::First & Contacts::Last ) ; Contacts::Company ; IsEmpty ( Contacts::First ) ; Contacts::Last ; IsEmpty ( Contacts::Last ) ; Contacts::First ; Contacts::First & " " & Contacts::Last ) Storage: Repetitions: 1 Indexing: All Index Language: German		Event Details Contacts Contact Details	Guests \| Contacts=Guests Contributors=Contacts	Trigger \| Sort Contact List	Contacts
Photo \| Container	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Contact Details
File Name Placeholder	Calculated, Text	Calculation: Context table: Contacts Let ( text = If ( Get ( SystemPlatform ) = 3 ; "Tap to add a photo" ; "Drag your photo here" ) ; If ( IsEmpty ( Contacts::Photo \| Container ) ; text ; "" ) ) Storage: Repetitions: 1 Do not store calculation results Index Language: German		Contact Details
Company	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contacts Contact Details			Company
Job Title	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details			Job Title
Website	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Work Email	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Home Email	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Work Phone	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contacts Contact Details
Mobile Phone	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Home Phone	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Contact Details
Fax	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Address 1	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Address 2	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
City	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
State	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Postal Code	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Country	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Contact Details
Address Short	Calculated, Text	Calculation: Context table: Contacts Contacts::City & ", " & Contacts::State & " " & Contacts::Postal Code & " " & Contacts::Country Storage: Repetitions: 1 Do not store calculation results Index Language: German		Contacts
Notes	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Contact Details
Result Label Plural	Calculated, Text	Calculation: Context table: Contacts If ( Get ( FoundCount ) = 1 ; "Result" ; "Results" ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Sort Selection	Normal, Text	Auto-Enter: Allow editing Context table: Contacts Calculation: If ( IsEmpty ( Self ) ; "Company" ; Self ) Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Contacts		Trigger \| Sort Contact List
Sort List Key	Calculated, Text	Calculation: Context table: Contacts GetField ( Contacts::Sort Selection ) Storage: Repetitions: 1 Do not store calculation results Index Language: German		Contacts		Trigger \| Sort Contact List
AuditTimeStamp	Normal, Timestamp	Auto-Enter: Modification timestamp Allow editing Validation: Only during data entry Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
AuditState	Normal, Text	Auto-Enter: Allow editing Context table: Guests \| Contacts Calculation: MBS("Audit.Changed2"; Guests \| Contacts::AuditTimeStamp; "Contacts"; "Address 1"; "Address 2"; "CONTACT ID MATCH FIELD"; "City"; "Company"; "Contacts \| MATCH FIELD"; "Country"; "Fax"; "File Name Placeholder"; "First"; "Home Email"; "Home Phone"; "Initial"; "Job Title"; "Last"; "Mobile Phone"; "Notes"; "Photo \| Container"; "Postal Code"; "State"; "Title"; "Website"; "Work Email"; "Work Phone"; "ContactID\|" & Guests \| Contacts::CONTACT ID MATCH FIELD) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German

Table Name: Contributors - 11 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
EVENT ID MATCH FIELD	Normal, Number	Auto-Enter: Allow editing Context table: Contributors Calculation: $$CURRENT_EVENT_ID Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German			Tasks∞Assignees \| Contributors Events=Contributors
Contributor \| MATCH FIELD	Normal, Text	Auto-Enter: Allow editing Context table: Contributors Calculation: If ( IsEmpty ( Self ) ; "New Contributor" ; Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details	Tasks∞Assignees \| Contributors Contributors=Contacts	Add Contributor [+]	Assignees
Email	Normal, Text	Auto-Enter: Allow editing Do not replace existing value for field (if any) Context table: Contributors Calculation: Contacts::Work Email Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details
Phone	Normal, Text	Auto-Enter: Allow editing Do not replace existing value for field (if any) Context table: Contributors Calculation: Contacts::Work Phone Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details
Role	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details			Role
Photo \| Container	Normal, Binary	Auto-Enter: Allow editing Do not replace existing value for field (if any) Context table: Assignees \| Contributors Calculation: Contacts::Photo \| Container Validation: Only during data entry Storage: Repetitions: 1
Photo Placeholder	Calculated, Text	Calculation: Context table: Assignees \| Contributors If ( IsEmpty ( Assignees \| Contributors::Photo \| Container ) ; "Tap to add a photo" ; "" ) Storage: Repetitions: 1 Do not store calculation results Index Language: German
Assignment	Calculated, Text	Calculation: Context table: Assignees \| Contributors If ( Count ( Tasks::EVENT ID MATCH FIELD ) > 0 ; 1 ; 0 ) // 0 = "Not Assigned" // 1 = "Assigned" Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Assignment Status	Calculated, Number	Calculation: Context table: Assignees \| Contributors Choose ( Assignees \| Contributors::Assignment ; "Not Assigned" ; "Assigned" ) // 0 = "Not Assigned" // 1 = "Assigned" Storage: Repetitions: 1 Do not store calculation results Index Language: German
AuditTimeStamp	Normal, Timestamp	Auto-Enter: Modification timestamp Allow editing Validation: Only during data entry Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
AuditState	Normal, Text	Auto-Enter: Allow editing Context table: Assignees \| Contributors Calculation: MBS("Audit.Changed2"; Assignees \| Contributors::AuditTimeStamp; "Contributors"; "Assignment"; "Assignment Status"; "AuditTimeStamp"; "Contributor \| MATCH FIELD"; "Email"; "Phone"; "Photo Placeholder"; "Photo \| Container"; "Role"; "EventID\|" &Assignees \| Contributors::EVENT ID MATCH FIELD) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German

Table Name: Tasks - 12 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
EVENT ID MATCH FIELD	Normal, Number	Auto-Enter: Allow editing Context table: Tasks Calculation: $$CURRENT_EVENT_ID Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German			Events=Tasks Tasks∞Assignees \| Contributors
Task	Normal, Text	Auto-Enter: Constant data: New Task Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details		Add Task [+]
Due Date	Normal, Date	Auto-Enter: Creation date Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Event Details
Assignee \| MATCH FIELD	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details	Tasks∞Assignees \| Contributors
Event	Calculated, Text	Calculation: Context table: Tasks Events::Event Storage: Repetitions: 1 Do not store calculation results Index Language: German
To Do	Calculated, Number	Calculation: Context table: Tasks Tasks::Status Sort Order = 2 Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Overdue	Calculated, Number	Calculation: Context table: Tasks Tasks::Status Sort Order = 0 Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Completed	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Event Details
Status Sort Order	Calculated, Number	Calculation: Context table: Tasks Case ( IsEmpty ( Tasks::EVENT ID MATCH FIELD ) ; "" ; not IsEmpty ( Tasks::Completed ) ; 4 ; IsEmpty ( Tasks::Assignee \| MATCH FIELD ) ; 3 ; Get ( CurrentDate ) < Tasks::Due Date and not IsEmpty ( Tasks::EVENT ID MATCH FIELD ) ; 2 ; Get ( CurrentDate ) > Tasks::Due Date ; 0 ; Get ( CurrentDate ) = Tasks::Due Date ; 1 ) // 0 = "Overdue" // 1 = "Due" // 2 = "To Do" // 3 = "Unassigned" // 4 = "Completed" Storage: Repetitions: 1 Do not store calculation results Index Language: German		Event Details
Status	Calculated, Number	Calculation: Context table: Tasks Choose ( Tasks::Status Sort Order ; "Overdue" ; "Due" ; "To Do" ; "Unassigned" ; "Completed" ) // 0 = "Overdue" // 1 = "Due" // 2 = "To Do" // 3 = "Unassigned" // 4 = "Completed" Storage: Repetitions: 1 Do not store calculation results Index Language: German		Event Details
AuditTimeStamp	Normal, Timestamp	Auto-Enter: Modification timestamp Allow editing Validation: Only during data entry Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
AuditState	Normal, Text	Auto-Enter: Allow editing Context table: Tasks Calculation: MBS("Audit.Changed2"; Tasks::AuditTimeStamp; "Tasks"; "Assignee \| MATCH FIELD"; "Completed"; "Due Date"; "Event"; "Overdue"; "Status"; "Task"; "To Do"; "EventID\|" &Tasks::EVENT ID MATCH FIELD) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German

Table Name: Guests - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
EVENT ID MATCH FIELD	Normal, Number	Auto-Enter: Allow editing Context table: Guests Calculation: $$CURRENT_EVENT_ID Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German			Events=Guests
Guest \| MATCH FIELD	Normal, Text	Auto-Enter: Allow editing Context table: Guests Calculation: If ( IsEmpty ( Self ) ; "New Guest" ; Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details	Guests \| Contacts=Guests	Add Guest [+]
Status	Normal, Text	Auto-Enter: Allow editing Context table: Guests Calculation: If ( IsEmpty ( Self ) ; "Invited" ; Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Event Details
Attending	Calculated, Number	Calculation: Context table: Guests If ( Guests::Status = "Attending" ; 1 ; 0 ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German
Email	Normal, Text	Auto-Enter: Allow editing Do not replace existing value for field (if any) Context table: Guests Calculation: Guests \| Contacts::Work Email Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Event Details
Preferences	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details			Preferences
Photo \| Container	Normal, Binary	Auto-Enter: Allow editing Do not replace existing value for field (if any) Context table: Guests Calculation: Guests \| Contacts::Photo \| Container Validation: Only during data entry Storage: Repetitions: 1
Photo Placeholder	Calculated, Text	Calculation: Context table: Guests If ( IsEmpty ( Guests::Photo \| Container ) ; "Tap to add a photo" ; "" ) Storage: Repetitions: 1 Do not store calculation results Index Language: German
AuditTimeStamp	Normal, Timestamp	Auto-Enter: Modification timestamp Allow editing Validation: Only during data entry Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
AuditState	Normal, Text	Auto-Enter: Allow editing Context table: Guests Calculation: MBS("Audit.Changed2"; Guests::AuditTimeStamp; "Guests"; "Attending"; "Email"; "Guest \| MATCH FIELD"; "Preferences"; "Status"; "EventID\|" &Guests::EVENT ID MATCH FIELD) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German

Table Name: Agenda - 9 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
EVENT ID MATCH FIELD	Normal, Number	Auto-Enter: Allow editing Context table: Agenda Calculation: $$CURRENT_EVENT_ID Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German			Events=Agenda
Agenda Item	Normal, Text	Auto-Enter: Constant data: New Agenda Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details		Add Agenda Item [+]
Date	Normal, Date	Auto-Enter: Allow editing Context table: Agenda Calculation: If ( IsEmpty ( Self ) ; Get ( CurrentDate ) ; Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Event Details
Explanation	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Event Details
Time	Normal, Time	Auto-Enter: Value from last visited record Allow editing Context table: Agenda Calculation: If ( IsEmpty ( Self ) ; Get ( CurrentTime ) ; Self ) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Event Details
Time Frame Order	Calculated, Number	Calculation: Context table: Agenda If ( Agenda::Date < Get ( CurrentDate ) ; 0 ; 1 ) // Past = 0 // Current = 1 Storage: Repetitions: 1 Do not store calculation results Index Language: German		Event Details
Time Frame	Calculated, Text	Calculation: Context table: Agenda Choose ( Agenda::Time Frame Order ; "Past"; "Current" ) // Past = 0 // Current = 1 Storage: Repetitions: 1 Do not store calculation results Index Language: German
AuditTimeStamp	Normal, Timestamp	Auto-Enter: Modification timestamp Allow editing Validation: Only during data entry Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
AuditState	Normal, Text	Auto-Enter: Allow editing Context table: Agenda Calculation: MBS("Audit.Changed2"; Agenda::AuditTimeStamp; "Agenda"; "Agenda Item"; "Date"; "Explanation"; "Time"; "EventID\|" &Agenda::EVENT ID MATCH FIELD) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German

Relationship: Events=Guests

Table Occurrence	Events		Guests
Field	EVENT ID MATCH FIELD	=	EVENT ID MATCH FIELD
Source Table	Events		Guests
Source File	Event Management with Audit.fmp12		Event Management with Audit.fmp12
Allow creation of records via this relationship	Off		On
Delete related records in this table when a record is deleted in the other table	Off		On
Sort records	Off		Off

Relationship: Events=Agenda

Table Occurrence	Events		Agenda
Field	EVENT ID MATCH FIELD	=	EVENT ID MATCH FIELD
Source Table	Events		Agenda
Source File	Event Management with Audit.fmp12		Event Management with Audit.fmp12
Allow creation of records via this relationship	Off		On
Delete related records in this table when a record is deleted in the other table	Off		On
Sort records	Off		Off

Relationship: Tasks∞Assignees | Contributors

Table Occurrence	Tasks		Assignees \| Contributors
Field	Assignee \| MATCH FIELD	=	Contributor \| MATCH FIELD
and	EVENT ID MATCH FIELD	=	EVENT ID MATCH FIELD
Source Table	Tasks		Contributors
Source File	Event Management with Audit.fmp12		Event Management with Audit.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: Guests | Contacts=Guests

Table Occurrence	Guests \| Contacts		Guests
Field	Contacts \| MATCH FIELD	=	Guest \| MATCH FIELD
Source Table	Contacts		Guests
Source File	Event Management with Audit.fmp12		Event Management with Audit.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: Events=Contributors

Table Occurrence	Events		Contributors
Field	EVENT ID MATCH FIELD	=	EVENT ID MATCH FIELD
Source Table	Events		Contributors
Source File	Event Management with Audit.fmp12		Event Management with Audit.fmp12
Allow creation of records via this relationship	Off		On
Delete related records in this table when a record is deleted in the other table	Off		On
Sort records	Off		Off

Relationship: Contributors=Contacts

Table Occurrence	Contributors		Contacts
Field	Contributor \| MATCH FIELD	=	Contacts \| MATCH FIELD
Source Table	Contributors		Contacts
Source File	Event Management with Audit.fmp12		Event Management with Audit.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: Venue Looked Up=Events

Table Occurrence	Venue Looked Up		Events
Field	Venue	=	Venue
Source Table	Events		Events
Source File	Event Management with Audit.fmp12		Event Management with Audit.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: Events=AuditLog

Table Occurrence	Events		AuditLog
Field	EVENT ID MATCH FIELD	=	EventID
Source Table	Events		AuditLog
Source File	Event Management with Audit.fmp12		Data Source: Event Management AuditLog
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Layout Hierarchy

Save record changes automatically

Show field frames when record is active

Show field frames only on current record

Show current record indicator in List View

7 Regular Fields
1 Merge Fields
3 Group Buttons
2 Graphic Objects

Events

Off

Trigger | On First Window Open

[File Default]

OnLayoutEnter

Script: Trigger | Sort Event List
Modes: Browse

OnRecordLoad

Script: Trigger | Create Event in List
Modes: Browse

Event Details

Yes

36 Regular Fields
1 Merge Fields
7 Group Buttons
13 Buttons
5 Portals
1 Tab Controls
7 Graphic Objects
1 Web Viewer Controls

Events

Off

Trigger | Create Event in List

Events

8 Regular Fields
2 Merge Fields
3 Group Buttons
2 Graphic Objects

Contacts

Off

[File Default]

OnLayoutEnter

Script: Trigger | Sort Contact List
Modes: Browse

OnRecordLoad

Script: Trigger | Create Contact in List
Modes: Browse

Contact Details

Yes

26 Regular Fields
3 Merge Fields
1 Group Buttons
5 Buttons
1 Portals

Contacts

Off

Trigger | Create Contact in List

[File Default]

Layout Objects: Events

Regular Fields

Field Name: Events::Sort Selection

Layout Name:

Events

OnObjectValidate

Script: Trigger | Sort Event List
Modes: Browse

Top: 29 pt
Left: 185 pt
Bottom: 53 pt
Right: 343 pt

Anchoring: Left, Top

Field Format:

Pop-up Menu
Display values from: Event List | Sort Selection

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: Events::Event

Layout Name:

Events

Top: 104 pt
Left: 185 pt
Bottom: 126 pt
Right: 513 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Yes

Field Name: Events::Type

Layout Name:

Events

Top: 104 pt
Left: 516 pt
Bottom: 126 pt
Right: 660 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Yes

Field Name: Events::Venue

Layout Name:

Events

Top: 104 pt
Left: 663 pt
Bottom: 126 pt
Right: 861 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Yes

Field Name: Events::Date

Layout Name:

Events

Top: 104 pt
Left: 61 pt
Bottom: 126 pt
Right: 182 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Yes

Field Name: Events::Layout Selector

Layout Name:

Events

OnObjectModify

Script: Trigger | Layout Selection
Modes: Browse, Find

Top: 22 pt
Left: 19 pt
Bottom: 60 pt
Right: 170 pt

Anchoring: Left, Top

Field Format:

Pop-up Menu
Display values from: Layout Selector

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Field Name: Events::Sort List Key

Layout Name:

Events

Visibility:

Only visible in Table View

Top: 37 pt
Left: 0 pt
Bottom: 54 pt
Right: 75 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

Text:

<<Sort List Key>>

Layout Name:

Events

Top: 71 pt
Left: 33 pt
Bottom: 90 pt
Right: 568 pt

Anchoring: Left, Top

Events::Sort List Key

Type:

Layout Name:

Events

Additional Properties:

Change to hand cursor over button

Top: 95 pt
Left: 19 pt
Bottom: 135 pt
Right: 881 pt

Anchoring: Left and Right, Top

Go to Layout [ “Event Details” (Events) ]

Layouts:

Event Details

Button Properties

Coordinates

Script/Script Step

Type:

Rounded Rectangle

Layout Name:

Events

Tooltip:

"Import records from other file"

Additional Properties:

Rounded

Top: 29 pt
Left: 807 pt
Bottom: 53 pt
Right: 831 pt

Anchoring: Right, Top

Type:

Rounded Rectangle

Layout Name:

Events

Tooltip:

"Export current found records"

Additional Properties:

Rounded

Top: 29 pt
Left: 837 pt
Bottom: 53 pt
Right: 861 pt

Anchoring: Right, Top

Export Records [ ]

Graphic Objects

Graphic Object Properties

Coordinates

Type:

Rounded Rectangle

Layout Name:

Events

Tooltip:

"Import records from other file"

Top: 29 pt
Left: 807 pt
Bottom: 53 pt
Right: 831 pt

Anchoring: Right, Top

Graphic Object Properties

Coordinates

Type:

Rounded Rectangle

Layout Name:

Events

Tooltip:

"Export current found records"

Top: 29 pt
Left: 837 pt
Bottom: 53 pt
Right: 861 pt

Anchoring: Right, Top

Layout Objects: Event Details

Regular Fields

Field Name: Tasks::Task

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 353 pt
Bottom: 186 pt
Right: 478 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Tasks::Status Sort Order = 0	self:normal .self { color: rgba(60.3922%,20%,4.70588%,1); }
2.	Formula: Tasks::Status Sort Order = 1	self:normal .self { color: rgba(92.1489%,61.3831%,25.7717%,1); }
3.	Formula: Tasks::Status Sort Order = 4	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); }

Field Name: Tasks::Due Date

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 613 pt
Bottom: 186 pt
Right: 715 pt

Anchoring: Right, Top

Field Format:

Drop-down Calendar

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Tasks::Status Sort Order = 0	self:normal .self { color: rgba(60.3922%,20%,4.70588%,1); }
2.	Formula: Tasks::Status Sort Order = 1	self:normal .self { color: rgba(92.1489%,61.3831%,25.7717%,1); }
3.	Formula: Tasks::Status Sort Order = 4	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); }

Field Name: Tasks::Assignee | MATCH FIELD

Layout Name:

Event Details

Visibility:

Not visible in Table View

Tooltip:

"Based on contributor list below"

Top: 164 pt
Left: 478 pt
Bottom: 186 pt
Right: 613 pt

Anchoring: Right, Top

Field Format:

Drop-down List
Display values from: Assignees
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Tasks::Status Sort Order = 0	self:normal .self { color: rgba(60.3922%,20%,4.70588%,1); }
2.	Formula: Tasks::Status Sort Order = 1	self:normal .self { color: rgba(92.1489%,61.3831%,25.7717%,1); }
3.	Formula: Tasks::Status Sort Order = 4	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); }

Field Name: Tasks::Completed

Layout Name:

Event Details

Visibility:

Not visible in Table View

Tooltip:

"Completed"

Top: 166 pt
Left: 328 pt
Bottom: 184 pt
Right: 345 pt

Anchoring: Left, Top

Field Format:

Checkbox Set
Display values from: Boolean

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Tasks::Status

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 715 pt
Bottom: 186 pt
Right: 812 pt

Anchoring: Right, Top

Field Format:

Drop-down List
Display values from: Status | Tasks

Field Behavior:

Allow field to be entered: In Find mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Tasks::Status Sort Order = 0	self:normal .self { color: rgba(60.3922%,20%,4.70588%,1); }
2.	Formula: Tasks::Status Sort Order = 1	self:normal .self { color: rgba(92.1489%,61.3831%,25.7717%,1); }
3.	Formula: Tasks::Status Sort Order = 4	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); }

Field Name: Guests::Preferences

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 602 pt
Bottom: 186 pt
Right: 676 pt

Anchoring: Left and Right, Top

Field Format:

Drop-down List
Display values from: Preferences
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Guests::Status = "Not Attending"	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); }
2.	Formula: Guests::Status = "No Response"	self:normal .self { color: rgba(77.2549%,49.8039%,22.7451%,1); }

Field Name: Guests::Guest | MATCH FIELD

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 319 pt
Bottom: 186 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Drop-down List
Display values from: Contacts
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Guests::Status = "Not Attending"	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); }
2.	Formula: Guests::Status = "No Response"	self:normal .self { color: rgba(77.2549%,49.8039%,22.7451%,1); }

Field Name: Guests::Email

Layout Name:

Event Details

Top: 164 pt
Left: 455 pt
Bottom: 186 pt
Right: 602 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Guests::Status = "Not Attending"	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); }
2.	Formula: Guests::Status = "No Response"	self:normal .self { color: rgba(77.2549%,49.8039%,22.7451%,1); }

Field Name: Guests::Status

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 676 pt
Bottom: 186 pt
Right: 811 pt

Anchoring: Right, Top

Field Format:

Pop-up Menu
Display values from: Status | Guest

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Guests::Status = "Not Attending"	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); }
2.	Formula: Guests::Status = "No Response"	self:normal .self { color: rgba(77.2549%,49.8039%,22.7451%,1); }

Field Name: Agenda::Agenda Item

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 319 pt
Bottom: 186 pt
Right: 493 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Agenda::Time Frame Order = 0	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); box-shadow: none; }

Field Name: Agenda::Date

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 492 pt
Bottom: 186 pt
Right: 598 pt

Anchoring: Left, Top

Field Format:

Drop-down Calendar
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Agenda::Time Frame Order = 0	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); box-shadow: none; }

Field Name: Agenda::Time

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 598 pt
Bottom: 186 pt
Right: 686 pt

Anchoring: Left, Top

Field Format:

Drop-down List
Display values from: Time [Meridiem]
Include "Edit..." item to allow editing of value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Agenda::Time Frame Order = 0	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); box-shadow: none; }

Field Name: Agenda::Explanation

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 164 pt
Left: 686 pt
Bottom: 186 pt
Right: 812 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Conditional Formatting	Condition	Format
1.	Formula: Agenda::Time Frame Order = 0	self:normal .self { color: rgba(60.3922%,60.3922%,60.3922%,1); box-shadow: none; }

Field Name: Events::Notes

Layout Name:

Event Details

Top: 160 pt
Left: 318 pt
Bottom: 274 pt
Right: 863 pt

Anchoring: Left and Right, Top and Bottom

Field Format:

Edit Box
Include vertical scrollbar

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Enter key

Yes

Field Name: Events::Type

Layout Name:

Event Details

Top: 71 pt
Left: 667 pt
Bottom: 92 pt
Right: 864 pt

Anchoring: Right, Top

Field Format:

Pop-up Menu
Display values from: Type
Include "Edit..." item to allow editing of value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contributors::Email

Layout Name:

Event Details

Top: 364 pt
Left: 536 pt
Bottom: 386 pt
Right: 683 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contributors::Contributor | MATCH FIELD

Layout Name:

Event Details

Top: 364 pt
Left: 353 pt
Bottom: 386 pt
Right: 536 pt

Anchoring: Left, Top

Field Format:

Drop-down List
Display values from: Contacts
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contributors::Phone

Layout Name:

Event Details

Top: 364 pt
Left: 683 pt
Bottom: 386 pt
Right: 812 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contributors::Role

Layout Name:

Event Details

Visibility:

Not visible in Table View

Tooltip:

"Role"

Top: 388 pt
Left: 353 pt
Bottom: 410 pt
Right: 812 pt

Anchoring: Left and Right, Top

Field Format:

Drop-down List
Display values from: Role
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Venue

Layout Name:

Event Details

Top: 172 pt
Left: 36 pt
Bottom: 194 pt
Right: 300 pt

Anchoring: Left, Top

Field Format:

Drop-down List
Display values from: Venue
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Description

Layout Name:

Event Details

Top: 258 pt
Left: 36 pt
Bottom: 280 pt
Right: 300 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Enter key

Yes

Field Name: Events::Address

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 302 pt
Left: 36 pt
Bottom: 324 pt
Right: 300 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Enter key

Yes

Field Name: Events::City

Layout Name:

Event Details

Top: 346 pt
Left: 36 pt
Bottom: 368 pt
Right: 171 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::State

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 346 pt
Left: 171 pt
Bottom: 368 pt
Right: 300 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Postal Code

Layout Name:

Event Details

Visibility:

Not visible in Table View

Top: 390 pt
Left: 36 pt
Bottom: 412 pt
Right: 171 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Country

Layout Name:

Event Details

Top: 390 pt
Left: 171 pt
Bottom: 412 pt
Right: 300 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Event

Layout Name:

Event Details

Top: 128 pt
Left: 36 pt
Bottom: 150 pt
Right: 300 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Date

Layout Name:

Event Details

Top: 214 pt
Left: 36 pt
Bottom: 236 pt
Right: 300 pt

Anchoring: Left, Top

Field Format:

Drop-down Calendar

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Enter key

Yes

Field Name: Events::Phone

Layout Name:

Event Details

Top: 434 pt
Left: 36 pt
Bottom: 456 pt
Right: 171 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Email

Layout Name:

Event Details

Top: 434 pt
Left: 171 pt
Bottom: 456 pt
Right: 300 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: AuditLog::FieldName

Layout Name:

Event Details

Top: 619 pt
Left: 41 pt
Bottom: 640 pt
Right: 179 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

Layout Name:

Event Details

Top: 619 pt
Left: 188 pt
Bottom: 640 pt
Right: 326 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

Layout Name:

Event Details

Top: 619 pt
Left: 335 pt
Bottom: 640 pt
Right: 464 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

Layout Name:

Event Details

Top: 619 pt
Left: 473 pt
Bottom: 640 pt
Right: 589 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

Layout Name:

Event Details

Top: 619 pt
Left: 599 pt
Bottom: 640 pt
Right: 713 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

Layout Name:

Event Details

Top: 619 pt
Left: 721 pt
Bottom: 640 pt
Right: 859 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

Text:

<<Event>>

Layout Name:

Event Details

Top: 66 pt
Left: 36 pt
Bottom: 97 pt
Right: 531 pt

Anchoring: Left and Right, Top

Events::Event

Type:

Layout Name:

Event Details

Tooltip:

"Remove " & Tasks::Task

Top: 168 pt
Left: 822 pt
Bottom: 183 pt
Right: 837 pt

Anchoring: Right, Top

Perform Script [ “Remove Event Item [Get Script Parameter]”; Parameter: Tasks::Task ]

Scripts:

Remove Event Item [Get Script Parameter]

Fields:

Tasks::Task

Button Properties

Coordinates

Script/Script Step

Type:

Layout Name:

Event Details

Tooltip:

"Send message to " & Guests::Guest | MATCH FIELD & ¶ & Guests::Email

Top: 168 pt
Left: 463 pt
Bottom: 182 pt
Right: 477 pt

Anchoring: Left, Top

Send Mail [ Send via E-mail Client; To: Guests::Guest | MATCH FIELD & " <" & Guests::Email & ">"; Subject: Events::Event; Message: "Dear " & Guests::Guest | MATCH FIELD & ",¶¶" ]

Fields:

Guests::Guest | MATCH FIELD
Guests::Email
Events::Event
Guests::Guest | MATCH FIELD

Button Properties

Coordinates

Script/Script Step

Type:

Layout Name:

Event Details

Tooltip:

"Remove " & Guests::Guest | MATCH FIELD

Top: 168 pt
Left: 822 pt
Bottom: 183 pt
Right: 837 pt

Anchoring: Right, Top

Perform Script [ “Remove Event Item [Get Script Parameter]”; Parameter: Guests::Guest | MATCH FIELD ]

Scripts:

Remove Event Item [Get Script Parameter]

Fields:

Guests::Guest | MATCH FIELD

Button Properties

Coordinates

Script/Script Step

Type:

Layout Name:

Event Details

Tooltip:

"Remove " & Agenda::Agenda Item

Top: 168 pt
Left: 822 pt
Bottom: 183 pt
Right: 837 pt

Anchoring: Right, Top

Perform Script [ “Remove Event Item [Get Script Parameter]”; Parameter: Agenda::Agenda Item ]

Scripts:

Remove Event Item [Get Script Parameter]

Fields:

Agenda::Agenda Item

Button Properties

Coordinates

Script/Script Step

Type:

Layout Name:

Event Details

Tooltip:

"Send message to " & Contributors::Contributor | MATCH FIELD & ¶ & Contributors::Email

Top: 368 pt
Left: 545 pt
Bottom: 382 pt
Right: 559 pt

Anchoring: Left, Top

Send Mail [ Send via E-mail Client; To: Contributors::Contributor | MATCH FIELD & " <" & Contributors::Email & ">"; Message: "Dear " & Contributors::Contributor | MATCH FIELD & ",¶¶" ]

Fields:

Contributors::Contributor | MATCH FIELD
Contributors::Email
Contributors::Contributor | MATCH FIELD

Button Properties

Coordinates

Script/Script Step

Type:

Layout Name:

Event Details

Tooltip:

Case ( IsEmpty ( Contributors::Contributor | MATCH FIELD ) ; "" ; IsEmpty ( Contacts::Contacts | MATCH FIELD ) ; "This contributor is not in the contact list" ; "Go to Contact " & Contributors::Contributor | MATCH FIELD )

Top: 379 pt
Left: 329 pt
Bottom: 393 pt
Right: 343 pt

Anchoring: Left, Top

Layouts:

Contact Details

Button Properties

Coordinates

Script/Script Step

Type:

Layout Name:

Event Details

Tooltip:

"Remove " & Contributors::Contributor | MATCH FIELD

Top: 379 pt
Left: 823 pt
Bottom: 394 pt
Right: 838 pt

Anchoring: Right, Top

Perform Script [ “Remove Event Item [Get Script Parameter]”; Parameter: Contributors::Contributor | MATCH FIELD ]

Scripts:

Remove Event Item [Get Script Parameter]

Fields:

Contributors::Contributor | MATCH FIELD

Type:

Text: Add Contributor

Layout Name:

Event Details

Top: 577 pt
Left: 326 pt
Bottom: 601 pt
Right: 458 pt

Anchoring: Left, Bottom

Perform Script [ “Add Contributor [+]” ]

Scripts:

Add Contributor [+]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Print Contributor List

Layout Name:

Event Details

Top: 577 pt
Left: 697 pt
Bottom: 601 pt
Right: 852 pt

Anchoring: Right, Bottom

Perform Script [ “<unknown>” ]

Scripts:

<unknown>

Button Properties

Coordinates

Script/Script Step

Type:

Text: Add Task

Layout Name:

Event Details

Top: 278 pt
Left: 326 pt
Bottom: 302 pt
Right: 425 pt

Anchoring: Left, Bottom

Perform Script [ “Add Task [+]” ]

Scripts:

Add Task [+]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Print Task List

Layout Name:

Event Details

Top: 278 pt
Left: 723 pt
Bottom: 302 pt
Right: 852 pt

Anchoring: Right, Bottom

Perform Script [ “<unknown>” ]

Scripts:

<unknown>

Button Properties

Coordinates

Script/Script Step

Type:

Text: Print Guest Badge

Layout Name:

Event Details

Top: 278 pt
Left: 571 pt
Bottom: 302 pt
Right: 717 pt

Anchoring: Right, Bottom

Perform Script [ “<unknown>” ]

Scripts:

<unknown>

Button Properties

Coordinates

Script/Script Step

Type:

Text: Print Guest List

Layout Name:

Event Details

Top: 278 pt
Left: 723 pt
Bottom: 302 pt
Right: 852 pt

Anchoring: Right, Bottom

Perform Script [ “<unknown>” ]

Scripts:

<unknown>

Button Properties

Coordinates

Script/Script Step

Type:

Text: Add Guest

Layout Name:

Event Details

Top: 278 pt
Left: 326 pt
Bottom: 302 pt
Right: 425 pt

Anchoring: Left, Bottom

Perform Script [ “Add Guest [+]” ]

Scripts:

Add Guest [+]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Add Agenda Item

Layout Name:

Event Details

Top: 278 pt
Left: 326 pt
Bottom: 302 pt
Right: 472 pt

Anchoring: Left, Bottom

Perform Script [ “Add Agenda Item [+]” ]

Scripts:

Add Agenda Item [+]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Send to Guests

Layout Name:

Event Details

Tooltip:

"Only \"Attending\" guest receives Agenda by E-mail"

Top: 278 pt
Left: 598 pt
Bottom: 302 pt
Right: 727 pt

Anchoring: Right, Bottom

Perform Script [ “<unknown>” ]

Scripts:

<unknown>

Button Properties

Coordinates

Script/Script Step

Type:

Text: Print Agenda

Layout Name:

Event Details

Top: 278 pt
Left: 735 pt
Bottom: 302 pt
Right: 852 pt

Anchoring: Right, Bottom

Perform Script [ “<unknown>” ]

Scripts:

<unknown>

Button Properties

Coordinates

Script/Script Step

Type:

Text: Event List

Layout Name:

Event Details

Top: 29 pt
Left: 36 pt
Bottom: 53 pt
Right: 150 pt

Anchoring: Left, Top

Go to Layout [ “Events” (Events) ]

Layouts:

Events

Button Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

Event Details

Top: 412 pt
Left: 275 pt
Bottom: 434 pt
Right: 300 pt

Anchoring: Left, Top

Send Mail [ Send via E-mail Client; To: Events::Email; Subject: Events::Venue ]

Fields:

Events::Email
Events::Venue

Button Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

Event Details

Top: 280 pt
Left: 275 pt
Bottom: 302 pt
Right: 300 pt

Anchoring: Left, Top

Open URL [ "http://local.google.com/maps?" & "q=" & Events::Address & ", " & Events::City & ", " & Events::State & ", " & Events::Postal Code & ", " & Events::Country ] [ No dialog ]

Fields:

Events::Address
Events::City
Events::State
Events::Postal Code
Events::Country

Table:

Tasks

Layout Name:

Event Details

Top: 160 pt
Left: 318 pt
Bottom: 274 pt
Right: 863 pt

Anchoring: Left and Right, Top and Bottom

Field Objects

Tasks::Task at (164, 353, 186, 478)
Tasks::Due Date at (164, 613, 186, 715)
Tasks::Assignee | MATCH FIELD at (164, 478, 186, 613)
Tasks::Completed at (166, 328, 184, 345)
Tasks::Status at (164, 715, 186, 812)

Sort records: On
Field: Status Sort Order
- Ascending order
- Reorder based on summary field: Off
- Override field's language for sort: Off
Field: Due Date
- Ascending order
- Reorder based on summary field: Off
- Override field's language for sort: Off

Filter calculation: None
Initial Row: 1
Number of Rows: 4
Show vertical scroll bar

Table:

Guests

Layout Name:

Event Details

Top: 160 pt
Left: 318 pt
Bottom: 274 pt
Right: 863 pt

Anchoring: Left and Right, Top and Bottom

Field Objects

Guests::Preferences at (164, 602, 186, 676)
Guests::Guest | MATCH FIELD at (164, 319, 186, 455)
Guests::Email at (164, 455, 186, 602)
Guests::Status at (164, 676, 186, 811)

Sort records: On
Field: Status
- Custom order based on value list: Status | Guest
- Reorder based on summary field: Off
- Override field's language for sort: Off
Field: Guest | MATCH FIELD
- Ascending order
- Reorder based on summary field: Off
- Override field's language for sort: Off

Filter calculation: None
Initial Row: 1
Number of Rows: 4
Show vertical scroll bar

Table:

Agenda

Layout Name:

Event Details

Top: 160 pt
Left: 318 pt
Bottom: 274 pt
Right: 863 pt

Anchoring: Left and Right, Top and Bottom

Field Objects

Agenda::Agenda Item at (164, 319, 186, 493)
Agenda::Date at (164, 492, 186, 598)
Agenda::Time at (164, 598, 186, 686)
Agenda::Explanation at (164, 686, 186, 812)

Sort records: On
Field: Date
- Descending order
- Reorder based on summary field: Off
- Override field's language for sort: Off
Field: Time
- Ascending order
- Reorder based on summary field: Off
- Override field's language for sort: Off

Filter calculation: None
Initial Row: 1
Number of Rows: 4
Show vertical scroll bar

Table:

Contributors

Layout Name:

Event Details

Top: 360 pt
Left: 317 pt
Bottom: 573 pt
Right: 864 pt

Anchoring: Left and Right, Bottom

Field Objects

Contributors::Email at (364, 536, 386, 683)
Contributors::Contributor | MATCH FIELD at (364, 353, 386, 536)
Contributors::Phone at (364, 683, 386, 812)
Contributors::Role at (388, 353, 410, 812)

Sort records: On
Field: Contributor | MATCH FIELD
- Ascending order
- Reorder based on summary field: Off
- Override field's language for sort: Off

Filter calculation: None
Initial Row: 1
Number of Rows: 4
Show vertical scroll bar

Table:

AuditLog

Layout Name:

Event Details

Top: 615 pt
Left: 36 pt
Bottom: 725 pt
Right: 863 pt

Anchoring: Left and Right, Bottom

Field Objects

AuditLog::FieldName at (619, 41, 640, 179)
AuditLog::FieldValue at (619, 188, 640, 326)
AuditLog::UserName at (619, 335, 640, 464)
AuditLog::TimeStamp at (619, 473, 640, 589)
AuditLog::AccountName at (619, 599, 640, 713)
AuditLog::FieldOldValue at (619, 721, 640, 859)

Sort records: On
Field: TimeStamp
- Descending order
- Reorder based on summary field: Off
- Override field's language for sort: Off

Filter calculation:
AuditLog::Action = "Change"

Initial Row: 1
Number of Rows: 4
Show vertical scroll bar
Reset scroll bar when exiting record

Tab Controls

Tab Control Properties				Coordinates
Layout Name: Event Details Justification: Full Tab Width: Label Width Default Front Tab: Tab 0				Top: 104 pt Left: 317 pt Bottom: 308 pt Right: 864 pt Anchoring: Left and Right, Top and Bottom
Tabs
Tab Properties	Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
Tab 0: "Tasks"			Field Objects Tasks::Task at (164, 353, 186, 478) Tasks::Due Date at (164, 613, 186, 715) Tasks::Assignee \| MATCH FIELD at (164, 478, 186, 613) Tasks::Completed at (166, 328, 184, 345) Tasks::Status at (164, 715, 186, 812)	Text: Add Task-->Perform Script [ “Add Task [+]” ] at (278, 326, 302, 425) Text: Print Task List-->Perform Script [ “<unknown>” ] at (278, 723, 302, 852)	Portal Object at (160, 318, 274, 863)

Tab 1: "Guests"			Field Objects Guests::Preferences at (164, 602, 186, 676) Guests::Guest \| MATCH FIELD at (164, 319, 186, 455) Guests::Email at (164, 455, 186, 602) Guests::Status at (164, 676, 186, 811)	Text: Print Guest Badge-->Perform Script [ “<unknown>” ] at (278, 571, 302, 717) Text: Print Guest List-->Perform Script [ “<unknown>” ] at (278, 723, 302, 852) Text: Add Guest-->Perform Script [ “Add Guest [+]” ] at (278, 326, 302, 425)	Portal Object at (160, 318, 274, 863)

Tab 2: "Agenda"			Field Objects Agenda::Agenda Item at (164, 319, 186, 493) Agenda::Date at (164, 492, 186, 598) Agenda::Time at (164, 598, 186, 686) Agenda::Explanation at (164, 686, 186, 812)	Text: Add Agenda Item-->Perform Script [ “Add Agenda Item [+]” ] at (278, 326, 302, 472) Text: Send to Guests-->Perform Script [ “<unknown>” ] at (278, 598, 302, 727) Text: Print Agenda-->Perform Script [ “<unknown>” ] at (278, 735, 302, 852)	Portal Object at (160, 318, 274, 863)

Tab 3: "Notes"			Field Objects Events::Notes at (160, 318, 274, 863)

Graphic Objects

Graphic Object Properties

Coordinates

Type:

Graphic

Layout Name:

Event Details

Tooltip:

"Remove " & Tasks::Task

Top: 168 pt
Left: 822 pt
Bottom: 183 pt
Right: 837 pt

Anchoring: Right, Top

Graphic Object Properties

Coordinates

Type:

Graphic

Layout Name:

Event Details

Tooltip:

"Send message to " & Guests::Guest | MATCH FIELD & ¶ & Guests::Email

Top: 168 pt
Left: 463 pt
Bottom: 182 pt
Right: 477 pt

Anchoring: Left, Top

Graphic Object Properties

Coordinates

Type:

Graphic

Layout Name:

Event Details

Tooltip:

"Remove " & Guests::Guest | MATCH FIELD

Top: 168 pt
Left: 822 pt
Bottom: 183 pt
Right: 837 pt

Anchoring: Right, Top

Graphic Object Properties

Coordinates

Type:

Graphic

Layout Name:

Event Details

Tooltip:

"Remove " & Agenda::Agenda Item

Top: 168 pt
Left: 822 pt
Bottom: 183 pt
Right: 837 pt

Anchoring: Right, Top

Graphic Object Properties

Coordinates

Type:

Graphic

Layout Name:

Event Details

Tooltip:

"Send message to " & Contributors::Contributor | MATCH FIELD & ¶ & Contributors::Email

Top: 368 pt
Left: 545 pt
Bottom: 382 pt
Right: 559 pt

Anchoring: Left, Top

Graphic Object Properties

Coordinates

Type:

Graphic

Layout Name:

Event Details

Tooltip:

Case ( IsEmpty ( Contributors::Contributor | MATCH FIELD ) ; "" ; IsEmpty ( Contacts::Contacts | MATCH FIELD ) ; "This contributor is not in the contact list" ; "Go to Contact " & Contributors::Contributor | MATCH FIELD )

Top: 379 pt
Left: 329 pt
Bottom: 393 pt
Right: 343 pt

Anchoring: Left, Top

Graphic Object Properties

Coordinates

Type:

Graphic

Layout Name:

Event Details

Tooltip:

"Remove " & Contributors::Contributor | MATCH FIELD

Top: 379 pt
Left: 823 pt
Bottom: 394 pt
Right: 838 pt

Anchoring: Right, Top

Web Viewer Controls

Web Viewer Control Properties

Coordinates

Web Address

Object Name:

Layout Name:

Event Details

Additional Properties:

Automatically encode URL

Top: 456 pt
Left: 36 pt
Bottom: 606 pt
Right: 300 pt

Anchoring: Left, Top and Bottom

GetMapSizeAuto ( "Map" ; 12 ; Events::Address ; Events::City ; Events::State ; Events::Postal Code ; Events::Country )

Layout Objects: -

Layout Objects: Contacts

Regular Fields

Field Name: Contacts::Sort Selection

Layout Name:

Contacts

OnObjectValidate

Script: Trigger | Sort Contact List
Modes: Browse

Top: 29 pt
Left: 185 pt
Bottom: 53 pt
Right: 343 pt

Anchoring: Left, Top

Field Format:

Pop-up Menu
Display values from: Contact List | Sort Selection

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: Contacts::Company

Layout Name:

Contacts

Top: 137 pt
Left: 212 pt
Bottom: 159 pt
Right: 413 pt

Anchoring: Left, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Yes

Field Name: Contacts::Address Short

Layout Name:

Contacts

Top: 137 pt
Left: 415 pt
Bottom: 159 pt
Right: 704 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Yes

Field Name: Contacts::Work Phone

Layout Name:

Contacts

Top: 137 pt
Left: 706 pt
Bottom: 159 pt
Right: 861 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Yes

Field Name: Contacts::Contacts | MATCH FIELD

Layout Name:

Contacts

Top: 137 pt
Left: 61 pt
Bottom: 159 pt
Right: 210 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Yes

Field Name: Events::Layout Selector

Layout Name:

Contacts

OnObjectModify

Script: Trigger | Layout Selection
Modes: Browse, Find

Top: 22 pt
Left: 19 pt
Bottom: 60 pt
Right: 170 pt

Anchoring: Left, Top

Field Format:

Pop-up Menu
Display values from: Layout Selector

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Field Name: Contacts::Initial

Layout Name:

Contacts

Visibility:

Only visible in Table View

Top: 37 pt
Left: 0 pt
Bottom: 54 pt
Right: 120 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

Field Name: Contacts::Sort List Key

Layout Name:

Contacts

Visibility:

Only visible in Table View

Top: 71 pt
Left: 0 pt
Bottom: 88 pt
Right: 120 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

Text:

<<Sort List Key>>

Layout Name:

Contacts

Top: 103 pt
Left: 33 pt
Bottom: 122 pt
Right: 568 pt

Anchoring: Left, Top

Contacts::Sort List Key

Text:

<<Initial>>

Layout Name:

Contacts

Top: 70 pt
Left: 33 pt
Bottom: 91 pt
Right: 260 pt

Anchoring: Left, Top

Contacts::Initial

Type:

Layout Name:

Contacts

Additional Properties:

Change to hand cursor over button

Top: 128 pt
Left: 19 pt
Bottom: 168 pt
Right: 881 pt

Anchoring: Left and Right, Top

Go to Layout [ “Contact Details” (Contacts) ]

Layouts:

Contact Details

Button Properties

Coordinates

Script/Script Step

Type:

Rounded Rectangle

Layout Name:

Contacts

Tooltip:

"Import records from other file"

Additional Properties:

Rounded

Top: 29 pt
Left: 807 pt
Bottom: 53 pt
Right: 831 pt

Anchoring: Right, Top

Type:

Rounded Rectangle

Layout Name:

Contacts

Tooltip:

"Export current found records"

Additional Properties:

Rounded

Top: 29 pt
Left: 837 pt
Bottom: 53 pt
Right: 861 pt

Anchoring: Right, Top

Export Records [ ]

Graphic Objects

Graphic Object Properties

Coordinates

Type:

Rounded Rectangle

Layout Name:

Contacts

Tooltip:

"Import records from other file"

Top: 29 pt
Left: 807 pt
Bottom: 53 pt
Right: 831 pt

Anchoring: Right, Top

Graphic Object Properties

Coordinates

Type:

Rounded Rectangle

Layout Name:

Contacts

Tooltip:

"Export current found records"

Top: 29 pt
Left: 837 pt
Bottom: 53 pt
Right: 861 pt

Anchoring: Right, Top

Layout Objects: Contact Details

Regular Fields

Field Name: Events::Event

Layout Name:

Contact Details

Top: 464 pt
Left: 80 pt
Bottom: 486 pt
Right: 301 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Date

Layout Name:

Contact Details

Top: 464 pt
Left: 301 pt
Bottom: 486 pt
Right: 413 pt

Anchoring: Left, Top

Field Format:

Drop-down Calendar

Field Behavior:

Allow field to be entered: In Find mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Venue

Layout Name:

Contact Details

Top: 464 pt
Left: 413 pt
Bottom: 486 pt
Right: 561 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::City

Layout Name:

Contact Details

Top: 464 pt
Left: 561 pt
Bottom: 486 pt
Right: 709 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Events::Description

Layout Name:

Contact Details

Top: 464 pt
Left: 709 pt
Bottom: 486 pt
Right: 846 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Address 1

Layout Name:

Contact Details

Top: 110 pt
Left: 583 pt
Bottom: 132 pt
Right: 840 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Address 2

Layout Name:

Contact Details

Top: 132 pt
Left: 583 pt
Bottom: 154 pt
Right: 865 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::City

Layout Name:

Contact Details

Top: 154 pt
Left: 583 pt
Bottom: 176 pt
Right: 865 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::State

Layout Name:

Contact Details

Top: 176 pt
Left: 583 pt
Bottom: 198 pt
Right: 865 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Postal Code

Layout Name:

Contact Details

Top: 198 pt
Left: 583 pt
Bottom: 220 pt
Right: 865 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Country

Layout Name:

Contact Details

Top: 220 pt
Left: 583 pt
Bottom: 242 pt
Right: 865 pt

Anchoring: Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Work Email

Layout Name:

Contact Details

Top: 362 pt
Left: 157 pt
Bottom: 384 pt
Right: 412 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Home Email

Layout Name:

Contact Details

Top: 384 pt
Left: 157 pt
Bottom: 406 pt
Right: 412 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Photo | Container

Layout Name:

Contact Details

Top: 111 pt
Left: 300 pt
Bottom: 273 pt
Right: 437 pt

Anchoring: Right, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Field Name: Contacts::Title

Layout Name:

Contact Details

Top: 111 pt
Left: 157 pt
Bottom: 133 pt
Right: 289 pt

Anchoring: Left and Right, Top

Field Format:

Drop-down List
Display values from: Title
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::First

Layout Name:

Contact Details

Top: 133 pt
Left: 157 pt
Bottom: 155 pt
Right: 289 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Last

Layout Name:

Contact Details

Top: 155 pt
Left: 157 pt
Bottom: 177 pt
Right: 289 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Work Phone

Layout Name:

Contact Details

Top: 185 pt
Left: 157 pt
Bottom: 207 pt
Right: 289 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Mobile Phone

Layout Name:

Contact Details

Top: 207 pt
Left: 157 pt
Bottom: 229 pt
Right: 289 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Home Phone

Layout Name:

Contact Details

Top: 229 pt
Left: 157 pt
Bottom: 251 pt
Right: 289 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Fax

Layout Name:

Contact Details

Top: 251 pt
Left: 157 pt
Bottom: 273 pt
Right: 289 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Company

Layout Name:

Contact Details

Top: 287 pt
Left: 157 pt
Bottom: 309 pt
Right: 437 pt

Anchoring: Left and Right, Top

Field Format:

Drop-down List
Display values from: Company
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Job Title

Layout Name:

Contact Details

Top: 309 pt
Left: 157 pt
Bottom: 331 pt
Right: 437 pt

Anchoring: Left and Right, Top

Field Format:

Drop-down List
Display values from: Job Title
Auto-complete using value list

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Website

Layout Name:

Contact Details

Top: 331 pt
Left: 157 pt
Bottom: 353 pt
Right: 413 pt

Anchoring: Left and Right, Top

Field Format:

Edit Box
Auto-complete using previously entered values

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Select entire contents of field on entry
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key, Return key, Enter key

Yes

Field Name: Contacts::Notes

Layout Name:

Contact Details

Top: 273 pt
Left: 583 pt
Bottom: 406 pt
Right: 865 pt

Anchoring: Right, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Contacts::Contacts | MATCH FIELD

Layout Name:

Contact Details

Visibility:

Only visible in Table View

Top: 82 pt
Left: 2790 pt
Bottom: 113 pt
Right: 2910 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: System Default

Text:

<<Contacts | MATCH FIELD>>

Layout Name:

Contact Details

Top: 66 pt
Left: 36 pt
Bottom: 96 pt
Right: 439 pt

Anchoring: Left and Right, Top

Contacts::Contacts | MATCH FIELD

Text:

<<City>>

Layout Name:

Contact Details

Top: 66 pt
Left: 462 pt
Bottom: 100 pt
Right: 865 pt

Anchoring: Right, Top

Contacts::City

Text:

<<File Name Placeholder>>

Layout Name:

Contact Details

Top: 184 pt
Left: 306 pt
Bottom: 214 pt
Right: 431 pt

Anchoring: Right, Top

Contacts::File Name Placeholder

Type:

Layout Name:

Contact Details

Additional Properties:

Change to hand cursor over button

Top: 461 pt
Left: 37 pt
Bottom: 489 pt
Right: 848 pt

Anchoring: Left and Right, Top

Layouts:

Event Details

Type:

Text:

Layout Name:

Contact Details

Tooltip:

"Send Email to " & Contacts::Work Email

Top: 362 pt
Left: 412 pt
Bottom: 384 pt
Right: 437 pt

Anchoring: Right, Top

Send Mail [ Send via E-mail Client; To: Contacts::Contacts | MATCH FIELD & " <" & Contacts::Work Email & ">"; Message: "Dear " & Contacts::Contacts | MATCH FIELD & ",¶¶" ]

Fields:

Contacts::Contacts | MATCH FIELD
Contacts::Work Email
Contacts::Contacts | MATCH FIELD

Button Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

Contact Details

Tooltip:

"Address Map"

Top: 110 pt
Left: 840 pt
Bottom: 132 pt
Right: 865 pt

Anchoring: Right, Top

Open URL [ "http://local.google.com/maps?" & "q=" & Contacts::Address 1 & "," & Contacts::Address 2 & "," & Contacts::City & "," & Contacts::State & "," & Contacts::Postal Code & "," & Contacts::Country ] [ No dialog ]

Fields:

Contacts::Address 1
Contacts::Address 2
Contacts::City
Contacts::State
Contacts::Postal Code
Contacts::Country

Button Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

Contact Details

Tooltip:

"Send Email to " & Contacts::Home Email

Top: 384 pt
Left: 412 pt
Bottom: 406 pt
Right: 437 pt

Anchoring: Right, Top

Send Mail [ Send via E-mail Client; To: Contacts::Contacts | MATCH FIELD & " <" & Contacts::Home Email & ">"; Message: "Dear " & Contacts::Contacts | MATCH FIELD & ",¶¶" ]

Fields:

Contacts::Contacts | MATCH FIELD
Contacts::Home Email
Contacts::Contacts | MATCH FIELD

Button Properties

Coordinates

Script/Script Step

Type:

Text: Contact List

Layout Name:

Contact Details

Top: 29 pt
Left: 36 pt
Bottom: 53 pt
Right: 150 pt

Anchoring: Left, Top

Go to Layout [ “Contacts” (Contacts) ]

Layouts:

Contacts

Button Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

Contact Details

Tooltip:

"Open URL " & Contacts::Website

Top: 331 pt
Left: 412 pt
Bottom: 353 pt
Right: 437 pt

Anchoring: Right, Top

Open URL [ Contacts::Website ] [ No dialog ]

Fields:

Contacts::Website

Table:

Events

Layout Name:

Contact Details

Top: 460 pt
Left: 36 pt
Bottom: 602 pt
Right: 865 pt

Anchoring: Left and Right, Top and Bottom

Field Objects

Events::Event at (464, 80, 486, 301)
Events::Date at (464, 301, 486, 413)
Events::Venue at (464, 413, 486, 561)
Events::City at (464, 561, 486, 709)
Events::Description at (464, 709, 486, 846)

Sort records: On
Field: Date
- Descending order
- Reorder based on summary field: Off
- Override field's language for sort: Off

Filter calculation: None
Initial Row: 1
Number of Rows: 5
Show vertical scroll bar

Value Lists

Value List Name	Source	Values	On Layouts
Type	Custom	Event, Meeting, Congress, Party, -, Wedding, Anniversary, -	Event Details
Venue	Field	Primary Field Field: Events::Venue Sort by first field	Event Details
Boolean	Custom	1	Event Details
Status \| Tasks	Custom	Overdue, Due, To Do, Unassigned, Completed	Event Details
Status \| Guest	Custom	Attending, Maybe Attending, Invited, No Response, Not Attending,	Event Details
Time [Meridiem]	Custom	8:00 AM, 9:00 AM, 10:00 AM, 11:00 AM, -, 12:00 PM, 1:00 PM, 2:00 PM, 3:00 PM, 4:00 PM, 5:00 PM, 6:00 PM, 7:00 PM, 8:00 PM, -	Event Details
Time [24 Hours]	Custom	8:00, 9:00, 10:00, 11:00, 12:00, -, 13:00, 14:00, 15:00, 16:00, 17:00, 18:00, -, 19:00, 20:00, -
Contacts	Field	Primary Field Field: Contacts::Contacts \| MATCH FIELD Sort by first field	Event Details Contact Details
Assignees	Field	Primary Field Field: Contributors::Contributor \| MATCH FIELD Sort by first field Table Occurrence: Events	Event Details
Role	Field	Primary Field Field: Contributors::Role Sort by first field	Event Details
Preferences	Field	Primary Field Field: Guests::Preferences Sort by first field	Event Details
Assignment	Custom	Assigned, Not Assigned
Title	Field	Primary Field Field: Contacts::Title Sort by first field	Contact Details
Job Title	Field	Primary Field Field: Contacts::Job Title Sort by first field	Contact Details
Company	Field	Primary Field Field: Contacts::Company Sort by first field	Contact Details
Layout Selector	Custom	Events, Contacts	Events Contacts
Event List \| Sort Selection	Custom	Time Frame, Event, Type, Venue, City, State	Events
Contact List \| Sort Selection	Custom	Company, Contact Name, City, State	Contacts

Script Hierarchy

Next Script: [Add Task [+]]

Script Name	Add Contributor [+]
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	Event Details
Scripts that use this script
Script Definition
Script Steps	Freeze Window Go to Field [ Contributors::Contributor \| MATCH FIELD ] Go to Portal Row [ Last ] Halt Script New Record/Request Commit Records/Requests [ Skip data entry validation; No dialog ]
Fields used in this script	Contributors::Contributor \| MATCH FIELD
Scripts used in this script
Layouts used in this script
Tables used in this script	Contributors
Table occurrences used by this script	Contributors
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Add Contributor [+]]

Next Script: [Add Guest [+]]

Script Name	Add Task [+]
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	Event Details
Scripts that use this script
Script Definition
Script Steps	Freeze Window Go to Field [ Tasks::Task ] Go to Portal Row [ Last ]
Fields used in this script	Tasks::Task
Scripts used in this script
Layouts used in this script
Tables used in this script	Tasks
Table occurrences used by this script	Tasks
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Add Task [+]]

Next Script: [Add Agenda Item [+]]

Script Name	Add Guest [+]
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	Event Details
Scripts that use this script
Script Definition
Script Steps	Freeze Window Go to Field [ Guests::Guest \| MATCH FIELD ] Go to Portal Row [ Last ] Halt Script New Record/Request Commit Records/Requests [ Skip data entry validation; No dialog ]
Fields used in this script	Guests::Guest \| MATCH FIELD
Scripts used in this script
Layouts used in this script
Tables used in this script	Guests
Table occurrences used by this script	Guests
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Add Guest [+]]

Next Script: [Remove Event Item [Get Script Parameter]]

Script Name	Add Agenda Item [+]
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	Event Details
Scripts that use this script
Script Definition
Script Steps	Freeze Window Go to Field [ Agenda::Agenda Item ] Go to Portal Row [ Last ] Halt Script New Record/Request Commit Records/Requests [ Skip data entry validation; No dialog ]
Fields used in this script	Agenda::Agenda Item
Scripts used in this script
Layouts used in this script
Tables used in this script	Agenda
Table occurrences used by this script	Agenda
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Add Agenda Item [+]]

Script Name	Remove Event Item [Get Script Parameter]
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	Event Details
Scripts that use this script
Script Definition
Script Steps	Set Error Capture [ On ] Show Custom Dialog [ Title: "Confirmation"; Message: "Do you want to permanently remove " & Get ( ScriptParameter ) & "?"; Default Button: “Remove”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] If [ Get ( LastMessageChoice ) = 1 ] Delete Portal Row [ No dialog ] End If Commit Records/Requests [ Skip data entry validation; No dialog ]
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

Script Triggers

Parent Folder: [Script Triggers]

Next Script: [Trigger | On Window Close]

Script Name	Trigger \| On First Window Open
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Go to Layout [ “Events” (Events) ] Show/Hide Toolbars [ Show ] Set Zoom Level [ 100% ] If [ Get ( TotalRecordCount ) = 0 ] New Record/Request End If
Fields used in this script
Scripts used in this script
Layouts used in this script	Events
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 | On First Window Open]

Parent Folder: [Script Triggers]

Next Script: [-]

Script Name	Trigger \| On Window Close
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	If [ Get ( WindowName ) = Get ( FileName ) ] Select Window [ Name: Get ( FileName ); Current file ] Show/Hide Toolbars [ Show ] End If
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 | On Window Close]

Parent Folder: [Script Triggers]

Next Script: [Trigger | Layout Selection]

Script Name	-
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps
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: [-]

Parent Folder: [Script Triggers]

Next Script: [Trigger | Sort Event List]

Script Name	Trigger \| Layout Selection
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	If [ PatternCount ( Get ( ApplicationVersion ) ; "Go_iPad" ) ] Go to Layout [ Events::Layout Selector & " \| iPad" ] Else If [ PatternCount ( Get ( ApplicationVersion ) ; "Go" ) ] Go to Layout [ Events::Layout Selector & " \| iPhone" ] Else Go to Layout [ Events::Layout Selector ] End If
Fields used in this script	Events::Layout Selector
Scripts used in this script
Layouts used in this script
Tables used in this script	Events
Table occurrences used by this script	Events
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Trigger | Layout Selection]

Parent Folder: [Script Triggers]

Next Script: [Trigger | Create Event in List]

Script Name	Trigger \| Sort Event List
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Set Field [ Events::Layout Selector; "Events" ] If [ $$SCRIPT_TRIGGER = "Off" ] Set Variable [ $$SCRIPT_TRIGGER; Value:"On" ] Exit Script [ ] End If If [ Events::Sort Selection = "Time Frame" ] Sort Records [ Keep records in sorted order; Specified Sort Order: Events::Time Frame \| Sort Order; ascending Events::Sort List Key; ascending Events::Date; descending ] [ Restore; No dialog ] Else If [ Events::Sort Selection = "Event" ] Sort Records [ Keep records in sorted order; Specified Sort Order: Events::Event; ascending ] [ Restore; No dialog ] Else Sort Records [ Keep records in sorted order; Specified Sort Order: Events::Sort List Key; ascending Events::Date; descending ] [ Restore; No dialog ] End If Go to Record/Request/Page [ First ]
Fields used in this script	Events::Layout Selector Events::Sort Selection Events::Time Frame \| Sort Order Events::Sort List Key Events::Date Events::Event
Scripts used in this script
Layouts used in this script
Tables used in this script	Events
Table occurrences used by this script	Events
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Trigger | Sort Event List]

Parent Folder: [Script Triggers]

Next Script: [-]

Script Name	Trigger \| Create Event in List
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	If [ Get ( RecordOpenState ) ≠ 1 ] Exit Script [ ] End If Go to Layout [ “Event Details” (Events) ]
Fields used in this script
Scripts used in this script
Layouts used in this script	Event Details
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 | Create Event in List]

Parent Folder: [Script Triggers]

Next Script: [Trigger | Sort Contact List]

Script Name	-
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps
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: [-]

Parent Folder: [Script Triggers]

Next Script: [Trigger | Create Contact in List]

Script Name	Trigger \| Sort Contact List
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Set Field [ Events::Layout Selector; "Contacts" ] If [ Contacts::Sort Selection = "Contact Name" ] Sort Records [ Keep records in sorted order; Specified Sort Order: Contacts::Initial; ascending Contacts::Contacts \| MATCH FIELD; ascending ] [ Restore; No dialog ] Else Sort Records [ Keep records in sorted order; Specified Sort Order: Contacts::Sort List Key; ascending Contacts::Contacts \| MATCH FIELD; ascending ] [ Restore; No dialog ] End If Go to Record/Request/Page [ First ]
Fields used in this script	Events::Layout Selector Contacts::Sort Selection Contacts::Initial Contacts::Contacts \| MATCH FIELD Contacts::Sort List Key
Scripts used in this script
Layouts used in this script
Tables used in this script	Contacts Events
Table occurrences used by this script	Contacts Events
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Trigger | Sort Contact List]

Parent Folder: [Script Triggers]

Script Name	Trigger \| Create Contact in List
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	If [ Get ( RecordOpenState ) ≠ 1 ] Exit Script [ ] End If Go to Layout [ “Contact Details” (Contacts) ]
Fields used in this script
Scripts used in this script
Layouts used in this script	Contact Details
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Custom Functions

Function Name	Parameters	Availability	Definition	In Field Definitions	In Scripts
GetMapSizeAuto	webViewerName;zoom;address;city;state;postalCode;country	All accounts	Let ( [ address = Substitute ( address & " " & city & " " & state & " " & postalCode & " " & country ; " " ; "+" ) ; size = GetLayoutObjectAttribute ( webViewerName ; "width" ) & "x" & GetLayoutObjectAttribute ( webViewerName ; "height" ) ] ; "http://maps.google.com/maps/api/staticmap?center=" & address & "&zoom=" & zoom & " &markers=" & address & "&size=" & size & "&sensor=false" )
GetMapSizeManu	size;zoom;address;city;state;postalCode;country	All accounts	Let ( address = Substitute ( address & " " & city & " " & state & " " & postalCode & " " & country ; " " ; "+" ) ; "http://maps.google.com/maps/api/staticmap?center=" & address & "&zoom=" & zoom &" &markers=" & address & "&size=" & size & "&sensor=false" )

FileMaker Data Sources

FileMaker Data Source	File Path List (in search order)
Event Management AuditLog	file:Event Management AuditLog

Custom Menu Sets

Menu Sets	Menus	In Scripts	In Layouts	Comments
[Standard FileMaker Menus]	All Standard Menus

Download example: Event Management with Audit

Used functions:

Audit.Changed2