Difference between revisions of "Expression Builder (disambiguation)"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
| (4 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]]
| | {{Disambiguation}} |
| #;[Choose Field]:
| | Did you mean: |
| #:* Click this button to bring up a field-chooser dialog
| | :* [[Formula Builder]] |
| #:* Select a field.<br>'''Note:'''
| | :* [[Filter Expression Builder]] |
| #::* 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
| |
| #: [[File:FieldChooser.png|border]]
| |
| #;Insert an Operator:
| |
| #: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 01:16, 7 June 2014
