Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 28, 2022 11:21 PM
When I create a lookup field of a multi select field I get the new updated version seen here
However after reading recommendations in this forum when I try and create and arrayunique() from the look up it is not successful. (See Pictures)
I have found that If I convert the lookup to a rollup and back again the I get the result that I am looking for. (See Pictures)
I have gone back and forth from Lookup to rollup and I get the same result every time. I get the feeling that this is some kind of glitch or bug. Please give me any feed back that you can.
See video for better clarification VIDEO
Jul 29, 2022 12:03 PM
Hmm. Maybe some sort of circular reference? Wonder if @Justin_Barrett has any thoughts on this!
Jul 29, 2022 12:06 PM
It’s a known bug in Airtable, confirmed by Airtable support. Workarounds in this thread: Rollup Array Unique?
Jul 29, 2022 12:08 PM
Look in the select options. Are you SURE there’s only one of each option?
Jul 29, 2022 12:10 PM
I was able to replicate what he’s seeing. It’s crazy. :laughing:
Here’s my variety of rollup/lookup/formula fields to try it.
Jul 29, 2022 12:11 PM
Here’s @kuovonne’s fix:
Jul 29, 2022 12:13 PM
Thanks, @ScottWorld!
Jul 29, 2022 12:26 PM
This does not offer a solution that I have not already come up with. If you watch my video in the post that I made I did exactly what was mentioned in the post you mentioned. Do you know if there Is a better solution than what I am already doing?
Jul 29, 2022 12:46 PM
Wow! That’s totally bizarre! I’ve never hit these precise circumstances to trigger this odd behavior (definitely a bug!), but I’ll certain remember it if it comes up in the future.
Jul 29, 2022 01:40 PM
Oh, I didn’t see your video link. I’ll have a look at that later. I’m sure I won’t have any solutions for you because it sounds like a bug, but I’ll take a look at what’s going on. Be sure to email support@airtable.com about it.