Difference between revisions of "Expression Builder"
From LongJump Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 4: | Line 4: | ||
</noinclude>Write an [[Expressions|Expression]] in the formula field. Use the [[Formula Builder]] to help:<br>[[File:FieldChooserButton.png|border]] | </noinclude>Write an [[Expressions|Expression]] in the formula field. Use the [[Formula Builder]] to help:<br>[[File:FieldChooserButton.png|border]] | ||
#;[Choose Field]: | #;[Choose Field]: | ||
#:* Click | #:* Click this button to bring up a field-chooser dialog | ||
#:* Select a field (including fields from related records) | #:* Select a field (including fields from related records) | ||
#:* Click '''[Insert Field]''' to insert the chosen field | #:* Click '''[Insert Field]''' to insert the chosen field | ||
#: [[File:FieldChooser.png|border]] | #: [[File:FieldChooser.png|border]] | ||
#; | #;Insert an Operator: | ||
#:Optionally, choose an [[Operators in Formula Expressions|Operator]] to build the expression | #:Optionally, choose an [[Operators in Formula Expressions|Operator]] to build the expression | ||
#; | #;[Choose Function]:Choose from a list of available [[:Category:Formula Functions|Functions]] | ||
Revision as of 19:07, 25 July 2011
USAGE: #ExpressionBuilder
Write an Expression in the formula field. Use the Formula Builder to help:
- [Choose Field]
-
- Click this button to bring up a field-chooser dialog
- Select a field (including fields from related records)
- Click [Insert Field] to insert the chosen field
- Insert an Operator
- Optionally, choose an Operator to build the expression
- [Choose Function]
- Choose from a list of available Functions
