About Policy Triggering Criteria

About Policy Triggering Criteria

To see if a data policy should be triggered, tests are run on its Triggering Criteria. There are three kinds of criteria you can specify, alone or in combination:

Data Criteria

Trigger the policy when one of the date fields in the record (date created, date modified, or date of change in workflow state) is within a specified date range:

• Within the current, next, or previous week, month, or day.
• Within a specified calendar year or calendar quarter.
• Within a specified financial period

Field Criteria

Trigger the policy when one or more fields compare successfully against specified values. (For example, order_total > $5,000.)

Formula-based Criteria

Create a formula-expression from a combination of object fields and User fields, where the user is the person performing the action on the record.

Considerations

• If no criteria are specified, the criteria resolves to TRUE. (The actions associated with the Data Policy are always performed.)
• If a combination of criteria is specified, all must true for the Data Policy to fire.
• Formula-based Criteria are Expressions, which must resolve to TRUE or FALSE
• If the Expression described by the criteria is FALSE, the associated actions are not applied. If TRUE, the Data Policy is executed, and any associated Actions are invoked.
• Calendar Policies have additional, date-based Triggering Criteria available

Triggering Criteria in Action Based Data Policies

In these action-based criteria expressions examples, note that the Field Display Type and Formula Function are used together to create a Logical result for the Policy Triggering Criteria.

These examples are presented as questions, because the result must be Logical: YES/NO or TRUE/FALSE.

Example	Expression
Is the submitted date more than seven days before the departure date?	DATECOMP(departure_date, submit_date) > 7 Note that the Field Display Type is DATE for both arguments
Is the inventory count less than 25?	Inventory_Count < 25 In this example, the Field Display Type for Inventory_Count is NUMBER
Is an essential field blank?	IF (state = '', 'CA', state) In this example, if the state field is blank, the state field is changed to contain CA. Note that the test for blank is two single quotes (''), not the double quotes character (").

Available Triggers and Eligible Objects

This list describes the available triggers, and eligible objects:

Note: Data policies can be created for all objects, except Products and Price Books

Trigger	Triggered when...	Eligible Objects
Add	Adding a new record	All
Update	Updating an existing record	All
Delete	Deleting an existing record	All
Ownership Change	Changing a record's owner	All, except Tasks/Appointments
Workflow State Change	Changing a record's workflow state	All
Import Batch	During a batch import	All
Import Record	During a record import	All, except Tasks/Appointments
Merge	When converting a Prospect to an Account with the Merge option	Prospects and Accounts Only
Convert to Account	When converting a Prospect to an Account without the Merge option	Prospects Only
When Due	When a Task or Appointment becomes due	Tasks/Appointments Only
On View	Retrieving a single record	All
List View	Retrieving a list of records	All

Triggering Criteria in Calendar Based Data Policies

Calendar Based Data Policies offer an additional, date-based criteria, as well as field-based policy triggering criteria.

Learn more: Filter Expressions in Reports and Data Policies

File:Datapolicy-calendar-date.gif