Duplicate records in a linked field

Topic Labels: Base design
2284 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?