Overview
Automation rules are the core of workflow optimisation, allowing you to automatically perform actions based on specific criteria. This guide provides a comprehensive, technical overview of how to build robust rules, detailing each of the three essential components: the Trigger, the Condition, and the Action.
The Trigger: Initiating the Automation
The trigger is the event that starts the automation process. It signals the system to evaluate the rule's conditions. Common triggers include:
Item Creation: The rule runs immediately when a new record is created.
Item Update: The rule runs whenever a field value on a record is changed.
Workflow Transition: The rule runs when a record's status moves from one stage to another (e.g., from "In Progress" to "Completed").
You define the trigger and basic rule details (like its name and description) in the Basic Info section. Be sure to give your rule a clear and descriptive name, like "Notify user on Item Assignment Rule," so it's easy to identify later.
The Condition: The Logical Foundation
Conditions are the "if" part of your rule. They are the criteria that must be true before the automation can proceed with an action. You can define conditions using simple comparisons or complex, nested logic.
Simple Conditions: A single check, such as "Status is Approved."
Complex Conditions: Combine multiple conditions using AND or OR operators for advanced logic.
Nested Conditions: Use built-in functions to perform calculations or time-based comparisons.
Supported Operators for Conditions
The table below provides an overview of the operators and expressions supported for each field type.
Note: Separator, File Info and XMP fields are not available in Conditions.
Field type | Operator/Expression | Target for comparison |
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Using Functions in Conditions
Functions introduce dynamic calculations, allowing you to build conditions that go beyond static comparisons. A function can be used as either the source (left-hand side) or the target (right-hand side) of a comparison, depending on its role.
Function | Supported Operators | Description | Role |
---|---|---|---|
LENGTH |
|
|
|
IS UNIQUE |
|
|
|
CURRENT TIMESTAMP |
|
|
|
START OF PERIOD |
|
|
|
ADD DATE |
|
|
|
Trigger Action In
|
|
|
|
Nested Functions and Evaluation
You can nest multiple functions to create complex, time-based conditions. The system evaluates these functions from the innermost to the outermost. For example:
CURRENT TIMESTAMP is EQUAL to START OF PERIOD (ADD DATE (Hour(s) = 1) (ADD DATE (Minutes = 15)))
The system first calculates the inner ADD DATE
function (adds 15 minutes), then the outer ADD DATE
(adds 1 hour to the result), and finally the START OF PERIOD
function before comparing the final value to the CURRENT TIMESTAMP
. This sequential evaluation provides precise control over complex logic.
Rule Conjunction
You can combine multiple conditions using AND and OR operators. This allows you to build complex logical groups.
AND: All conditions within a group must be true.
OR: At least one condition within a group must be true.
You can also combine groups with different operators. For example, (Group 1 **AND** Group 2)
, where Group 1 uses AND
logic and Group 2 uses OR
logic. This provides granular control over when your rule should execute.
Limitations
Null evaluates to true for Less than 0 conditions
It is not possible to set the value by rule for fields having default values configured
Like Operator and Length Expression does work for comparison with the field. Only static values are supported.
LIKE conditions should be used with % sign (like in SQL expressions). Example: %testPhrase% matches 1testPhrase1, testPhrase1, 1testPhrase
The Action: Executing the Task
The action is the final step in the automation, defining what the system does once all conditions are met. Common actions include:
Updating a Field: Automatically change a record's
Status
or assign it to a team.Sending a Notification: Send an email or an in-app alert.
Creating a New Record: Automatically generate a new task or sub-item.
Changing Workflow Status: Move a record to the next stage in its lifecycle.
You configure these tasks in the Actions block, specifying the target fields, recipients, and record types.