Expression Builder

USAGE: #ExpressionBuilder

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

1. [Choose Field]

   • Click this button to bring up a field-chooser dialog
   • Select a field.

   • Lookup fields 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

   [Choose Function]

   Choose from a list of available Functions