Log In

Log In


Validation (Inclusion, Exclusion)

When you need to validate only some set of values to be filled in, or not allow some set of words, Inclusion and Exclusion validations will be very helpful

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).


Validation (Inclusion, Exclusion)



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”



  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”
  4. Open Edit field form by clicking on it or Edit icon at the right of each field.
  5. Open form preview and try to enter words from inclusion list and then from exclusion list. QuintaDB will only allow words from inclusion list.


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

Please, login to QuintaDB to be able to post comments
Share the discussion in the social networks: