Improving the data quality

In order to make your data valid and healthy when entered by the user, it is very important that you must impose some constraints over the values being entered by the user in the system so that the user must not enter any junk values or values that don't meet your business requirement. To enforce data quality, you can use the following option:

1. Validation rules: Use a validation rule to conditionally require fields. You can also ensure proper data format, for example, ZIP code must be of five digits or the date of birth must be greater than 01/01/1990.

2. Unique fields: Use a unique field to make a record unique, based on some fields. For example, in the registration object, make the e-mail field unique so that you don't have two records with the same e-mail address:

   

3. Picklist and dependent picklist fields: Use picklist and dependent fields to force users to enter a permission value.

4. Custom lookup fields and lookup filters: Use lookup fields and lookup filters to...