Difference between revisions of "JavaScript Validation"

Revision as of 15:01, 20 March 2009

Validation Options

Other than Numeric, Alphabetic, Date and Allow Empty, users can define their own validation or criteria for a custom field by creating a user-defined validation based on JavaScript syntax.

To have a custom field only accept certain values

>n or @value@>n

If @value@ is not found, the system will automatically put it at the very front of the validation criteria.

Where

n is any number

> means greater than

< means less than

>= means greater than or equal to

<= means less than or equal to

== means equal to

Example

To have a custom field only accept values larger than 100, enter

>100 or @value@>100 in the Custom box.

To limit the amount of characters that can be entered into a field

@value@.length<n

Where

n is any number

Example

To limit the number of characters in a field to 35 or less

@value@.length<35

To have a custom field only accept values in a range

@value@>n && @value@<n

Where

n is any number

&& means "AND"

|| means "OR"

! means "Not"

() means brackets :-)

Example

To have a custom field only accept values between 100 and 200, enter

" @value@>99 && @value@<201 "

To perform pattern matching

isMatch(@value@, pattern, isEmptyOK)

Where pattern is

L = Letter

N = Number

A = Alphanumeric

AND

isEmptyOK is

True or False

Example

To validate 9 digits SIN number, put this into the box

isMatch(@value@, 'NNNNNNNNN', false)

To allow only numbers and one other character

isFloat(@value@.replace(/c/g,""),true)

where

c is any character

Example

To allow a field to contain only numbers and a semi-colon

isFloat(@value@.replace(/;/g,""),true)

To allow letters and a space

isAlphabetic(@value@,Allow Empty,Allow Space)

where

Allow Empty - true/false

Allow Space - true/false

Example

To allow a field to contain only letters and a space

isAlphabetic(@value@,true,true)