Remove duplicates in look up field
Come on Airtable, throw me a freakin’ switch! I (and many others) have been asking for this for over 3 years now! There’s been a US presidential election and a global pandemic in the interim, and all we’re asking for here is a wee little switch that does the ARRAYUNIQUE() function.
In case y’all forgot…
Is it correct that the rollup & automated entry on update workaround only functions for entering items into a choice select field, but not into a multiple link field? Even if the string matches when manually typing it into the link field?
Like so:
If it matters, the Entry Grid is pulling from the Sync Grid in their mutual origin base and they are both sync’d to this destination base.
The project here is adapting Airtable’s sample “legal analysis” template so each instance of the template can draw upon a common source base relating points of law to their supporting cases and code sections.
The original discussion of this technique was talking about input to linked item fields, not choice fields, so I’m not sure what’s up with the behavior I’m seeing. I did have to use SUBSTITUTE(ARRAYJOIN(ARRAYUNIQUE(values)), '"', '') in the rollup to strip the quotation marks that appear when manipulating sync’d data, as opposed to just ARRAYUNIQUE(values) – does that have something to do with it?
The log appears to indicate permission errors, but that doesn’t make a lot of sense…
"Updating the record failed due to insufficient permissions.
Learn how to fix common issues…
You first, Airtable.
