Run Formula

The Task Planner job Run Formula allows to calculate an arbitrary formula using Crystal syntax. The result is provided as a placeholder [hdformula] for subsequent actions.

The job has access to the available placeholders, which can usually be used as a string.

Example: If the custom field 1 of the ticket is not set, then the display name of the last editor is returned, otherwise the content of this custom field.

IF Length( "{ticket.custom1}" ) = 0 THEN (
    "{ticket.lasteditor.displayname}"
) ELSE (
    "{ticket.custom1}"
)

Note: The Crystal syntax can be created and checked using the i-net Clear Reports Designer.

Condition

An optional condition can be added to the formula. The condition will compare the return value of the formula with the provided condition value and evaluate to true only if the values do match.