Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

An option to require Unique Values for any given field

cancel
Showing results for 
Search instead for 
Did you mean: 
Matthew_Billiod
6 - Interface Innovator
6 - Interface Innovator

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”.

56 Comments
drassi
6 - Interface Innovator
6 - Interface Innovator

I’d also appreciate being able to force column uniqueness constraint—at least on a table’s (non-formula) Primary Field. It is a bit confusing that it is allowed at all, if you accidentally have 2 duplicate primary field entries, I’ve found that certain rollup/aggregation functions don’t work as expected (which is expected if you have database experience, but not for the layperson).

Scott_Barman
4 - Data Explorer
4 - Data Explorer

Can I add a +1 for the unique column?!

Alex_Storer
4 - Data Explorer
4 - Data Explorer

Yep! Example - a form where people can flag a Thing. Has the thing been flagged already? Then the form says no.

Noah_Freedman
4 - Data Explorer
4 - Data Explorer

This would be great. I’m using AirTable as a low-touch high-flexibility CRM, after being frustrated with Hubspot’s poor UX, slow data entry, and difficulty to edit. Needing to manually remove duplicates may be the pain that makes me give up AirTable as a CRM

Orin_Hutchings
6 - Interface Innovator
6 - Interface Innovator

Here is a solution.

At zzBots, we integrated with AirTable to create a bot that will automatically flag any duplicate records in a table based on the field specified.

Here is a step by step video on how to create this bot using zzBots:
If you want to check it out, search the video “How to Create a Bot That Will Automatically Flag Duplicate Records in Airtable - zzBots” on YouTube.

Hope this helps!

Areteanism
4 - Data Explorer
4 - Data Explorer

Hey Airtable! It looks like you still haven’t done anything about this- this is absolutely necessary if I’m going to be able to use you long term! I’ve been strongly considering paying for a subscription with you after the free trial ends because so far I’ve been so very impressed with your product! …except for this.

Seriously, this will end up being a deal breaker. I have to be able to enforce unique record values for my key fields, and I’d really rather not just make everything refer to an inscrutable auto-incrementing number.

Please take notice of this thread, and act on it SOON!

Henrik_Hoffman
4 - Data Explorer
4 - Data Explorer

Agree!

Given that you want your whole org +100 people in Airtable you will have a need for this function in some crucial tables.

Goncalo_Abreu
4 - Data Explorer
4 - Data Explorer

This is a Must!
Why isn’t Airtable adding this feature? Is there some architectural flaw preventing implementing this?

Please provide some feedback on this, as this is a dealbreaker for me (currently paying customer) - will have to switch to another solution.

Yakub
4 - Data Explorer
4 - Data Explorer

Adding my voice to this. I have a table of clients with a “client code” column where I’d like to enter a unique 3-letter code for each client. This is typed manually, but I need an alert if the code is already in use.

William_Galindo
4 - Data Explorer
4 - Data Explorer

This is a must have small companies with not resources to hire a developer or skills to use access or filemaker, should have a way to prevent duplicated records there are many situations where simple forms required deduplicate like job applications, permit records, receipts, employee ids, etc etc, should not be that hard to code for a airtable talented developers