Something missing? Suggest a change or addition

Field Validation

Problem

Users who are unfamiliar to a database are making data input errors.

Context

Data entry in forms.

Solution

Apply validation rules to individual fields to alert users to mistakes before the data is submitted to the database.

It is easy for even expert users to make mistakes when updating a database. In a project that uses collaborative maintenance that involves a group of users with different skills and experience it is particularly important to apply consistent validation to records.

Catching errors or potential mistakes as soon as possible will help to improve the quality of the overall database. This is true even if you have a Mandatory Review process. Automation reduces the work of reviews.

Allowing users to choose between values, e.g. by using dropdown menus, checkboxes, and calendar entry widgets, can help to improve data entry. Avoiding free-text fields and applying consistent validation to identifiers, dates, coordinates and other structured values will also help.

Adding validation early in a project will avoid the need to retrospectively fix up existing data.

Be sure to Explain Fields so that users understand what valid data looks like. Test your validation rules and user interface so that you’re sure that contributors understand how to submit valid data.



Related patterns

Explain Fields

New contributors do not have a comprehensive understanding of your data model and can feel overwhelmed by the new concepts and terminology.

Something missing? Suggest a change or addition