Primary Key - Unique/Validation

Technical Help
,
1

Hi,
I have a simple contacts database (Company Name, Contact Name, Address, Phone, Email, etc). The Company Name is configured as the primary filed, however, the database is allowing rows to be created with duplicated Company Name ! Is this correct, should the primary field allow duplicate values ?

If the primary field is not unique, please can you advise how I ensure fields are unique, or how to apply a validation to avoid duplication? This is especially critical when using the API to integrate with 3rd party systems such as accounting systems for invoicing ?

Many thanks.
Martin

2

hey @Thorby, the feature you’re looking for is Field value constraints (#647) · Issues · Baserow / baserow · GitLab. It’s not implemented yet.

Value constraints set limits on the values that can be added to the field. For instance, you can restrict the field from having duplicate values.

3

Thank you olgatrykush,

Please can you explain the purpose of the primary field ?

Also, as this seems to be pretty funamental to any sort of database management, do we have timelines of when this will be implemented ?

Many thanks.

4

Hey, the primary field serves as an identifier and a description for each row: Primary field.

We can’t say when this feature will be implemented as it depends on its priority. Currently, its position is #91 out of 914 issues. New features and bug fixes constantly come up, so this position may change, and that’s why we don’t provide any ETAs.

You can help boost the priority of this issue by giving it a thumbs up on GitLab: Field value constraints (#647) · Issues · Baserow / baserow · GitLab. This way, the team can see how much this issue matters to the community and prioritize it higher.