Data Validation

When a user clicks Change on a PT Admin application form view, the application validates the data the user entered and displays a message if the data is invalid. The PT application validates data by:

Requiring users to enter data in certain fields. The labels of required fields are bold to indicate the user must type data in a text box or make a selection from a list.
Limiting the number of characters users can enter in text boxes. The maximum length is the length specified in the Eval database tables. Adding Attributes to Eval Tables describes the length attribute. When the text the user enters reaches the maximum length specified for the field, the user cannot type additional characters.
Using pattern matches to validate data in text boxes. The following table lists the patterns, form views, and fields to which the patterns apply.

Pattern	Activity form	Activity Type form	Group form	Location form	User form
isAlpha Allows: a–z, A–Z, space, and tab				Region, City, Country	First Name, Last Name, City, Region, Country
isDate Allows: 0–9, /, and .	Due Date		Begin Date, End Date
isEmail Allows: a–z, A–Z, 0-9, and any wildcard character				E-mail Name	E-mail Name
isPhone Allows: a–z, A–Z, 0–9, ., (, , ) and space				Telephone
isSmallint Allows: 0–32767	Max Score			Maximum Occupancy
isTime (assumes 24-hour clock) Allows: 0-9 and :			Begin Time, End Time
isTinyint Allows: 0–255	Weight	Drop Lowest, Penalty Value, Weight	Max. Size, Period	Max. Occupancy
isWord Allows: A–Z, a–z, 0–9 , _ , and space	Activity Name	Activity Type Name	Group Name	Location Name, Postal Code	Postal Code