# Can I stop duplicate records?

> Yes. Tables allow duplicates by default, but a form validation rule with 'is not unique' refuses a value that already exists, and imports can match records.

Source: https://tadabase.com/docs/faq/can-i-prevent-duplicate-records  
Status: Verified Nov 22, 2026. Checked against the current product

Yes. Tables accept duplicate values by default, so to keep a field unique, such as an email address, add a validation rule to the form with the operator **is not unique**: the form then refuses a value another record already has and shows your message. When you import, choose to update or skip records that already exist instead of adding them again.

## On a form

1. **Open the form's rules** In the Page Builder, edit the form, click **Rules**, then **Validation Rules** and **Add New Validation Rule**.
2. **Set the condition** Pick the field, for example **Email**, and the operator **is not unique**. Tick **Check Additional Fields** if a record only counts as a duplicate when other fields match too.
3. **Write the message and save** Type a **Message**, such as `This email is already registered`, and click **Update & Save**. A rule with no message does not stop the form.

The rule protects that form only. Add it to every form that adds records to the table. See [Stop a form from saving with validation rules](https://tadabase.com/docs/workflows/validation-rules).

## When you import

In the import's **Advanced Import Options**, choose **Update records that already exist** or **Skip records that already exist**, then set which imported column matches which Tadabase field, for example the email column to **Email**. See [Import records from a CSV file](https://tadabase.com/docs/data/importing-from-the-builder).
