Help

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

Lookup field - Avoid Duplicates

cancel
Showing results for 
Search instead for 
Did you mean: 
Sandeep
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.

Thanks!

4 Comments
Eli_Kent
7 - App Architect
7 - App Architect

This is fantastic. Thanks Sandeep!

Paul_Markovits
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 😞

matt_stewart1
7 - App Architect
7 - App Architect

10000% agree

yh-developer
4 - Data Explorer
4 - Data Explorer

Agreed, this is holding back a lot of workflows when it comes to building interfaces based on linked records