Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Duplicate records in a linked field

Topic Labels: Base design
538 3
Showing results for 
Search instead for 
Did you mean: 

Hey Guys! Is there a way to do a unique setting for linked records. I only see ways to filter by empty/not empty and Contains/does not contain. I want to say, link to this field, unless value is already present. This will avoid duplicates in my linked field.

3 Replies 3

You can’t enforce it, but you can limit which records visually appear in the popup menu for the linked record field by choosing which view in the linked table it should pull its records from.

So you could create a view in the other table that is filtered to only show you records which haven’t yet been linked, and then change your linked record field in the original table to only show you records from that view.

Thank you. How do I create that new view? Will it also work when using the Search App?