# Missing items data

**URL:** <https://community.glideapps.com/t/missing-items-data/65402>\
**Category:** Ask for Help\
**Created:** [August 25, 2023, 8:41pm UTC](https://community.glideapps.com/t/missing-items-data/65402 "2023-08-25T20:41:12Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cem\_Kaan\_KOSALI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cem_kaan_kosali/32/63274_2.png) [@Cem\_Kaan\_KOSALI](https://community.glideapps.com/u/Cem_Kaan_KOSALI)\
**Post date:** [August 25, 2023, 8:41pm UTC](https://community.glideapps.com/t/missing-items-data/65402/1 "2023-08-25T20:41:12Z")

</div>

I have two more Columns but I can not find them on layout items data.

 ![resim](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c4d3ef17bfd8c0227259fa9f9531a97954f949f.png)  
 ![resim](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/01edbcbeb3c5b8386f06e22672929024b01b01c1.png)  
What can I do to make **relation** or **lookup** columns show in **items data** section?

---

<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:** [August 25, 2023, 9:41pm UTC](https://community.glideapps.com/t/missing-items-data/65402/2 "2023-08-25T21:41:45Z")

</div>

Relations don’t show up because they are links to entire rows and not a specific column. A lookup will work, but the source relation needs to be a single relation. If it’s a multiple relation then the lookup will be an array. You can’t place an array of multiple items into something that can only hold a single item. So the solution in this case is to change your relation to a single relation so the lookup becomes a single item instead of an array. Then you can choose that lookup column.

---

<div class="post-metadata">

**Author:** ![Cem\_Kaan\_KOSALI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cem_kaan_kosali/32/63274_2.png) [@Cem\_Kaan\_KOSALI](https://community.glideapps.com/u/Cem_Kaan_KOSALI)\
**Post date:** [August 26, 2023, 4:32am UTC](https://community.glideapps.com/t/missing-items-data/65402/3 "2023-08-26T04:32:49Z")

</div>

#### Unfortunately relation is already one-to-one

My relation is already one-to-one but still I don’t see **computer** under **items data** of Employees Collection.

### Relation Data Table

 ![resim](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bda9225a63f9e63547588d6f6415cfa0d43a6acb.png)

### Layout

 ![resim](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f029895ed04201221d47697438cdc7987a57b51.png)

##### My Project is Public please feel free to check it out.

[https://lockit-prototype-2.glide.page](https://lockit-prototype-2.glide.page)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 26, 2023, 4:56am UTC](https://community.glideapps.com/t/missing-items-data/65402/4 "2023-08-26T04:56:33Z")

</div>

I suspect that your lookup column is referencing the relation via the source table instead of directly. Can you show how the Lookup column is configured please?

---

<div class="post-metadata">

**Author:** ![Cem\_Kaan\_KOSALI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cem_kaan_kosali/32/63274_2.png) [@Cem\_Kaan\_KOSALI](https://community.glideapps.com/u/Cem_Kaan_KOSALI)\
**Post date:** [August 26, 2023, 4:57am UTC](https://community.glideapps.com/t/missing-items-data/65402/5 "2023-08-26T04:57:51Z")

</div>

Lookup just copies from left column

 ![resim](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/7125be45b6c998cefbfb5fef01a3b658501d9451.png)

But still **I can not see any computed columns**

 ![resim](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e823b1e2e2297b168bee1bddd6337a5de6a795f1.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 26, 2023, 5:01am UTC](https://community.glideapps.com/t/missing-items-data/65402/6 "2023-08-26T05:01:51Z")

</div>

Yes, that’s the problem. You’re not referencing the relation directly.

Look for something like this 👇

 ![CleanShot 2023-08-22 at 11.39.46@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/261d89224ba6757a4d77bbba238a8f7588fd4023.png)

---

<div class="post-metadata">

**Author:** ![Cem\_Kaan\_KOSALI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cem_kaan_kosali/32/63274_2.png) [@Cem\_Kaan\_KOSALI](https://community.glideapps.com/u/Cem_Kaan_KOSALI)\
**Post date:** [August 26, 2023, 5:08am UTC](https://community.glideapps.com/t/missing-items-data/65402/7 "2023-08-26T05:08:25Z")

</div>

Thanks  
**I should lookup in created relation TABLE not column**

 ![resim](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/c/bc43ba866afc1ab7e96d5392ebf003e1896b7c20.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 26, 2023, 5:11am UTC](https://community.glideapps.com/t/missing-items-data/65402/8 "2023-08-26T05:11:40Z")

</div>

Now you’re cooking with gas 👍

Any time you see a “bubble” around the values in the Data Editor, that’s an indication that the value is an array. Sometimes it can be useful the way you had it originally, but not if you just want a single value that you can use in a text type component on the screen.
