Skip to content

Knowledge Base

White Paper Libary

Building a task that allows user input to decide a task outcome – Create Workflow Job

This example creates a task which uses the format tool Create Workflow Job. This allows a user to have direct input in to how a task produces an outcome.

The task runs based on a change in data in a database system, it queries the database of the database system, creates a Workflow Job and sends it to a user via email.

This task is made up of 4 steps:

Step NameToolWhat it does
Customer on HoldEvent: Microsoft SQL Server TriggerDetects a specific change in data in a business systems database. This step outputs key pieces of information by using variables.

Setting up a MS SQL Server Trigger Step

Get Account Managers EmailInput: Database Query (ODBC)Reads the database of a business system to find details to include in the alert.

Querying a database

On Hold OverrideFormat: Create Workflow JobGenerates a web page containing fields for completion which allows a user to interact with and affect the outcome of a task.

Creating a Workflow Job step

Notify Account ManagerOutput: Send Email (SMTP)Sends an email alert to a user containing a hyperlink to the Workflow Job.

Sending an email

To read about designing other tasks see:

Learn about: Task Design