Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 18, 2017 10:58 PM
The result I am looking for is similar to the ARRAYUNIQUE function for a Rollup field. However, the results are a link to another table, and it seems that using a rollup can only show text results as opposed to clickable records. How can I make lookup field show only unique results, or make the unique results of a rollup field clickable?
Feb 03, 2020 12:32 PM
Hi David,
I did the Rollup + ArrayUnique{} and got text-only uniques as you pointed out. Then I changed the field type to Link Records and voila – the text now links.
Feb 03, 2020 01:09 PM
I know that that works, but what I really want here is to set a Lookup field that’s looking-up a Linked Record field in another Linked Record to only display unique fields as clickable linked records. Right now this works except the ability to display linked records (every linked record – including duplicates – is displayed). If there was simply a “Only display unique linked records” switch that would display when you’re looking up a linked record field, this would work.
I want to keep it how it currently works except having the ability to remove duplicates (showing duplicates here provides no value to me, but the converse would be incredibly valuable for many use cases).
Feb 03, 2020 02:56 PM
What’s the advantage of using Lookup instead of Rollup?
Feb 03, 2020 03:25 PM
They’re two different field types with their own pros and cons, but that’s a whole other topic altogether.
The advantage of a Lookup field in this instance is that looking-up up another Linked Record field will display the data in the typical clickable Linked Record bubble vs. the stripped-down/non-clickable string data that will come back in a Rollup field.
Difference
I’ve personally come across over a dozen use cases where I want this; conversely, I haven’t had a single use case where I actually wanted to display duplicate Linked Records.
Apr 12, 2020 09:32 AM
@David_Krizan has there been any movement on this from Airtable since this discussion was last live?
Apr 13, 2020 07:23 AM
Not as of yet. This has actually prevented me from using Airtable for a few use cases, so I really hope this common sense feature is added soon.
Jul 02, 2020 01:03 PM
I’ve tried this and the text does turn to linked records just as Lookups, and only the unique values remain - but in my case adding a new value that would cause another unique value to show does not work. The list of records is now static and not “rolled up” from existing records.
Really wish this was a feature. A simple toggle like it was proposed would be amazing.
Aug 14, 2020 03:07 AM
Agree with the Unique toggle feature, very important. Would be great to push for this, seems like a smiple win for both sides!
Jan 07, 2021 01:48 AM
Here is a video I made demonstrating the Rollup feature that helps return only the unique results in Lookup: https://youtu.be/MiyQQxSx7iQ
Thanks to @David_Krizan for the solution.
Mar 29, 2021 02:09 PM
+1 for this feature - also seems like a no brainer to only show a single linked record when doing a lookup (while preserving the interactivity of the link to that record)