COBBLESTONE SOFTWARE
Contract Insight — User Guide
Criteria Creation and Management
03. Admin User Manual › Workflow Management › Criteria Creation and Management
Note: Each procedure in this guide begins at the Contract Insight homepage, so any section can be followed on its own. Custom fields are configurable, so the exact field list on a contract category record may vary between environments.
1. Overview
A workflow's Conditions tab defines which records it runs on — "a record has to match every condition listed." With no conditions added, the tab states plainly that it runs on every record of that type. Add condition and Add statistics condition build out field-based and aggregate-based criteria respectively, and the Overview tab's Only when line summarizes the result in plain language.
2. Key Elements
- Conditions tab → "Which records this workflow runs on. A record has to match every condition listed." Each condition row shows its Field and what it Has to be, with Edit and delete (trash) actions.
- No conditions at all means the workflow runs on every record of its Runs on type — the tab reads "No conditions - it runs on every contracts record," and the Workflows list shows "every record" for that workflow.
- Add condition adds a standard field-based rule, built one of three ways: One field (pick a field and the value or range it has to be), Several, with AND / OR (stack several tests on one field and match ALL or ANY), or Write it out (type the condition as an expression, such as
Status_ID IN ('56','57')). - Add statistics condition adds a rule based on an aggregate value: a field has to be greater than, less than, a percentage above or below, or outside the mean, median, minimum, maximum, or standard deviation of a saved set of records.
- The Overview tab's Only when line summarizes the current condition set in plain language, ending with "All of them have to be true" when there are several; with none it reads "Always - every contracts record matches."
3. Opening a Workflow's Conditions
- From the Contract Insight homepage, click the Administration (sliders) icon at the bottom of the left navigation bar, search for workflow, and click Workflows.
- Find the workflow (use the Search name, task, person or field box if needed). The right side of each row shows how many conditions it has, or "every record" if it has none.
- Click the workflow's row to expand it, then click the Conditions tab.
.png)

4. Workflows With No Conditions
A workflow with no conditions matches every record of its type whenever it runs. The Overview tab shows "Always - every contracts record matches," and the Conditions tab shows "No conditions - it runs on every contracts record." Add at least one condition before switching on a workflow that should only apply to some records.


5. Adding a Field-Based Condition
- On the Conditions tab, click Add condition.
- On the One field tab, choose a Field. The Has to be control changes to suit the field — a value list for drop-down fields, or a between … and … range for number and date fields.
- Enter the value or range.
- Click Add condition to save it, or Cancel to discard it.

Testing Several Values of One Field
- In the Add condition panel, click Several, with AND / OR.
- Choose the Field, then set Match to ALL (every test must pass) or ANY (one is enough).
- Click + Condition for each test, or + Group to nest a group. Everything here is saved as a single condition; a rule about a second field is a separate condition.

Writing the Condition Out
- In the Add condition panel, click Write it out.
- Type the rule in Record has to match (for example,
Contract_Amount BETWEEN '0' AND '100000'). It is added to the workflow's other conditions with AND, so it only has to state its own part. - Click Add condition.

6. Adding a Statistics Condition
- On the Conditions tab, click Add statistics condition.
- Choose the Field to test (for example, Contract Amount).
- Choose how it Has to be compared: Greater Than, Less Than, % Greater Than, % Less Than, or Outside.
- Choose what it is Compared with the: Mean, Median, Minimum, Maximum, or Standard Deviation.
- Choose the set of records the statistic is calculated Of (for example, Government Contracts Over 1M), then click Save condition.

7. Managing Existing Conditions
- On the Conditions tab, review the list. A record has to match every condition shown.
- Click Edit on a row to change it, or the trash icon to remove it.
- Switch to the Overview tab to confirm the plain-language summary under Only when.


8. Quick Reference Summary
| Task | How to Complete It |
|---|---|
| Open a workflow's criteria | Administration → Workflows → expand the workflow → Conditions tab. |
| Run a workflow on every record | Leave the Conditions tab empty. |
| Add a simple field rule | Add condition → One field → Field + Has to be → Add condition. |
| Test several values of one field | Add condition → Several, with AND / OR → Match ALL / ANY → + Condition. |
| Type the rule as an expression | Add condition → Write it out → Record has to match. |
| Compare against an aggregate | Add statistics condition → Field / Has to be / Compared with the / Of → Save condition. |
| Edit or remove a condition | Conditions tab → Edit or trash icon. |
| Check the criteria in plain language | Overview tab → Only when. |