Set up e-mail notifications to send e-mail whenever a specific condition is met.
-
Select Administration > E-mail Messenger > E-mail Notification Setup.
-
Specify the table for which to setup e-mail notification conditions.
-
Select the record for which to set up conditions, and then click Create Conditions.
-
Click Add Condition.
-
Specify this information:
Column - Specify the name of the column on the system table that applies to the e-mail notification.
Condition - Select the criteria for the e-mail notification.
See the following table when entering conditions for e-mail notifications:
Condition
Definition
Is equal to
Set this Condition if Column is equal to the value of Value 1.
Is not equal to
Set this Condition if Column is not equal to the value of Value 1.
Is greater than
Set this Condition if Column is greater than the value of Value 1.
Is less than
Set this Condition if Column is less than the value of Value 1.
Is greater than or equal to
Set this Condition if Column is greater than or equal to the value of Value 1.
Is less than or equal to
Set this Condition if Column is less than or equal to the value of Value 1.
Is blank
Set this Condition if Column is blank.
Is not blank
Set this Condition if Column is not blank.
Is between
Set this Condition if Column is between the values of Value 1 and Value 2.
Is not between
Set this Condition if Column is not between the values of Value 1 and Value 2.
Contains
Set this Condition if Column contains the value of Value 1.
Does not contain
Set this Condition if Column does not contain the value of Value 1.
Value 1 / Value 2 - Specify the value of the e-mail notification condition.
Specify values according to the following formats:
Date - To_date (‘23-OCT-2003’,’DD-MON-YYYY’). For example, if you are entering a date value for a condition that is equal to a specific date, enter the value according to this exact format:
Column
Condition
Value 1
Name of column
Is equal to
To_date (‘23-OCT-2003’,’DD- MON-YYYY’)
Numbers - To_Number (10). For example, if you are entering a number value for a condition that is greater than a specific number, enter the value according to this exact format:
Column
Condition
Value 1
Name of column
Is greater than
To_Number (10)
Characters - ‘engine’
Contains - ‘%pump%’
-
You must enter a Value 1. The system protects both Value 1 and Value 2 if you enter "is blank" or "is not blank" in Condition. Value 2 is required if you enter "is between" or "is not between" in Condition.
-
If you update Column or Condition after you enter Value 1 or Value 2, the system clears both of the value fields.
-
-
Click Submit.
The system clears Active on the associated E-mail Notification record.
-
Click Close.