Duplicate data in primary key column

Baserow Help
,
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

What do you need help with?

Create a table. It appears that the primary key for the table is already set by Baserow. Now, using a form add a new record to that table that duplicates an existing value that is in the primary key column. The duplicate will be created. As it is the primary key, shouldn’t there be a constraint on creating identical values? How is it a primary key if this is allowed?

Please attach screenshots or videos if they help illustrate your question.

Baserow.png
Baserow.png279×241 3.31 KB

2

Hey @crobitaille, field constraints are on the backlog, and we plan to work on this feature this year: Field value constraints (#647) · Issues · Baserow / baserow · GitLab :slightly_smiling_face:

This is a Primary field, not a Primary key, and it goes with the Row ID.

3

Thanks for that. Is there an ETA on the delivery of that?

4

We aim to start working on this feature this quarter as it’s one of the most requested by our community. :raised_hands: