Time-Dependent Triggers

Time-Dependent Triggers activate an action at a specific predetermined time. For instance, you may want to send a notification to a client’s email address three days before a payment’s Due Date if an invoice remains unpaid. In this scenario, a Time-Dependent Trigger coupled with an E-mail Alert workflow action can be configured.

To create a new Time-Dependent Trigger, select the New button and define the General and Matching properties.

General Properties

Time Dependent Trigger General Properties

Name
Assign a name to the trigger.
Notes
Add an optional trigger description or explanatory text in the Notes field.
Active
Enable the Active checkbox to activate the trigger. If unchecked, the trigger is stored in the system but will not initiate any actions, even if all predefined conditions are met.

Matching

Time Dependent Matching

Filter
Specify a condition that will trigger a particular action when met.
Date
Select a relevant date (or time) from the dropdown list among the available date columns in the table.
Offset
Define a period before or after the chosen date when the trigger should activate a workflow action.

Please note that if a table contains a formula-date column, such a column can be chosen in the Date dropdown only if the formula is "deterministic." This means it cannot use Today() or Now() functions.

Once the setup is complete, click Save to save the trigger.

Next, you should associate Workflow Actions with the trigger.

Please be aware that the Navigate action does NOT work with Time-Dependent triggers.

To quickly check the filter conditions specified in the trigger and review records that could be affected, go to the workflow triggers list, click directly on the trigger name, and use the View Records button displayed on the trigger form.

View Records

The button offers a dropdown with two options:

Matching filter criteria
Choose this option if you want to review the records that match the filter criteria specified in the trigger.
Matching filter criteria and current timeframe
Click on this option if you need to review the records that match the filter criteria and the current timeframe.

The Current Timeframe section displays two timestamp values: From and To. This is the nearest future range for which the trigger will be executed. If a value of a column chosen in the Date field falls within the Current Timeframe range, the trigger will be executed for those records.

Current Timeframe

The calculation of the Current Timeframe range can be described by this formula:
Between([Date]+Nd, [Current Timeframe From], Now()).

If the trigger settings are modified, the From field will display the timestamp of the modification until the moment of the next trigger execution.

A time-dependent trigger with only an email alert action that is not used elsewhere is viewed and edited as a reminder on a single screen. However, these trigger and action are also listed under workflow triggers and actions to allow fine-tuning.

The limit of records that the system can process at once by each Time-Dependent trigger depends on the number of users invited into the database. More details are provided in the Record Processing Limits section.

At the bottom of the time-dependent trigger form, you can see the Log, which displays when the trigger was executed and which records were processed.

Trigger Log

To review the list of processed records, click on the corresponding View Records link shown in the log.