# Data Relation Error?

**URL:** <https://community.glideapps.com/t/data-relation-error/6155>\
**Category:** Report a Bug\
**Created:** [March 30, 2020, 5:29pm UTC](https://community.glideapps.com/t/data-relation-error/6155 "2020-03-30T17:29:08Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [March 30, 2020, 5:29pm UTC](https://community.glideapps.com/t/data-relation-error/6155/1 "2020-03-30T17:29:08Z")

</div>

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

Hi, not sure if this is a bug, or if I’m setting this up wrong in Sheets. But here it is: I want to display badges that staff members have earned. I want to be able to show multiple badges per teacher if they’ve earned multiple badges. So, here’s how I set it up in Sheets…

 ![glide-badges-error](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e2dfeef9db5bc472d484f8830984a601a0d9708c.png)

If you notice, I have Badge 1, Badge 2, Badge 3, etc. Not pictured is the separate tab that I created that lists the Badge names, descriptions, and Badge image.

I provided an [update](https://community.glideapps.com/t/data-relation-error/6155/2) below

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [March 30, 2020, 5:30pm UTC](https://community.glideapps.com/t/data-relation-error/6155/2 "2020-03-30T17:30:49Z")

</div>

I also have staff members that speak multiple languages, which you can see in see in the Sheets screenshot above. So, here’s what’s been generated in the Data tab. Keep in mind that I have not even created a Badges relation, even though it’s being displayed in Data. And for some reason, it’s not allowing me to edit it, or delete it.

 ![glide-databug](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7c06e5c06950dc191ab3aa59bfcc4f177d026319.png)

**UPDATE:** I deleted the Languages 2 column, and changed the Languages 1 header back to Language, and it removed the 2 relation columns, including the one I couldn’t edit. Same thing for Badges… I deleted the Badge 2, Badge 3, Badge 4, Badge 5 columns, and then renamed the Badge 1 header to Badge. And it resolved the issue. So, here’s my next question then…

**How can I set it headers within Sheets to display multiple languages and badges for a staff member?**

---

<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:** [March 30, 2020, 5:50pm UTC](https://community.glideapps.com/t/data-relation-error/6155/3 "2020-03-30T17:50:16Z")

</div>

By naming your columns Badge 1, Badge 2… Glide automatically creates an array combining those columns. Change your naming convention to 1st Badge, 2nd Badge, etc, and that shoudl solve your problem.

---

<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:** [March 30, 2020, 5:50pm UTC](https://community.glideapps.com/t/data-relation-error/6155/4 "2020-03-30T17:50:18Z")

</div>

Numbering columns consecutively will create an array column in glide. It’s not a relation although the icon is similar. Underneath it’s still Badge 1, Badge 2, etc.

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [March 30, 2020, 5:55pm UTC](https://community.glideapps.com/t/data-relation-error/6155/5 "2020-03-30T17:55:00Z")

</div>

Great, thanks so much. I’ll let you know if I have any other issues.

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [March 30, 2020, 5:57pm UTC](https://community.glideapps.com/t/data-relation-error/6155/6 "2020-03-30T17:57:32Z")

</div>

One more question: After renaming headers to 1st Badge, 2nd Badge, etc., do I then need to setup multiple relation for all those columns? Or how should I set this up?

Because I’d like to set it up within the app (I’m guessing with an inline list) to where it only displays the badge images that staff members have earned underneath a Basic Text of “Badges earned”.

---

<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:** [March 30, 2020, 6:00pm UTC](https://community.glideapps.com/t/data-relation-error/6155/7 "2020-03-30T18:00:40Z")

</div>

If you still want a multi relation, then I would name the columns like you had it before and use the array column generated for your relation to another sheet.

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [March 30, 2020, 6:01pm UTC](https://community.glideapps.com/t/data-relation-error/6155/8 "2020-03-30T18:01:38Z")

</div>

Is there a video that Glide has created for using arrays?

---

<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:** [March 30, 2020, 6:02pm UTC](https://community.glideapps.com/t/data-relation-error/6155/9 "2020-03-30T18:02:56Z")

</div>

[https://docs.glideapps.com/all/reference/data-editor/computed-columns/array-column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/array-column)

---

<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:** [March 30, 2020, 6:08pm UTC](https://community.glideapps.com/t/data-relation-error/6155/10 "2020-03-30T18:08:55Z")

</div>

> [@Jeff\_Hager](#):
>
> If you still want a multi relation, then I would name the columns like you had it before and use the array column generated for your relation to another sheet.

I agree with @Jeff_Hager.

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [March 30, 2020, 6:16pm UTC](https://community.glideapps.com/t/data-relation-error/6155/11 "2020-03-30T18:16:59Z")

</div>

Boom. Just set it up. You guys rock!
