Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...