Duplicate records in a linked field

[Zach_Ruben]

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.

[ScottWorld]

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.

[Zach_Ruben]

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

[ScottWorld]

Airtable Support

Guide to views

  Watch a training! Get started faster with Airtable     This article provides an overview of views within Airtable - how to use the view switcher, search, and create new views. ...