...
| Tip |
|---|
Text references in the expression builder often require double quotation marks around the text string. For example:
If you want a field to show up based on another field that is a Yes/No field type when Yes is selected, and the name of the Yes/No field is named, Is this activity complete?. The resulting expression would appear as: Is this activity complete="yes"
To get this result, using the Expression Builder, you would first choose the dependent field from Available Fields. Next, select the = sign from the middle area. Finally, type the dependent value surrounded in quotations. |
Logical Operators
To follow is an example of how a a logical operator can be used. In this example, the logical operators are part of the arguments of a nested IF statement.
Image Added
Error Checking
If a formula is incorrect, the expression builder has some validation built into it to alert you of of any bad syntax.
...