All posts
Validation (Inclusion, Exclusion)

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

Inclusion validation (for fields string, text) enables user strictly to define introduced text in the forms fields. User can indicate what exactly text must be carried in field record not allowing entering of other words/phrases. The option has three additional parameters (Partial match, Case sensitive, Allow null):

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

Exclusion validation( for fields string, text) enables user strictly to define introduced text in the forms fields. User can indicate what exactly text can not be carried in field record, allowing entering of other words/phrases. The option has three additional parameters (Partial match, Case sensitive, Allow null):

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

Example of database creation: “Tow fields ”

Steps:

1. On "My Projects" page create new project “Tow fields”
2. Create new form “Test”
3. Into the form place two fields: string type “one line”, text type “multiple line”

4. Under field click on link Set Validation, then in the window choose for field “one line” Inclusion, for field “multiple line” choose Exclusion.

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

5. Next step click "See Test in action" and enter you data

6. MyTaskHelper will check the data that you entered.

When you correct all mistakes click "Create" Now you have first record: Now you see how easy and quickly to create a database with MyTaskHelper.