# How to filter by signed-in user - Glide doesn't show automatically created Users relation column

**URL:** <https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307>\
**Category:** Ask for Help\
**Created:** [October 21, 2019, 6:58am UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307 "2019-10-21T06:58:28Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![filipa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/filipa/32/190_2.png) [@filipa](https://community.glideapps.com/u/filipa)\
**Post date:** [October 21, 2019, 6:58am UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307/1 "2019-10-21T06:58:28Z")

</div>

I can’t figure out how to do this… I need to use an Inline list filtered by signed-in user, to show only products that belong to categories the user defined as his favorites.  
For example:  
I am interested in Literature in Portuguese / Music / Architecture.  
When I open the app, I will see the New products that arrived, filtered by the categories that I’m interested in.

 ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/ff40c31ec03420f4d993622eaaaeec90ae8df4fe.png)  
I thought I could use the automatically created “User relation” column,  
 ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0114c82e21eb398d89f12cdba12ab3ac0e15c008.png)  
but this column isn’t listed as a choice in the “User email” menu.  
 ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dc264d16dc54756ecc7ce012f37c708ef82e2223.png)

My app: [https://t3wff.glideapp.io](https://t3wff.glideapp.io)  
Google sheet: [LP Macau Draft 1 - Google Sheets](https://docs.google.com/spreadsheets/d/1NDPEhQztlho_V22qSpUgm4U29Oay6A9mDewBfR3H3ec/edit?usp=sharing)

---

<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:** [October 21, 2019, 11:53am UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307/2 "2019-10-21T11:53:33Z")

</div>

I’ve hit this wall as well, but I’m taking a slightly different approach. I’m building a delimited list of emails in one column, so the list looks like this: fakeemail1@email.com|fakeemail2@email.com|[fakeemail3aemail.com](http://fakeemail3aemail.com). I was hoping to use a Contains filter, but I can’t access the logged in users email for the filter. I’m wondering if my method would work for Per User Sata, since it would be an accessible column. I might have to try it later. I think in your case, reference columns aren’t accessible for some uses.

---

<div class="post-metadata">

**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\
**Post date:** [October 22, 2019, 9:04am UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307/3 "2019-10-22T09:04:19Z")

</div>

See [[Video Tutorial] Always show the last 4 items in your home screen](https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270)

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [December 21, 2019, 7:27am UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307/4 "2019-12-21T07:27:51Z")

</div>

Filipa How did you solve it?

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [December 21, 2019, 10:53am UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307/5 "2019-12-21T10:53:14Z")

</div>

Looks like the User column you’re trying to use is a relation. To get the email to show up as a field to choose, add a lookup that pulls in the email. It will look redundant in the Data editor, but I think this should get you what you need.

---

<div class="post-metadata">

**Author:** ![simpler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simpler/32/1379_2.png) [@simpler](https://community.glideapps.com/u/simpler)\
**Post date:** [March 25, 2020, 3:10pm UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307/6 "2020-03-25T15:10:29Z")

</div>

@kyleheney, can you explain this more clearly? I would like users to pick items and keep in the favourites list, should I use the new array row owners function?

---

<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 28, 2020, 3:54pm UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307/7 "2020-03-28T15:54:34Z")

</div>

@kyleheney is just stating that you cannot use a relation column to display or filter by a specific value in the relation. A relation is simply a referenced to a row or a set of rows in a different sheet. You need to add a Lookup column in addition to the relation to pull out a specific column value from that relation.

As for your second question. Not know anything about your app, it sounds like you would just need a form button on each item for a user to submit an item to their favorites. Here’s an example: [https://6pbvq.glideapp.io/](https://6pbvq.glideapp.io/). Or you could have a form button with several choice components and a user would simply select all of the items they want in one shot. With this method, you would set up an array of columns (‘Item 1’, ‘Item2’, ‘Item 3’, etc)

---

<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:** [February 4, 2024, 4:33am UTC](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307/8 "2024-02-04T04:33:10Z")

</div>


