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?
Jun 29, 2021 04:52 AM
I’ve hit this problem too - and also found that if the Roll Up field (ARRAYUNIQUE(values)) is referencing a Multi-Select field in another table, then it unfortunately fails to parse as expected and will return duplicate string data. I’m working on figuring out another parse of the data to clean it up. =/
I reported this to support today. How annoy.
Oct 19, 2021 03:31 AM
Hey David,
I found a kinda “hacky” way to solve this with two Automations.
Step 1: Create a Linked Record Field
Step 2: Create the Rollup Field with ARRAYUNIQUE(values) as mentioned before
Step 3: Go to Automation Tab and hit new Automation
Setup as follows
Trigger:
“When record is created” →
Properties on the right:
Table: Select the table of the record
Add action:
“Update record” →
Properties on the right:
Table: Same as before
Record ID: Click the plus, select continue at “Record from step1” and select insert for “Airtable record ID”
Fields: Click “+ Choose field”, now choose the Linked Record Field you created at the beginning, now an empty bar with plus appears, click the plus and again select continue at “Record from step1” and select insert for the Rollup Field.
Now in the top left switch the button from “off” to “on”
Step 5: Repeat Step 3 but choose “When record is updated”
Done!
Now every time your record has a new Value in the Rollup Field it will get transported to the Linked Records field where the Records can be clicked and used as you like.
But it’s not instantaneous you have to wait a bit and it depends on your plan, how often you can trigger it… Pricing - Airtable
Dec 06, 2021 10:08 AM
thank you, @Jeremy_Oglesby ! That’s exactly what I was looking for.
Apr 10, 2022 04:14 PM
+1 @David_Krizan. This would be such a simple solution. Any response from Airtable on it in the past 3.5 years?
Oct 06, 2022 02:53 PM
So useful! Thanks so much for this workaround! Works like a charm. :slightly_smiling_face:
Dec 13, 2022 11:07 PM
Hey mate - how would you join those two lookup fields to show unique values on the third column?
For e.g. Bacon, onion, meat, vegetables etc
Apr 24, 2023 09:16 AM
+1 for "display unique values" toggle on the lookup field formatting options. Becomes absolutely essential with multiple levels of a linked record hierarchy.
Nov 06, 2023 12:28 PM - edited Nov 06, 2023 12:30 PM
Hi 👋, I came up with a pretty satisfying solution using the Scripting automation. You can find it here ✨