Skip to main content

Lookup / Rollup of Multi Selects field glitch

  • July 29, 2022
  • 10 replies
  • 96 views
J

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

10 replies

Hannah_Wiginton
Forum|alt.badge.img+19

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

---Hannah - On2Air.com - Automated Backups for Airtable
ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • July 29, 2022

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

Hannah_Wiginton
R
Forum|alt.badge.img+4

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

Hannah_Wiginton
Forum|alt.badge.img+19

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.

---Hannah - On2Air.com - Automated Backups for Airtable
Hannah_Wiginton
Forum|alt.badge.img+19

Here’s @kuovonne’s fix:

---Hannah - On2Air.com - Automated Backups for Airtable
Hannah_Wiginton
Forum|alt.badge.img+19

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


Thanks, @ScottWorld!

---Hannah - On2Air.com - Automated Backups for Airtable
J
  • Jared_Wright1
  • Author
  • New Participant
  • July 29, 2022

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


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?

Justin_Barrett
Forum|alt.badge.img+21

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.

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • July 29, 2022

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?


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.

J
  • Jared_Wright1
  • Author
  • New Participant
  • July 30, 2022

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

Terms & ConditionsAccessibility statement