Difference between revisions of "Expression Builder"

From LongJump Support Wiki
imported>Aeric
imported>Aeric
Line 6: Line 6:
#:* Click this button to bring up a field-chooser dialog
#:* Click this button to bring up a field-chooser dialog
#:* Select a field.<br>'''Note:'''
#:* Select a field.<br>'''Note:'''
#::* Lookup fields end with an angle bracket (<tt>></tt>)
#::* 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
#::* 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
#::* Up to 4 lookup records can be traversed, as shown in the example below

Revision as of 22:04, 2 May 2012

USAGE: #ExpressionBuilder

Write an Expression in the formula field. Use the Formula Builder to help:
FieldChooserButton.png

  1. [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
    border‎
    Insert an Operator
    Optionally, choose an Operator to build the expression
    [Choose Function]
    Choose from a list of available Functions