Welcome to the master reference guide for all operators available in Way We Do Forms & Registers. While functions are pre-packaged commands, operators are the fundamental symbols (like +, =, or >) that you manually place between fields or values to perform basic calculations, comparisons, and logic.
How to read this guide:
Categories: Operators are grouped by what they do: Math, Comparison, Logical, Strings & Lists, and Advanced/Bitwise.
Symbols: Some operations have multiple valid symbols you can use interchangeably (for example, you can use and or &&).
Field Referencing: In the examples column, the $ symbol represents the Field Reference Symbol, which pulls live data from your form (e.g., $Total Cost).
Mathematical Operators
These operators are used to perform standard arithmetic calculations on numerical data, such as addition, subtraction, and multiplication.
Operator Name | Symbol(s) | Purpose | Example |
Add | + | Adds two numbers together. | $Subtotal + $Tax |
Subtract | - | Subtracts the second number from the first. | $Total - $Discount |
Multiply | * | Multiplies two numbers. | $Price * $Quantity |
Divide | / | Divides the first number by the second. | $Total Cost / $People |
Modulus | % | Returns the remainder after dividing two numbers. | $Total Items % $Box Size |
Exponential | ** | Raises a number to the power of another. | $Length ** 2 |
Negation | - (prefix) | Converts a positive number to a negative number. | -$Penalty Fee |
Comparison Operators
Use these operators to compare two values. They always result in a boolean output (True or False), making them perfect for creating rules and If() statements.
Operator Name | Symbol(s) | Purpose | Example |
Equal to | == or = | Checks if two values are exactly the same. | $Status = "Approved" |
Not equal to | != or <> | Checks if two values are different. | $Role != "Admin" |
Less than | < | Checks if the first value is smaller. | $Score < 50 |
Less than or equal to | <= | Checks if the first value is smaller or the same. | $Score <= 50 |
Greater than | > | Checks if the first value is larger. | $Total > 1000 |
Greater than or equal to | >= | Checks if the first value is larger or the same. | $Age >= 18 |
Logical Operators
Logical operators allow you to chain multiple conditions together or reverse them. They are primarily used to build complex, multi-step validation rules.
Operator Name | Symbol(s) | Purpose | Example |
Logical AND | and or && | Returns True only if both conditions are true. | $Score > 50 and $Attendance > 80 |
Logical OR | or or || | Returns True if one of the conditions is tru. | $Customer Type = "VIP" or $Order Total > 500 |
Logical NOT | not or ! | Reverses the logic (True becomes False). | not $Is Completed |
String & List Operators
These operators are designed specifically for searching through text (strings) or finding specific items within multiple-choice selections (lists).
Operator Name | Symbol(s) | Purpose | Example |
Contains (Lists) | in | Checks if a specific value exists inside a list. | "Apple" in $Fruit List |
Does not contain (Lists) | not in | Checks if a specific value is missing from a list. | $Selected Option not in $Approved List |
Contains (Strings) | like | Checks if a text pattern exists within a string. | $Email like "%@company.com" |
Does not contain (Strings) | not like | Checks if a text pattern does not exist within a string. | $Notes not like "%urgent%" |
Advanced & Bitwise Operators
These are highly technical operators typically used in computer science for manipulating data at the binary (bit) level or performing specific mathematical functions.
Operator Name | Symbol(s) | Purpose | Example |
Factorial | ! (suffix) | Multiplies a number by every whole number below it. | $Number! |
Bitwise NOT | ~ (prefix) | Inverts the bits of its operand. | ~$Binary Value |
Bitwise AND | & | Performs a boolean AND operation on each bit. | $Value1 & $Value2 |
Bitwise OR | | | Performs a boolean OR operation on each bit. | $Value1 | $Value2 |
Bitwise XOR | ^ | Performs a boolean exclusive OR operation on each bit. | $Value1 ^ $Value2 |
Left shift | << | Shifts bits to the left by a specified number of positions. | $Value << 2 |
Right shift | >> | Shifts bits to the right by a specified number of positions. | $Value >> 2 |