An Apricot database is equipped with security measures to stop users from entering the exact same information in two different places. This is called "duplicate check," because the system automatically checks the information that has already been entered to find any duplicate entries. More information on duplicate check can be found here.

1. When you begin to fill out a record with information that already exists in the database, a warning message will appear. This means that the database has recognized the information you are entering into the record already exists in the system.

2. If you would like to add information to the record that has already been created in the database, select the orange text. The existing record will open.

3. If you believe you are entering unique information that should be added to the database, select Alter Current Record.

This will allow you to return to the record and change the information in the fields that have been marked as "duplicate check."

1. Duplicate check fields are identified by a small double apricot icon to the right of the field name.

2. Once you have made corrections to the information so that it is unique, you will be allowed to save the record.

Tips and Hints

  • Name fields check the First, Middle, and Last portions of the field. Therefore, Johnny Joe Smith is not the same as Johnny Smith. This will not trigger the duplicate check warning.
  • If you have multiple duplicate check fields on the form then they work together. For example, let's say you have 3 duplicate check fields and enter this information:Name: Jack SmithDate of Birth: 06/10/1995Phone: 555-555-5555
  • Now, lets say you try to enter the below information:Name: Jack SmithDate of Birth: 06/10/1995Phone: 555-333-3333
  • The Duplicate Warning will not go off because their phone number changed. Some fields may not be a good fit for duplicate check fields.
  • Duplicate Check fields can be placed on Tier 1 and Tier 2 forms
  • If you Allow Copies, Duplicate Check fields will always clear upon copy
Did this answer your question?