# Confusion between "user in a sheet" and "signed-in-user"

**URL:** <https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519>\
**Category:** Ask for Help\
**Created:** [December 7, 2020, 8:43pm UTC](https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519 "2020-12-07T20:43:15Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charles\_de\_Taillac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/charles_de_taillac/32/17725_2.png) [@Charles\_de\_Taillac](https://community.glideapps.com/u/Charles_de_Taillac)\
**Post date:** [December 7, 2020, 8:43pm UTC](https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519/1 "2020-12-07T20:43:15Z")

</div>

Hello the community,

I make an app to help people in the same city to lend things.

So I have lots of people that can connect to the app, add things, see things available and call other people.

The problem:  
I link people to his objects with the email adress and a relation between the two sheets.  
But when I need to show information about the owner on the view of the object, I always have the information about the sign-in-user…

Can you help me ?  
Thanks !

---

<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:** [December 7, 2020, 8:50pm UTC](https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519/2 "2020-12-07T20:50:01Z")

</div>

Do you have a relation from the object sheet to the user sheet? I recommend a multiple relation because this lets you display in inline list that shows the object owners profile. If all you need is a name or email, then you can use a single relation from object to the user sheet. The single relation will allow you to create several lookup columns to get certain information out of a relation.

---

<div class="post-metadata">

**Author:** ![Charles\_de\_Taillac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/charles_de_taillac/32/17725_2.png) [@Charles\_de\_Taillac](https://community.glideapps.com/u/Charles_de_Taillac)\
**Post date:** [December 7, 2020, 9:09pm UTC](https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519/3 "2020-12-07T21:09:12Z")

</div>

Hello Jeff,

Thank you so much for your answer.  
Yes, I made the relation between object sheet and user sheet, and chose multiple relation.  
I need a name and a phone.  
I also created lookup columns, but I can’t see it, when I am in the component options.

 ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/77a482758a4267064e79d26365754460c23e7a10.png)

---

<div class="post-metadata">

**Author:** ![Charles\_de\_Taillac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/charles_de_taillac/32/17725_2.png) [@Charles\_de\_Taillac](https://community.glideapps.com/u/Charles_de_Taillac)\
**Post date:** [December 7, 2020, 9:10pm UTC](https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519/4 "2020-12-07T21:10:57Z")

</div>

The Lookup columns added on my object sheet do not appear in the choices in the component options.

---

<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:** [December 7, 2020, 9:34pm UTC](https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519/5 "2020-12-07T21:34:03Z")

</div>

If you are just trying to pull out specific values with the lookup, then the relation will need to be a single relation to make the lookup columns visible. Otherwise you are trying to fill a single value component with a lookup that could potentially hold up to thousands of values. A single relation will make the lookup a single value lookup that you can display in a single value component.

A multiple relation is useful if you want a direct link to the entire user profile, which has to be done with a multiple because lists don’t work with a single relation. Since that’s not what you are going for, the single relation will work fine.

If your Lookups are still unavailable after switching to a single relation, you may need to recreate them.

---

<div class="post-metadata">

**Author:** ![Charles\_de\_Taillac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/charles_de_taillac/32/17725_2.png) [@Charles\_de\_Taillac](https://community.glideapps.com/u/Charles_de_Taillac)\
**Post date:** [December 7, 2020, 10:24pm UTC](https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519/6 "2020-12-07T22:24:18Z")

</div>

Thank you so much. The problem is solved. I remade the relations, and it works.  
Thks.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 8, 2020, 12:38am UTC](https://community.glideapps.com/t/confusion-between-user-in-a-sheet-and-signed-in-user/19519/7 "2020-12-08T00:38:38Z")

</div>

For future considerations, if you absolutely need to use a multiple relation and don’t want to have both single & multiple, then you can use a single value column to bring back data from a multiple relation. I believe it works the same way as the lookup.
