An option to require Unique Values for any given field


#1

I am glad each table in a base has one key column that must be unique (needed for relational databases), but instead of making this uniqueness requirement only available to the key column, please make this setting available to other fields also.

Some discussion on this topic has already been made (see Unique values in a column), but was listed under “Support” instead of “feature request”.


Advanced rules for data input and validation
#2

By the way, as a temporary workaround, I created another table wherein the “key column” contained the values I wanted to be unique, and linked my second column to the original table’s key values.


#3

The name column doesn’t have to be unique. Try it and see :slight_smile:


#4

Hello Hashim, thank you for your reply.

I would like the option to make the name column unique even when it is not in the key field column. Do you know of a way to enforce a policy that only allows unique values in fields that are not the key column?

Thanks in advance!


#5

any workaround/ update on this?


#6

No workaround from my perspective. I just live with the fact that I will have to comb thru the table. Not sure why people are not concerned about this, and why more people have not run into this issue.


#7

It is absolutely essential for many aspects, hope someone will address this


#8

I’d also agree that having a ‘value must be unique’ as an option on most (if not all) field types would be a valuable feature.

Even if this was only implemented on the ‘Key’ field in the first instance, then that would be a huge bonus.

If others come across this Feature Request, please add your comments or support, so that it can be prioritised accordingly.

Thanks.


#9

Hello,
Have anyone any news on this feature?

Forcing a field to be ‘unique’ is great for safety reasons in many of our use cases.

All the best,
EverPhotoShoot


#10

Exactly this! Unique values are a must! Otherwise duplicates can be easily added without control. I recently had a case where duplicate data was added and had to manually merge them field by field, it was really unpleasant experience.

I really hope an option for unique values on all field types will be added soon.


#11

Forcing Unique values would be great for all of my bases. If I were the only one adding entries, I could manage this myself, but I have a lot of people collaborating on my bases.


#12

looks like little to no development or even statement on essential features. This is annoying :unamused:


#13

Unfortunately they do not deem this as an “essential” feature.

Things in this app appear to be added to their road map based on the number of views and hits, and impact on the majority of users (as it should).

I am guessing that (because of its intuitiveness and usefulness) many users of this app dont have much clue or care about database structures or data integrity. To them this is just a flashy new to-do-list app with drop downs. And as for the other 20% or more, they just use the API to script their database needs… which leaves us SOL unless you want to put a massive amount of manpower into setting up a simple table.


#14

In fairness to Airtable, it seems that the majority of case studies and examples are for more casual uses.

If data structure and referential integrity are of the utmost priority to your app you’d probably be better off using a ‘proper’ database anyway.

I would never dream of using Airtable for any of the projects I currently have running on PostgreSQL.


#15

be it only for one field, but it is a must.


#16

This is a key feature any data management systems should have. Airtable is an exceptionally simple tool however basic yet very important and fundamentally necessary options such as this should not be ignored.


#17

This is a necessary feature. Even “casual” users would be able to see it’s usefullness with a quick explanation.


#18

I also believe that unique values (at least on the name field), required fields and data validation are basic database functions and they should be implemented in AirTable. I would also like to have a way to lock down the options available in a drop-down. Right now, Editors can add values to a drop-down. Also, a field can be defined as Phone number but you can enter anything in it; same thing if the field is defined as email. The only field types that perform any kind of data validation are date fields and number fields.


#19

Totaly agree!!

any progress?

Best
Fabian


#20

Love Airtable as a tool, but add me to the list of people that see this as essential requirement of a DB!