Workflow Examples - execute WorkflowExpression with external Record 

Page / - last modified by Stefan Warnat on 2021/09/19 23:49 

execute WorkflowExpression with external Record 
last modified by Stefan Warnat
on 2021/09/19 23:49

Table of Contents
ProjectTask Workflow
Projects Workflow

This example is triggered everytime a Project Task is updated and execute a Workflow from Module “Project” to summarize working hours.
ProjectTask Workflow
The Workflow within Project Tasks looks like this:

The start action configuration:

The workflow will only executed, if a Project is set within the Task. (Should be the default case)
Then the “Execute Workflow with external Record” search the Project Record and execute another Workflow, you see below.

Configuration of  execute Workflow with external records:

Projects Workflow

Start condition:

The variable initialization:

Summarize all records, which are related to this Project ID.

Set the result into a field

This workflow is not executed automatically. (Start Trigger set to “start manually”)
Because we sum the working hour field about multiple records, we net to initialize the variable and set $env[“hours”] to 0.
The “execute Expression with external Record” execute an small script for every record, which match the the condition. (In this case: Tasks, which are related to the current Project ID)
The script will add the value of $projecttaskhours to the current $env[“hours”] variable.
The last step is to set this value to the Project field “Total Working Time”