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

Lookup field - Avoid Duplicates

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

Lookup field is great to consolidate the data from all the linked records into the parent Table cell.
But there can be a way to avoid duplicates while consolidating.

For example:
On Child Table, I have Collaborator assigned to each Row. But that same Collaborator can be on many rows.
On parent Table, it shows all the occurrence of that collaborator multiple times which is also great, but there can be an option to Merge Duplicates so it shows only Unique Entries.


7 - App Architect
7 - App Architect

This is fantastic. Thanks Sandeep!

5 - Automation Enthusiast
5 - Automation Enthusiast

@Sandeep did you ever figure out how to do this? I've got a base with lots of nested many to many relationships and am ending up with tons of duplicates in the base 😞