Skip to main content
Skip table of contents

Validation Rules

Validation rules can be used to ensure that the values that end users have entered into a field are valid and should let the user continue with their submission.

When a validation rule fails, feedback will be provided to the user that there is an issue with the fields value.

Validation rules have the following common settings:

Setting Name

Description

Rule Name

Name for the validation rule that is used in the admin panel and status windows.

Override Validation Message

Validation rules have rule specific validation messages when they fail.

If you wish to override these default messages that are returned to the user then use this setting.

Required

The rule will fail if no value has been provided.

image-20240312-064435.png

Regex

The rule will fail if the regex doesn’t match.

image-20240312-065930.png

Sample Regex’s:

Description

Regex

Suggested Override Message

4 Numbers

^\d{4}$

Must contain exactly 4 numbers

Email Address

^[a-zA-Z0–9+_.-]+@[a-zA-Z0–9.-]+$

Must enter a valid email address

Australian Post Code

^(0[289][0-9]{2})|([1-9][0-9]{3})$

Must be a valid Australian post code

Custom

The custom validation rule allows you to write JavaScript that returns true or false.

The rule will fail if the JavaScript returns false, null or fails to execute.

There are three variables that can be accessed:

Variable

Description

fieldValue

Current value of the field being validated.

fieldId

Field Id of the field being validated.

container

Container that contains the field being validated.

Example JavaScript to check value in current field equals another field with id “test”:

CODE
var targetFieldId = "test"
var targetField = window.store.getters["form/getters/field/find"](targetFieldId);
if (targetField) {
    if (targetField.value[0] == fieldValue[0]){
        return true;
    }
} else {
    console.log("Couldn't locate target field")
}
return false;

Query Validator

The query validator can be used to execute a query against one of the supported providers.

image-20240312-132303.png

The validating fields current value can be accessed by the following placeholder:

Placeholder

Description

{{fieldValue}}

Returns the current value of the field being validated.

Other field values are able to be referenced via the standard fields placeholder.

When using the following providers please note the following:

ODBC/SQL/Authority Server

  • The query returning no rows will make the validation rule fail.

  • The query returning one row with multiple columns will make the validation rule pass.

  • The query returning one row with a single column will evaluate the following:

    • A value of empty string or null will make the validation rule fail.

    • A value of “false” will make the validation rule fail.

    • A value of “true” will make the validation rule pass.

    • Any other value will make the validation rule pass.

Sample Queries:

Description

Query

Check if a work order number has already been processed.

This query returns ‘false’ if 1 or more matching rows are found and ‘true’ if there are none.

CODE
SELECT CASE 
WHEN Count(*) > 0 THEN 'false' ELSE 'true' END
FROM WorkOrder
WHERE WorkOrderNumber = {{fieldValue}}

Check if a work order number exists.

This query will return the whole row if a match is found.

CODE
SELECT *
FROM WorkOrder
WHERE WorkOrderNumber = {{fieldValue}}

EzeScan WebApps Placeholders

  • The placeholder returning the string “false” will make the validation rule fail.

  • The placeholder returning the string “true” will make the validation rule pass.

  • The placeholder returning an empty value will make the validation rule fail.

  • The placeholder returning a value that is not “false” will make the validation rule pass.

  • The placeholder returning a false boolean will make the validation fail.

Sample Placeholders:

Description

Placeholder

Field value equals “123”

{{fields["field_id_here"]|equals("123")}}

Field value starts with “INV”

{{fields["field_id_here"]|startsWith("INV")}}

Field value greater than “5”

{{fields["field_id_here"]|greaterThan(5)}}

Field value equals the value of a field with id “other_field”

{{fields["field_id_here"]|equals(fields["other_field"])}}

Connector Validator

The connector validator can be used to execute a query against one of our supported integrations via our connectors.

The validating fields current value can be accessed by the following placeholder:

Placeholder

Description

{{fieldValue}}

Returns the current value of the field being validated.

Other field values are able to be referenced via the standard fields placeholder.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.