# Array Columns no longer generating relations?

**URL:** <https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935>\
**Category:** Report a Bug\
**Created:** [February 26, 2020, 2:58am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935 "2020-02-26T02:58:01Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 26, 2020, 2:58am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/1 "2020-02-26T02:58:01Z")

</div>

My app’s URL: [itemstore.glideapp.io](http://itemstore.glideapp.io)

Suddenly this evening, the multiple relations I had set up off of an array column disappeared:

1. ✅Sheet is set up correctly  

2. ✅Array Column is visible  

3. ✅ Relation Sheet values named the same:  
 ![Screen Shot 2020-02-25 at 10.09.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/40616fb364db212bcfc5c49789dfe3907120aabf.png)

4. ⁉ Relation of array column to the second sheet is now empty?!  

Should look like this (grabbed from a recent vid I made):

 ![Screen Shot 2020-02-25 at 9.57.27 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/681116e459aaf12b9b2213162d34459977360f4c.png)

---

<div class="post-metadata">

**Author:** ![Alfonso\_Aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfonso_aguilar/32/3833_2.png) [@Alfonso\_Aguilar](https://community.glideapps.com/u/Alfonso_Aguilar)\
**Post date:** [February 26, 2020, 3:42am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/2 "2020-02-26T03:42:23Z")

</div>

Hi @Robert_Petitto!

I just had the same problem some minutes ago. I had just finished setting up a relation between two Array columns in different tabs and a Lookup column to retrieve data through that relation. It worked like a charm for some time until my app stopped working and all the columns containing data were empty.

In case this can help, a platform update took place more or less at the same time everything stopped working. As a result of the update, among other things, the “upgrade to pro” and “share app” buttons had been relocated to a different place.

After trying to solve the problem unsuccessfully, I decided to build a [simple app](https://array-relation.glideapp.io) from scratch, with nothing more than an array relation between two basic tables, but it did not work either.

I hope this is just a bug and everything goes back to normal soon. Setting up array relations is a very useful resource that makes GlideApps very powerful!

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [February 26, 2020, 3:51am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/3 "2020-02-26T03:51:24Z")

</div>

I’m on it.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 26, 2020, 3:51am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/4 "2020-02-26T03:51:57Z")

</div>

Whew…okay. So nothing I did (probably). Any ideas, @Mark?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 26, 2020, 3:53am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/5 "2020-02-26T03:53:52Z")

</div>

Mark be like  
 ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a2ef11dcb733eef6f4f7f758fc4ffb33d680aace.gif)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 26, 2020, 4:10am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/6 "2020-02-26T04:10:29Z")

</div>

Yeah…same thing happening in 3 other columns as well in my app. Any relation column that’s referencing an array column is coming up empty.

 ![Screen Shot 2020-02-25 at 11.09.23 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/283984026e593538928b2de8c5f6d6ac63fb46b0.png)

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [February 26, 2020, 4:13am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/7 "2020-02-26T04:13:20Z")

</div>

This captures reality more accurately:

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3b14265a16907728605ecebc2dc0870042857495.gif) ](https://media.giphy.com/media/h36vh423PiV9K/giphy.gif)

In any case, a fix should land in 30 minutes or so. Apologies for the distruption.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 26, 2020, 4:14am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/8 "2020-02-26T04:14:43Z")

</div>

Ha…no worries. Going to bed anyway…when I wake up, I’ll realize it had only been a dream.

---

<div class="post-metadata">

**Author:** ![Alfonso\_Aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfonso_aguilar/32/3833_2.png) [@Alfonso\_Aguilar](https://community.glideapps.com/u/Alfonso_Aguilar)\
**Post date:** [February 26, 2020, 4:18am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/9 "2020-02-26T04:18:45Z")

</div>

Great, thanks! 👍

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [February 26, 2020, 5:02am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/10 "2020-02-26T05:02:23Z")

</div>

Should be fixed now. Could you please confirm, @Alfonso_Aguilar?

---

<div class="post-metadata">

**Author:** ![Alfonso\_Aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfonso_aguilar/32/3833_2.png) [@Alfonso\_Aguilar](https://community.glideapps.com/u/Alfonso_Aguilar)\
**Post date:** [February 26, 2020, 5:17am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/11 "2020-02-26T05:17:08Z")

</div>

Now it works! Many thanks @Mark for fixing it so quickly.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 26, 2020, 9:04am UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/12 "2020-02-26T09:04:54Z")

</div>

Fixed…thanks!

---

<div class="post-metadata">

**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\
**Post date:** [February 26, 2020, 8:05pm UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/13 "2020-02-26T20:05:24Z")

</div>

I’m suffering the same bug right now. Any column that’s an array of several numbered columns is no longer recognized in a relation. Not sure when this began but pretty much every list, relation, or inline list component that relies on a relation column made up of a relationship with an array column is currently blank in my app. I’m assuming it’s the same bug you guys were discussing yesterday and likely my app was affected then too… but whatever fix you did @Mark, it didn’t fix it in mine.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [February 26, 2020, 8:07pm UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/14 "2020-02-26T20:07:37Z")

</div>

@John_Cabrera Could you point me to the app and tell me exactly what to do to reproduce the bug?

---

<div class="post-metadata">

**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\
**Post date:** [February 26, 2020, 8:09pm UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/15 "2020-02-26T20:09:53Z")

</div>

Ugh, I was afraid you’d ask that. My app is whitelisted and I’m trying to keep it under wraps as I build.

Currently crippling my app since most of my relation columns are with array columns. Can I post some images as @Robert_Petitto did?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 26, 2020, 8:11pm UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/16 "2020-02-26T20:11:08Z")

</div>

You can pm him the link. They can bypass the whitelist.

---

<div class="post-metadata">

**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\
**Post date:** [February 26, 2020, 8:22pm UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/17 "2020-02-26T20:22:12Z")

</div>

So here’s what I have in one of my sheets. The JID column of this sheet is relating to an array of two columns in the Lor sheet each called JID\_1 and JID\_2 ( together called JID\_ )

![Annotation 2020-02-26 121545](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0a078e557e09891e76ee1d2c5a27ab26f1b9da12.png)

And if I change this to only relate to one of the two columns (in this case JID\_1), the data returns… of course, only for that one column.

![Annotation 2020-02-26 121742](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c620802681c49c4aa8348936f8dcc38dd921ea2f.png)

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [February 26, 2020, 10:09pm UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/18 "2020-02-26T22:09:29Z")

</div>

Should be fixed in about 30 minutes. This affected relations going between array columns and individual number columns.

---

<div class="post-metadata">

**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\
**Post date:** [February 26, 2020, 11:19pm UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/19 "2020-02-26T23:19:16Z")

</div>

All seems to be in order again. Thanks, @Mark.

---

<div class="post-metadata">

**Author:** ![Tanul\_Singh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tanul_singh/32/11084_2.png) [@Tanul\_Singh](https://community.glideapps.com/u/Tanul_Singh)\
**Post date:** [September 25, 2020, 2:35pm UTC](https://community.glideapps.com/t/array-columns-no-longer-generating-relations/4935/20 "2020-09-25T14:35:35Z")

</div>

Hi @Mark ,

I think I’m facing the same issue. I have a situation where I’m fetching all the students who have enrolled for a teacher. I’ve created a relation in the tutor table where tutor\_table.tutor\_name = student\_table.tutorname. The results are showing up in the data editor but the list at the front end editor is not recognising values and are showing up as blank.

I’ve dropped a PM as well with the app link. Would really appreciate it if you could help.

Regards,

Tanul
