Jun 14, 2021 08:08 AM
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.
Jun 14, 2021 09:02 AM
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.
Jun 14, 2021 09:04 AM
Thank you. How do I create that new view? Will it also work when using the Search App?
Jun 14, 2021 09:06 AM