Validation (Inclusion, Exclusion)

Today I'd like to tell you about new validation types: Inclusion, Exclusion.

Inclusion or Exclusion validation (for fields type of a single line, multiple line) enables a user to define an introduced text in the forms fields strictly. A User can indicate what kind of text must be entered in record field not allowing entering other words and phrases for Inclusion. Or vise versa for Exclusion. The option has three additional parameters (Partial match, Case sensitive, Allow null):

Partial match - using this parameter a user allows to enter words or phrases, which contains record in field Within;
Case sensitive - possibility to include/disconnect register;
Allow null - a user can leave the field empty;

Example of database creation: “Validation”

Manual:

1. Create new project “Validation” on "My Projects" page.
2. Create new form "Validation (inclusion, exclusion)”
3. Place two fields into the form: single line type “Email”, multiple line type “Comments”

1. Click on link Validation that is below the field, then in the window choose “one line” Inclusion for the field, choose Exclusion for field “multiple line”.

For “one line” in field Within you can enter words and phrases, which must be included in the list! For “multiple line” in field Within you can enter words and phrases, which must not be included in the list!

1. Next step click is to click "See Test in action" and enter you data

1. MyTaskHelper will check the data that you entered.

When you correct all the mistakes click "Create". Now you have the first record:

Now you see how easy and quick is the process of creation of a database.

11.02.2006 Igor Petrushenko