Logical Conditions and Expressions in FormBuilder

In many locations, while configuring a page, the user will be given opportunities to set logical criteria for the purposes of controlling field, section, and page behavior. These opportunities appear by default for the Page Configuration settings. For fields and sections they appear when an attribute is set to “Condition.”

The available fields to use in the condition are controlled by the Data Sets configured on the page, and the fields selected for each set. Each condition has these attributes:

  1. Data Set: The data set from which to choose a field to evaluate.
  2. Criteria Field: A field from the data set to evaluate.
  3. Operator: A function that will compare the existing value in the chosen criteria field with what is entered in the Value column.
  4. Value: A manually entered or selected value to be compared (per the operator) with the existing value in the Criteria Field. Values are case sensitive. Multiple values can be entered on one row by separating them with a comma.
  5. Action: Click the X icon to remove the row of criteria.
  6. Expression: Using the “SR. NO” associated with each row of criteria, build a logical expression consisting of numbers separated by AND or OR and grouped with parentheses to determine how the criteria should be evaluated. If no Expression is entered, the Expression defaults to AND for each criteria, meaning they all must be met. For example: “(1 AND 2) OR 3”
Note:
Always use uppercase “AND” and “OR” in logical expressions. Lowercase “and” and “or” will not work.

Date Expressions (Dynamic or Static)

When using date fields in criteria, you have two options:

  1. Enter a static date value
  2. Construct a dynamic date expression using other date fields and these operators:
    1. TODAY()
    2. ADDDAYS(dateExpression,numberOfDays)
    3. ADDWEEKS(dateExpression,numberOfWeeks)
    4. ADDMONTHS(dateExpression,numberOfMonths)
    5. ADDYEARS(dateExpression,numberOfYears)
Thus, to display a field only if the user’s birthday is more than 18 years ago, we would write the rendered condition like this: