AgileApps Support Wiki Pre Release

Difference between revisions of "Formula Builder"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 17: Line 17:


===Considerations===
===Considerations===
;Considerations:
:* To compare to a string, use single quotes: 'ABC Co.'
:* To compare to a string, use single quotes: 'ABC Co.'
:* The return value of the expression must match the return value selected for the formula. (The '''[Check Syntax]''' button verifies that it does.)
:* The return value of the expression must match the return value selected for the formula. (The '''[Check Syntax]''' button verifies that it does.)

Revision as of 19:38, 25 July 2011

The Formula Builder lets you interactively define a Formula Expression.

Example

FormulaBuilder.png

To build that formula:

  1. The "Order Amount" field was chosen, inserting order_amount
  2. The Operator "* Multiply" was chosen, inserting *
  3. The "Related to Customer" field "Discount" was chosen, inserting related_to_Customer.discount
  4. The [Check Syntax] button was clicked, to ensure validity.

Boolean Example

How it Works

  1. ExpressionBuilder

Considerations

  • To compare to a string, use single quotes: 'ABC Co.'
  • The return value of the expression must match the return value selected for the formula. (The [Check Syntax] button verifies that it does.)
  • To return a text string, the value returned should be a field of type Text (related_to_customer.name), or a literal string enclose in single quotes ('sample'
  • To return a Boolean, use an IF expression that returns true or false:
IF(related_to_Customer.customer_name = 'ABC Co.', true, false)