Because the templates for Advanced Communications are prepopulated and cannot be edited, the Actions tab is not enabled in the Edit Event window. To see samples of the email templates, see Sample Advanced Communication Email Notifications.
Viewing a Trigger's Properties
To view the properties for a trigger, select the trigger and the operations and trigger criteria display at the bottom of the window.
When using a DATE field, the parameters must be encompassed between hash marks #. For example: [CREATDDT] > #2022-01-26 00:00:00#.
Enabling a Trigger
- To edit the trigger properties, select an event trigger and then select Properties.
- In the Edit Event window, the General tab displays the General Settings and Operations. For Advanced Communication triggers, these fields are display-only and cannot be edited, except for the Trigger Enabled checkbox.
- Trigger Name: Indicates that any time a service call is created, this event will be active.
- Trigger Type: Displays a list of active CDC tables.
- Event ID: Displays the name of the Event ID.
- Operations: Indicates that any time something deleted, inserted, and/or updated in the CDC table view, the trigger will activate. Depending on the trigger type, additional choices are available in the Operations section.
- The Trigger Enabled checkbox indicates that the trigger is in use.
- Select OK.
Editing Trigger Criteria
The Trigger Criteria tab is used to set up specific criteria that may need to be met for the trigger to activate.
- To edit the trigger properties, select an event trigger and then select Properties.
- Select the Trigger Criteria tab.
- Use the Values and Previous Values tabs and the formula buttons to create the trigger criteria. To enter the values necessary for the formulas, select the VAL button and enter the data.
- If you want to have your triggers automatically send notifications to your customers and technicians, you can edit the AC_Notify criteria value to 0. When the AC_Notify criteria is set to 1, the Notify button in Schedule needs to be selected to send the notification.
- Select OK.