Difference between revisions of "Formula Builder"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
Line 1: | Line 1: | ||
The Formula Builder lets you interactively define a [[Formula Expressions|Formula Expression]]. | The Formula Builder lets you interactively define a [[Formula Expressions|Formula Expression]]. | ||
__TOC__ | __TOC__ | ||
===Example=== | ===Example=== | ||
Line 16: | Line 13: | ||
{{Note|When comparing to strings, include the string in double quotes.<br> E.g. <tt>.name = "ABC Co."}} | {{Note|When comparing to strings, include the string in double quotes.<br> E.g. <tt>.name = "ABC Co."}} | ||
===How it Works=== | |||
#{{:ExpressionBuilder}} |
Revision as of 19:04, 25 July 2011
The Formula Builder lets you interactively define a Formula Expression.
Example
To build that formula:
- The "Order Amount" field was chosen, inserting order_amount
- The Operator "* Multiply" was chosen, inserting *
- The "Related to Customer" field "Discount" was chosen, inserting related_to_Customer.discount
- The entire expression was enclosed in single quotes
- The [Check Syntax] button was clicked, to ensure validity.