An option to require Unique Values for any given field

+1 for unique primary field aka Primary Key – Optional is fine – read more below

Obviously, if this was added at this point, would have to make it an option ELSE it could blow up existing solutions. That’s fine. Adding as an option is great, and default being off is even fine. And if adding it to primary field, then allow uniqueness to be an option on any field. Please. Pretty please. Really. When is this coming?

1 Like

A bit of a workaround that you could use is using the “Unique” at the bottom of your view. As long as it is “100%”, you know there are no duplicates.

unique

2 Likes

+1 for this request. At a minimum, I’d like to make sure that we’ve not accidentally duplicated order numbers that should be unique. Ideally, with this feature it would at least alert us that there is another entry that matches. Would be helpful for both numbers (most important) and text. Fuzzy logic would be a bonus here so we can be alerted if text entered seems “similar”. Of course, we can do all this manually with grouping and sorting, but with over 10K records that seems like a tremendous waste of time when a computer could do it for us on the fly.

I previously commented on this post about setting this up in zzBots.

You can now install this as a Bot Pack in the Bot Store here: https://www.zzbots.com/store/ts8rTRcNMqRiHhSvR

Disclaimer: I am affiliated with zzBots

Just signed on to give AirTable a go and just as quickly have to give up on it. I couldn’t get beyond two tables before I realized there was no true primary key field. In AirTable’s definition of primary field they indicate it should be unique but offer absolutely no way of enforcing said uniqueness.

Is this still not possible?

5 Likes

Not being able to force PK uniqueness makes airtable completely useless.

5 Likes

Unfortunately, you cannot enforce unique values in Airtable itself, but if your data is coming from a form, we’ve built an extension that allows you to prevent duplicates.

2 Likes

adding my +1 to this. Surprised it doesn’t exist :frowning:

5 Likes

I haven’t written it up, but I assume you can write a script in the script block so that when that field is imputed if there is a match in that existing column, it either clears out the field or adds a 1 or something at the end of it.

1 Like

Would be especially important to have unique formula fields.

For instance, take an “Application” and a “Version” table.
An “Application” field on “Version” links to an “Application” record.
A “Name” field on “Version” describes the version name.

You wouldn’t want to have multiple records combining the Application “Sublime Text” and version “3.2.2” at any given time.

You can see how this is usually achieved in a database like Postgres here.

A way to achieve this in Airtable would be to make a formula such as “RECORD_ID() + " " + Name” and activate a “unique” flag on it.

I am sure the details of such an implementation are complex, but I think the general need for something like this makes sense.

1 Like

This is certainly a must. I’d love to hear comments from Airtable Team at least.

1 Like

I set up an Airtable evaluation account literally 10 minutes ago and have already run into this critical yet seemingly simple to solve limitation. Also as part of my evaluation I find it an interesting signal that there has been no comment from Airtable in this 5 year old thread with 51 replies virtually all of which are begging for this feature.

2 Likes

Microsoft Lists has “Enforce Unique Values” and Column Validation.
As Microsoft has budget and resources, AirTable has to step it up. I love AirTable but Unique Values in any field is important.

I am referring to this: https://www.microsoft.com/en-ca/microsoft-365/microsoft-lists
Take a look at this:
https://sharepointmaven.com/how-to-prevent-duplicate-entries-in-sharepoint-lists-and-libraries-with-enforce-unique-values-feature/

I commented on this thread several months ago with one solution to this problem.
You can create a bot using zzBots that will integrate with Airtable and automatically flag duplicate records.
It will allow you to require a unique value for any field that you choose.

You can install it as a plugin here: https://www.zzbots.com/store/ts8rTRcNMqRiHhSvR

After you have it installed, you can watch the following video for reference to finish setting it up, or chat in for assistance.

In this video, the example of the Email field, and Duplicate field is used. These can be replaced with any Airtable field unique to your use case.

Disclaimer: I am affiliated with zzBots

This feature would REALLY help. I’m making, for instance, a view of “Past participants in Tuesday Morning classes” for a new facilitator who will be emailing all the people in the view. If I could make “email” show only unique addresses, it’d save so much time–for the facilitator, and for me when I once again try and fail to figure out how to do this.
Even if, when filtering, I could choose “where email is unique” from the dropdown.