# Multi-level Relation Column to display Calendar view

**URL:** <https://community.glideapps.com/t/multi-level-relation-column-to-display-calendar-view/2364>\
**Category:** Ask for Help\
**Created:** [November 25, 2019, 12:11am UTC](https://community.glideapps.com/t/multi-level-relation-column-to-display-calendar-view/2364 "2019-11-25T00:11:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [November 25, 2019, 12:11am UTC](https://community.glideapps.com/t/multi-level-relation-column-to-display-calendar-view/2364/1 "2019-11-25T00:11:13Z")

</div>

As the app setup gets more and more complex I’m struggling to solve this one…

**Objective** : In the user’s profile page (see below) I wish to list the `classes` (calendar view) that a user has `check-in` into.

**`Classes`**

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

**`Check-ins`** (I have created the correct `Lookup` columns)

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

**`Profile_placeholder`**

 ![57%20am](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/de751ad4a8dacecff2db394d52291d2c93546037.png)

**PROBLEM: I can not see the `Lookup` (Class, Date) columns created in the Check-ins sheet above**

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/513e72cd11c4c6455f89b0c051f23ea6a11e3af4.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:** [November 25, 2019, 12:22am UTC](https://community.glideapps.com/t/multi-level-relation-column-to-display-calendar-view/2364/2 "2019-11-25T00:22:49Z")

</div>

I haven’t studied your question or thought too hard on this answer, so forgive me if I’m way off, but sometimes you need to make sure your relation is a single (not multiple) relation. That will return a single lookup result which will help it show up in the list of available columns. Otherwise it’s treated as an array value and can’t be used in areas of the builder that require a single value.

---

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [November 25, 2019, 12:48am UTC](https://community.glideapps.com/t/multi-level-relation-column-to-display-calendar-view/2364/3 "2019-11-25T00:48:41Z")

</div>

aah! I didn’t know that - that was exactly the issue, I changed the relation to ‘not-mulitiple’ and I was able to see the single value lookup columns - thanks Jeff 🙂