Condition Operators and Field value

Operators are used in multiple places across PalDock, including:

  • Table filters
  • Cascade filters
  • Modify Field

Most operators require a Value field (to compare against), and some also use a Value2 field.
When used in Modify Field, additional fields may need to be filled in depending on the operation.

Field Value

The Value field is a text field, but it can also accept multiple options using regular expressions.

For example, in Modify Field you can configure it in two ways:

Single value

  • Source: this field
  • Field (only if “Other field” is selected)
  • Condition (Operator): equals
  • Value: approved
  • Operation (Modify Field): anything
  • Output (string): anything

Multiple values (regex)

  • Source: this field
  • Field (only if “Other field” is selected)
  • Condition (Operator): equals
  • Value: approved|rejected
  • Operation (Modify Field): anything
  • Output (string): anything

With this approach you don’t need to create as many separate Modify Field steps or Responses in the Connection Creator.

Supported patterns

You can use standard regex expressions, for example:

  • | for alternatives (approved|rejected)
  • * for wildcards (app*|rej*)
  • …and others — standard regex operations are supported.

Operators

Operator Reference

OperatorValueValue2Description
equalsChecks if two values are equal (a == b).
not-equalsChecks if two values are not equal (a != b).
is-trueChecks if the value evaluates to boolean true.
is-falseChecks if the value evaluates to boolean false.
bigger-thanChecks if the value is greater than another (a > b).
smaller-thanChecks if the value is smaller than another (a < b).
string-containsChecks if the text contains a given substring.
string-not-containsChecks if the text does not contain a given substring.
string-starts-withChecks if the text starts with a given substring.
string-ends-withChecks if the text ends with a given substring.
betweenChecks if the value is strictly between two boundaries (a > min && a < max).
between-includeChecks if the value is between two boundaries, inclusive (a >= min && a <= max).
is-not-emptyChecks if the value is not empty (“”, [], etc.).
is-emptyChecks if the value is empty.
alwaysAlways true — the condition always applies.
load-from-leadSelect another field from the structure and return its value.
regex-matchChecks if the value matches a given regex (e.g. `^(approved
regex-not-matchChecks if the value does not match a given regex.

Related articles

General tools > Group changes
Modify Field > combine
Modify Field > urldecode
Modify Field > urlencode
Modify Field > load-from-lead
Modify Field > regex-replace
Modify Field > from-base64
Modify Field > to-base64
Modify Field > modify-date
Modify Field > format-date

Insights that
helps you grow