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.