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.