Time-Dependent Triggers

Time-Dependent Trigger calls an action at a determined time. For example, a notification should be sent to a client e-mail address three days before a Due Date of payment, if an invoice was not paid. In this case a Time Dependent Trigger with an E-mail Alert workflow action can be created.

To create a new time-dependent trigger, click on the New button and specify the General and Matching properties.

Time Dependent Trigger General.png

Name	In the `Name` field specify a name of the trigger.
Notes	In the `Notes` field enter a trigger description or any explanation text.
Active	Select the `Active` checkbox if the trigger should take effect. If the checkbox is cleared, the trigger will be stored in the system but will not call any actions even if all predefined conditions are met.

Time Dependent Matching.png

Filter	In the `Filter` section specify a condition that will trigger a certain action if it is met.
Date	From the `Date` list select a necessary date (or time).
Offset	In the `Offset` section specify a period before or after the selected date when the trigger should call a workflow action.

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

When finished, click Save to save the trigger.

Then you should associate Workflow Actions with the trigger.

Please, note that the Navigate action does NOT work with Time-Dependent triggers.

To check quickly 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.

Graphical user interface, text, application, email Description automatically generated

The button comprises the dropdown with two options:

Option	Description
`Matching filter criteria`	Choose this option if you want to review the records matching filter criteria specified in the trigger.
`Matching filter criteria and current timeframe`	Click on this option in case you need to review the records matching filter criteria and the `Current Timeframe` .

The Current Timeframe section shows two timestamp values From and To. This is the nearest future range for which the trigger will be executed. So, if a value of a column chosen in the Date field is within the Current Timeframe range, the trigger will be executed for such records.

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 show the timestamp of the modification until the moment of next execution of the trigger.

A time-dependent trigger with a sole email alert action that is not reused elsewhere is viewed and edited as a reminder - on a single screen; but 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 item.

Below the time-dependent trigger form you can see the Log displaying when the trigger was executed and which records were processed.

Table Description automatically generated with medium confidence

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