Help

Lookup / Rollup of Multi Selects field glitch

Topic Labels: Formulas
1428 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Jared_Wright1
4 - Data Explorer
4 - Data Explorer

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)
image
image

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)

image
image

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

10 Replies 10

Hmm. Maybe some sort of circular reference? Wonder if @Justin_Barrett has any thoughts on this!

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable

It’s a known bug in Airtable, confirmed by Airtable support. Workarounds in this thread: Rollup Array Unique?

Look in the select options. Are you SURE there’s only one of each option?

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.

2022-07-29_14h09_03

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable

Here’s @kuovonne’s fix:

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable

Thanks, @ScottWorld!

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable

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?

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.

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.

I will contact support