Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
MBS FileMaker Plugin Example Databases
OnRecordEdit Trigger
All examples are included with download of MBS FileMaker Plugin.
Overview | |
Tables | 2 |
Relationships | 0 |
Layouts | 2 |
Scripts | 6 |
Value Lists | 0 |
Custom Functions | 0 |
Custom Menus | 24 |
File Options | |
Default custom menu set | [Standard FileMaker Menus] |
When opening file | |
Minimum allowed version | 12.0 |
Login using | Account Name; Account= Admin |
Allow user to save password | Off |
Require iOS passcode | Off |
Switch to layout | Off |
Hide all toolbars | Off |
Script triggers | |
OnFirstWindowOpen | Off |
OnLastWindowClose | Off |
OnWindowOpen | Off |
OnWindowClose | Off |
OnFileAVPlayerChange | Off |
Thumbnail Settings | |
Generate Thumbnails | On; Temporary |
Table Name |
Statistics
| Occurrences in Relationship Graph |
OnRecordEdit Trigger |
8 fields defined, 4 records
| OnRecordEdit Trigger |
Status |
6 fields defined, 0 record
| Status |
Table Name: OnRecordEdit Trigger - 8 Fields | ||||||||
Field Name | Type | Options | Comments | On Layouts | In Relationships | In Scripts | In Value Lists | |
PrimaryKey | Normal, Text | Auto-Enter:
| Unique identifier of each record in this table |
|
|
|
|
|
CreationTimestamp | Normal, Timestamp | Auto-Enter:
| Date and time each record was created |
|
|
|
|
|
CreatedBy | Normal, Text | Auto-Enter:
| Account name of the user who created each record |
|
|
|
|
|
ModificationTimestamp | Normal, Timestamp | Auto-Enter:
| Date and time each record was last modified |
|
|
|
|
|
ModifiedBy | Normal, Text | Auto-Enter:
| Account name of the user who last modified each record |
|
|
|
|
|
FirstName | Normal, Text | Auto-Enter:
|
|
|
|
|||
LastName | Normal, Text | Auto-Enter:
|
|
|
|
|||
City | Normal, Text | Auto-Enter:
|
|
|
|
Table Name: Status - 6 Fields | ||||||||
Field Name | Type | Options | Comments | On Layouts | In Relationships | In Scripts | In Value Lists | |
Primärschlüssel | Normal, Text | Auto-Enter:
| Eindeutige ID für jeden Datensatz in dieser Tabelle |
|
|
|
|
|
Erstellungszeitstempel | Normal, Timestamp | Auto-Enter:
| Datum und Uhrzeit der Erstellung der einzelnen Datensätze |
|
|
|
|
|
ErstelltVon | Normal, Text | Auto-Enter:
| Kontoname des Benutzers, der die einzelnen Datensätze erstellt hat |
|
|
|
|
|
Änderungszeitstempel | Normal, Timestamp | Auto-Enter:
| Datum und Uhrzeit der letzten Änderung der einzelnen Datensätze |
|
|
|
|
|
GeändertVon | Normal, Text | Auto-Enter:
| Kontoname des Benutzers, der die einzelnen Datensätze zuletzt geändert hat |
|
|
|
|
|
Status | Normal, Text | Auto-Enter:
|
|
|
Layout Objects: OnRecordEdit Trigger
Field Name: OnRecordEdit Trigger::FirstName | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: OnRecordEdit Trigger::LastName | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: OnRecordEdit Trigger::City | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Status::Status | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
Layout Objects: Status
Field Name: Status::Status | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
OnRecordLoad |
OnRecordCommit |
OnRecordEdit |
OnRecordRevert |
Clear Timer |
Trace on |
Next Script: [OnRecordCommit] |
Script Name | OnRecordLoad |
Run script with full access privileges | Off |
Include In Menu | Yes |
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: [OnRecordLoad] | Next Script: [OnRecordEdit] |
Script Name | OnRecordCommit |
Run script with full access privileges | Off |
Include In Menu | Yes |
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: [OnRecordCommit] | Next Script: [OnRecordRevert] |
Script Name | OnRecordEdit |
Run script with full access privileges | Off |
Include In Menu | Yes |
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: [OnRecordEdit] | Next Script: [Clear Timer] |
Script Name | OnRecordRevert |
Run script with full access privileges | Off |
Include In Menu | Yes |
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: [OnRecordRevert] | Next Script: [Trace on] |
Script Name | Clear Timer |
Run script with full access privileges | Off |
Include In Menu | Yes |
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: [Clear Timer] |
Script Name | Trace on |
Run script with full access privileges | Off |
Include In Menu | Yes |
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 |
|
Download example: OnRecordEdit Trigger
Used functions: