Difference between revisions of "Expression Builder (disambiguation)"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
| 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]]
| |
| #'''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]]
| |
Revision as of 22:34, 9 May 2014
