Prevent duplicate values in primary column

Your Setup:

  • SeaTable Cloud (free)

Describe the Question:

Is it possible to avoid duplicate values in a column?

Use case

When I add a new record to a Table, I want to make sure that the value of its primary column (type text) is different than the values of all other records

I have a CRM with four tables: Accounts, Contacts, Opportunities, and Pipelines.
I do not want to allow users to create a record (e.g. an new opportunity) whose first column is the same as an already existing record

This is possible when the records are created via a form. Then you can enable the option “Prevent duplicates when adding records”

In the base, you can only highlight duplicates once the rows have been created.

For our use case, forms are not really an option
Is it possible to send a feature request somehow?

If you want a strict control on data, it is better to use the app interface. The table page in app can prevent duplicated records be added.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.