Skip to main content

Workflow Trigger - Triggered by Worksheet Event


A worksheet event trigger monitors data changes in a specified worksheet. When a record is changed in a way that meets the configured criteria, the workflow starts automatically and executes the subsequent actions.

To configure a worksheet event trigger, specify the following three settings:

  • Trigger Worksheet: Select the worksheet to monitor.
  • Trigger Method: Specify which data changes can trigger the workflow, such as adding, updating, or deleting records.
  • Trigger Conditions: Define filter conditions so that only records meeting the specified criteria can trigger the workflow.

As shown below, select the trigger worksheet and trigger method, then configure the trigger conditions.

Trigger Methods​

  1. When adding or updating records

    Triggers the workflow when a new record is added to the worksheet or an existing record is updated.

    You can select specific trigger fields so that the workflow runs only when those fields are populated or modified. Multiple fields can be selected. If no trigger fields are specified, adding a record or changing any field can trigger the workflow.

  2. When adding records

    Triggers the workflow only when a new record is added to the worksheet.

  3. When updating records

    Triggers the workflow only when an existing record is updated.

    You can select specific trigger fields so that the workflow runs only when those fields are modified. The same trigger field rules apply as for When a Record Is Added or Updated.

  4. When deleting records

    Triggers the workflow when a record is deleted from the worksheet.

Trigger Conditions​

You can configure filter conditions to control which records trigger the workflow.

For example, an approval workflow can be triggered only when an order's status is Pending Approval.

For details on configuring filter conditions, see Data Filtering.

Trigger Delay​

Workflows triggered by worksheet events run after a default delay of 5 seconds, with the following behavior:

  • Record Updates: If another qualifying trigger event occurs during the waiting period, the delay timer resets. This helps prevent repeated workflow executions caused by multiple changes made in quick succession. For example, when editing several fields in a table view, the workflow does not run immediately after each individual field change.

  • Manually Added Records: When a record is created by clicking the form's submit button, the workflow is triggered after a default delay of 5 seconds. To trigger the workflow immediately upon submission, go to More Settings > Submit Form in the form settings and enable Execute the workflow immediately when adding via the submit button.

For HAP Server users, see How to Customize the Trigger Delay for Worksheet-Based Workflows.

Was this document helpful?