- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 29, 2022 12:03 PM
Hmm. Maybe some sort of circular reference? Wonder if @Justin_Barrett has any thoughts on this!
Hannah - On2Air.com - Automated Backups for Airtable
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 29, 2022 12:06 PM
It’s a known bug in Airtable, confirmed by Airtable support. Workarounds in this thread: Rollup Array Unique?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 29, 2022 12:08 PM
Look in the select options. Are you SURE there’s only one of each option?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Hannah - On2Air.com - Automated Backups for Airtable
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 29, 2022 12:11 PM
Here’s @kuovonne’s fix:
Hannah - On2Air.com - Automated Backups for Airtable
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 29, 2022 12:13 PM
Thanks, @ScottWorld!
Hannah - On2Air.com - Automated Backups for Airtable
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.