Task Creation SQL

A new optional Task field Creation SQL will only automatically create the ClientTask when the specified SQL statement returns a positive number.

The SQL statement is evaluated in the same manner as the Expire Time SQL field.

In the example below, the Task is only created when the Client’s state is Florida.

 

The string <CLIENTID> is replaced by the Client’s clientID value.