Syntax
Formula fields can either be
- Expressions as in ${entity.budget * 0.10} where entity is the project OR
- contain a mix of expression and text as in The Project ${entity.name} was created on ${entity.created}.
This will print the output as : The Project Sample Project - Office Setup was created on Thu Jun 20 08:30:16 EDT 2013. - contain a mix of expression and text as in <a href="http://mywikiserver/project/${entity.id}>Wiki Link</a>.
This will print 'Wiki Link' as the output which is hyperlinked with the link substituted with the entity's ID.
When formulas are evaluated, anything enclosed in ${..}is treated as an expression and evaluated. Everything outside it is copied to the output verbatim as is.
- ${entity.budget} will display the budget of the entity.
- {entity.name} will be printed as {entity.name} in your report or the details page.
You can also use conditional logic in the formula.
Â