Difference between revisions of "Expression Builder"
From LongJump Support Wiki
imported>Aeric |
imported>Aeric |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Write an [[Expressions|Expression]] into the field. Optionally use the buttons to help specify fields and operators:<br>[[File:FieldChooserButton.png|border]] | |||
#;[Choose Field]: | #;[Choose Field]: | ||
#:* Click | #:* Click this button to bring up a field-chooser dialog | ||
#:* Select a field ( | #:* Select a field.<br>'''Note:''' | ||
#::* Lookup fields that go to {{type|}}s end with an angle bracket (<tt>></tt>) | |||
#::* Selecting a lookup field opens the list of fields available in the targeted record | |||
#::* Up to 4 lookup records can be traversed, as shown in the example below | |||
#:* 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. (When adding values to compare against, be sure to put String values in single quotes. For example: <tt>State = 'CA'</tt>. Numbers do not need to be in quotes.) | ||
#; | #;[Choose Function]:Choose from a list of available [[:Category:Formula Functions|Functions]] | ||
Latest revision as of 21:50, 5 July 2012
Write an Expression into the field. Optionally use the buttons to help specify fields and operators:
- [Choose Field]
-
- Click this button to bring up a field-chooser dialog
- Select a field.
Note:
- Lookup fields that go to Custom Objects end with an angle bracket (>)
- Selecting a lookup field opens the list of fields available in the targeted record
- Up to 4 lookup records can be traversed, as shown in the example below
- Click [Insert Field] to insert the chosen field
- Insert an Operator
- Optionally, choose an Operator to build the expression. (When adding values to compare against, be sure to put String values in single quotes. For example: State = 'CA'. Numbers do not need to be in quotes.)
- [Choose Function]
- Choose from a list of available Functions
