Form operators

Common Types of operators

The common operations applicable to any control are vastly dependent on the data type of the control. The common operations are for the following types:

  • Text
  • Maths / Number
  • Boolean
  • List
  • Date Time

Rules for Action

Operator Explanation Applicable Control Applicable type
Equal to

Not Equal to
  • Checks value or field is Equal to the specified string, number, or expression
  • Not Equal to specified string, number or expression
  1. Text, Text Area, Rich text editor
  2. Numeric
  3. Dropdown
  4. Radio button
  5. Date time picker
  6. Select bar
  7. Toggle button
  • Text
  • Number
  • Boolean
  • Datetime
Start with

Not Start with
  • Checks that the input value Starts with the given set of characters or number
  • Not Start with would check that the value does not start with the given set of characters or number
  1. Text, Text Area, Rich text editor
  2. Numeric
  3. Select bar
  4. Radio control
  • Text
  • Number
End with

Not End with
  • Checks that the input value Ends with the given set of characters or number
  • Not End With would check that the value does not start with the given set of characters or number
  1. Text, Text Area, Rich text editor
  2. Numeric
  3. Select bar
  4. Radio control
  • Text
  • Number
Contains

Not Contains
  • Checks that the input value Contains the given set of characters or numbers
  • Not Contains would check that the value does not contain the given set of characters or number
  1. Text, Text Area, Rich text editor
  2. Numeric
  3. Select bar
  4. Checkbox controls
  5. Radio control
  6. File Upload
  • Text
  • Number
Is empty

Is Not Empty
  • Checks whether the control is empty
  • Is not empty checks if the control is not empty
  1. Text, Text Area, Rich text editor
  2. Numeric
  3. Date time picker
  4. Checkbox controls
  5. Radio control
  6. Select bar
  7. File Upload
  • Text
  • Number
Less than

Less than or equal to

Greater than

Greater than or equal to
  • Checks if the value is less than or equal to a give numeric value
  • Greater than Checks if the value is more than or equal to specific numeric value
  1. Numeric
  • Number
Regular expression
  • Checks if the value matches the pattern depending upon the data types
  1. Text, Text Area, Rich text editor
  2. Numeric
  3. Dropdown
  4. Radio button
  5. Date time picker
  6. Toggle button
  7. Checkbox controls
  • Text
  • Number
  • Boolean
  • Datetime
  • List
Before

Before or equal
  • Checks if the date or time is prior or equal to the given date or time
  1. Date time picker
  • Date-time
After

After or equal
  • Checks if the date or time is prior or equal to the given date or time
  1. Date time picker
  • Date-time
Minimum select
  • Specifies that at least a specified number of item should be selected
  1. List controls
  2. Dropdown controls
  3. Checkbox controls
  4. File Upload
  • List type
Maximum select
  • Specifies the maximum specified number of items should be selected
  1. List controls
  2. Dropdown controls
  3. Checkbox controls
  4. File Upload
  • List type
Exact select
  • Specifies that the selected items contains any or either of the items mentioned in the criteria
  1. List controls
  2. Dropdown controls
  3. File Upload
  4. Checkbox controls
  • List type
Contains Any

Not Contains Any
  • Specifies the exact number of items should be selected
  1. List controls
  2. Checkbox controls
  3. Dropdown controls
  4. File Upload
  • List type
Contains All

Not Contains All
  • Specifies that the selected items include all the items mentioned in the criteria
  1. Checbox controls
  2. Checkbox controls
  3. Dropdown controls
  4. File Upload
  • List type