Database Trigger
The Database Trigger fires when a record is added, modified, deleted, or restored in a selected table or window. Use it to start a process automatically in response to data changes.
Configuration
| Field | Description |
|---|---|
| Title | A name for this trigger |
| Description | Optional notes about when this trigger fires |
| Trigger Signal | Pre Transaction fires before the change is saved; Post Transaction fires after the change is committed |
| Source Table | Static Table to watch a fixed system table, or Dynamic Table to select a specific window |
| Mode | The context to monitor is Window, which watches records through a window |
| Method | The record operations that activate the trigger: Add, Modify, Delete, and/or Restore. Multiple methods can be selected |
| Select Menu | The menu containing the window to monitor |
| Select Windows | The specific window whose records will be watched |
Pre vs Post Transaction
| Pre Transaction | Post Transaction | |
|---|---|---|
| When it fires | Before data is saved to the database | After data is saved to the database |
| Common use | Validate or block the operation | Send notifications, update logs, trigger follow-up actions |
| On failure | The transaction is cancelled and data is not saved | Data is already saved; corrective actions may be needed |