Logical Functions

You can use concat and if-else formulas in a field.

Formulas "concat" and "ifelse" can be applied to a field

concat: The ‘concat’ function allows you to join text/dynamic input in 1 string. Just select the concat function and add the text/dynamic input you want to concatenate.

You can concatenate text, dynamic inputs or a combination of both

ifelse: The if-else function allows you to you check a dynamic input for a condition and perform actions based on whether or not they are true. Once you select the ifelse function, a variety of formulas will be available to apply on your dynamic inputs:

ifelse contains a condition (with logical operators), true_input and false_input
  • contains (checks for whether a string is in a parent string)

An example of "contains" operator
  • and (combines 2 conditions such that the function is only true if both conditions are true)

  • or (combines 2 conditions such that the function is true if either condition is true)

  • lt (checks whether the variable on the left is less than the variable on the right)

  • gt (checks whether the variable on the left is greater than the variable on the right)

  • lte (checks whether the variable on the left is less or equal to than the variable on the right)

  • gte (checks whether the variable on the left is greater than or equal to the variable on the right)

  • not equal (compares 2 values and returns True if they are unequal)

  • equal (compares 2 values and returns True if they are equal) expression