numeric columns (decimals or integers): $amount != null, same way for integer as well as decimal columns.

string columns: multiple different formulas exist depending on what is considered to be an empty string:

date columns: $dueDate != null

boolean columns: $isActive != null

$amount > 0 to validate that the value is greater than 0. Note that this will fail if the value is null (empty). To reject empty values as well as values that are less than zero, you’d need to use a formula like $amount != null && $amount > 0.

$yearOfBirth >= 1900 && $yearOfBirth <= 2023 to test whether $yearOfBirth is between 1900 and 2023 (including both endpoints).

$accountId ~ "A[0-9]+" will validate that the account id consists of upper case letter A followed by at least one digit.

matches($accountId, "A[0-9]+") this is an alternative way - using matches function instead of ~ operator. The result is the same as in the previous example.

matches($zipCode, "[0-9]{5}(-[0-9]{4})?") to verify that $zipCode is either 5-digit format or 5+4 digits.

length($lastName) > 1 to ensure that $lastName is at least one character long.

length($lastName) < 50 to ensure that $lastName is 50 characters at maximum.

containsValue(["red", "green", "blue"], $color) test whether the $color is one of "red", "green" or "blue". The test is exact - i.e. "RED" is considered invalid.

containsValue(["red", "green", "blue"], lowerCase($color)) is similar to above but also will allow values like "RED" as valid values. The value of $color is first converted to lower-case using lowerCase function before it is tested against the list of allowed values.

containsValue([1, 2, 3], $accountType) validates whether $accountType is one of 1, 2 or 3. Note the list does not contain quotes - the values are integers and must not be quoted.