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.

  • Verified Nov 22, 2026
  • Classic builder

On this page
  1. On a form
  2. When you import

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.

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.

Was this page helpful?

Something wrong or missing on this page? Tell us.