thankQ Help
This is a list of operators that you can use for validation of fields in thankQ.
Operator |
Description |
Value |
Not Null |
Prevents this field from being empty. |
N/A |
Is Null |
Prevents any data from being entered into this field at all. |
N/A |
Equals |
Allows only exactly what is specified in the Value field. |
Any value. |
Like |
Allows only what is specified in the Value field or any characters that are before or after it. For example if the value is set as Joe then the following will be accepted as valid: Joe Joeseph Mary Joe But anything that does not have Joe in it will fail validation. |
Any value. |
Not Like |
Works the same way as Like, only that the above examples will fail validation and any other data will pass validation. |
Any value. |
Regular Expression |
Prevents anything from being entered into this field that is not considered to be a Regular Expression. |
Any Regular Expression value. |
Length |
Prevents anything from being entered into this field that is not the exact number of characters specified in the value field. |
Any number. |
Is Numeric |
Prevents anything that is not a number from appearing in this field. |
N/A |
Not Is Numeric |
Prevents any numbers from being entered into this field. |
N/A |
Is Date |
Prevents anything that is not a date from appearing in this field. Date format required is:DD/MM/YYYY. |
N/A |
Other Rules that can be applied to the Validation Rules themselves:
Not User Editable
This setting prevents this Validation Rule being changed. This setting cannot be altered and is set in the system.
Do Not Apply to EDI
If this is ticked the Validation Rule will not be applied to the same field in the EDI Module when importing. However this means you will be able to insert data into thankQ that violates the validation rules you have set.
Validation Message
Allows you to set the message which appears if inserted data violates the rule.
