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.
@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 😞
