# Relation Column doesn't work on array column

**URL:** <https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300>\
**Category:** Ask for Help\
**Created:** [May 1, 2020, 4:58pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300 "2020-05-01T16:58:16Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 1, 2020, 4:58pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/1 "2020-05-01T16:58:16Z")

</div>

Hey,

I have a Conference Sheet With Speaker 1 & Speaker 2(each one is an email)  
I have Users with Email Column

I’m trying to get all the Conferences a user hosting.

So on Users I’m building a new Relation Column Linking Email to Conference Sheet and Speaker Array Column.

Some How it doesn’t work.  
If I link to Speaker 1 or Speaker 2 works fine.  
But I want to Link to Either one of them.  
Maybe Because the Speaker should be a specific type? I made sure all of them is the same Email Type

Thanks

---

<div class="post-metadata">

**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\
**Post date:** [May 1, 2020, 5:46pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/2 "2020-05-01T17:46:55Z")

</div>

You’ll need to make a relation from the Conference to the speakers. Once you click on the conference, you’ll want to stack inline lists - one for speaker 1, and one for speaker 2. You can delete the labels for both lists to make it look like one list.

Here’s a sample I quick threw together to play with: [yzird.glideapp.io](http://yzird.glideapp.io)  
Make a copy and look under the hood.

And here’s a pic showing where to change the inline list label.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/068323e2388f3cea929e59f51c06324f48856d92.png)

---

<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:** [May 1, 2020, 6:19pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/3 "2020-05-01T18:19:44Z")

</div>

Maybe I’m not following, but ‘Speak 1’ and ‘Speaker 2’ should have created a virtual ‘Speaker’ array column. This should be accessible for relations to use.

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 1, 2020, 6:37pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/4 "2020-05-01T18:37:40Z")

</div>

> [@Tim\_Sullivan](#):
>
> ake a relation from the Conference to the speakers

But i want the other way around.  
From Users to bring its Conferences

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 1, 2020, 6:37pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/5 "2020-05-01T18:37:55Z")

</div>

> [@Leon\_Kol](#):
>
> Correct. I thought so too.  
> But now that I want to use it from Users sheets. User.Email → Conferences.Speaker.  
> It doesn’t catch the Conferences

Correct. I thought so too.  
But now that I want to use it from Users sheets. User.Email → Conferences.Speaker.  
It doesn’t catch the Conferences

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 1, 2020, 6:59pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/6 "2020-05-01T18:59:16Z")

</div>

Correct. I thought so too.  
But now that I want to use it from Users sheets. User.Email -\> Conferences.Speaker.  
It doesn’t catch the Conferences

---

<div class="post-metadata">

**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\
**Post date:** [May 1, 2020, 7:50pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/7 "2020-05-01T19:50:20Z")

</div>

Look at my app again - I reworked it for you.

---

<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:** [May 2, 2020, 1:02pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/8 "2020-05-02T13:02:21Z")

</div>

I might need a visual, like a screenshot or video. I’m not picturing why it wouldn’t work.

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 2, 2020, 3:21pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/9 "2020-05-02T15:21:44Z")

</div>

After a refresh and deleting the data it worked

Do you know why?

---

<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:** [May 2, 2020, 3:27pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/10 "2020-05-02T15:27:25Z")

</div>

No idea.

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 3, 2020, 9:04pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/11 "2020-05-03T21:04:51Z")

</div>

Today It Happened again.  
It took some time for the data to update and the relation to be shown.

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 4, 2020, 8:20pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/12 "2020-05-04T20:20:48Z")

</div>

I Dont know what to do.  
Please help.  
A relation that was working, stopped.  
I didn’t change any data

---

<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:** [May 4, 2020, 8:56pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/13 "2020-05-04T20:56:56Z")

</div>

Like I mentioned earlier:

> [@Jeff\_Hager](#):
>
> I might need a visual, like a screenshot or video. I’m not picturing why it wouldn’t work.

Anything you can provide would help…the data viewer, any settings you have for your relation columns, and anything else you can think of that would define what’s not working.

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 4, 2020, 10:42pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/14 "2020-05-04T22:42:43Z")

</div>

Can I send it to mail?

Cant publish like this @Jeff_Hager

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 5, 2020, 7:12pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/15 "2020-05-05T19:12:55Z")

</div>

Hey ,  
Can you you help?please  
I have a almost ready app and because of this issue i cant launch it

@Robert_Petitto  
@Mark

---

<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:** [May 5, 2020, 7:21pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/16 "2020-05-05T19:21:57Z")

</div>

Could you please share your app and make a video explaining what the issue is?

---

<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:** [May 5, 2020, 7:23pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/17 "2020-05-05T19:23:54Z")

</div>

What’s the issue? Sorry, I haven’t been following this thread? A relation stopped working? Is it related to this bug I noticed earlier in the week?

[![](https://img.youtube.com/vi/Km-cWnKY0qA/hqdefault.jpg "Glide Bug: Relations Reverting to other type upon refresh") ](https://www.youtube.com/watch?v=Km-cWnKY0qA)

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 5, 2020, 8:45pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/18 "2020-05-05T20:45:53Z")

</div>

hey mark,

I sent a p.m with a video.  
Basically,  
I had a working relation between a column & array column in different sheet.  
With no data change i stopped working.  
But if i choose a single column instead of a array column…it works fine.  
The previous time i had to delete this relation and refresh and after some time it was working  
now i cant do it because i have a lot depending on that relation.

hey @Robert_Petitto,  
Yes , relation stopped working.  
I will check the video to so if its relatable

---

<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:** [May 5, 2020, 9:15pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/19 "2020-05-05T21:15:45Z")

</div>

@Robert_Petitto If you do this now, Glide should give you a warning that the change you’re making will delete other dependent columns. When did you make that video?

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [May 5, 2020, 9:19pm UTC](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300/20 "2020-05-05T21:19:23Z")

</div>

Okay Robert, I experience something similar when I create a lookup to a relation column which I then try to change or revert to multiple. In fact I lose all lookups created for the relation. But recently I’ve been getting glide pop ups on my screen warning me that if a relation is deleted then others related to it will be deleted. But, I don’t get one for when I’m changing from single to multiple match.

[Next page](https://community.glideapps.com/t/relation-column-doesnt-work-on-array-column/8300.md?page=2)
