# Show user list

**URL:** <https://community.glideapps.com/t/show-user-list/28849>\
**Category:** Ask for Help\
**Created:** [July 8, 2021, 8:49am UTC](https://community.glideapps.com/t/show-user-list/28849 "2021-07-08T08:49:19Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![HollowFruits](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hollowfruits/32/28747_2.png) [@HollowFruits](https://community.glideapps.com/u/HollowFruits)\
**Post date:** [July 8, 2021, 8:49am UTC](https://community.glideapps.com/t/show-user-list/28849/1 "2021-07-08T08:49:19Z")

</div>

Hi there,

I’m building an events app where users can join (or leave events).  
If I’m showing a user list in the app, only the loggedin user is shown there.  
When I disable the “row owner” property, then my “Edit profile” page doesn’t show my info.

Can somebody explain me how I can:

- Show all users part of the app  
and
- Edit my profile details (name, email, photo)

 ![Screenshot 2021-07-08 at 10.46.08](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3df3cbe2729824d2adff39f716965df4e40474ec.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:** [July 8, 2021, 9:33am UTC](https://community.glideapps.com/t/show-user-list/28849/2 "2021-07-08T09:33:50Z")

</div>

If you’re not using row owners, then you’ll need to apply a filter “where email is signed-in user”

---

<div class="post-metadata">

**Author:** ![HollowFruits](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hollowfruits/32/28747_2.png) [@HollowFruits](https://community.glideapps.com/u/HollowFruits)\
**Post date:** [July 8, 2021, 9:58am UTC](https://community.glideapps.com/t/show-user-list/28849/3 "2021-07-08T09:58:40Z")

</div>

Where would I need that filter? On the edit profile page?

Currently it seems that “row owner” really hides all the data of the other app users, really annoying.  
All I want is to show a full list of every app user. But when I do that, I can’t seem to edit my own user data anymore (name, email).

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [July 8, 2021, 10:06am UTC](https://community.glideapps.com/t/show-user-list/28849/4 "2021-07-08T10:06:46Z")

</div>

Or you can do it in the back. Create a “private user sheet” and an “public user sheet”. You can do this with an array column in your spreadsheet, and basically double the user’s sheet. Then in the app you have your private user sheet with row owners and the other one open. You can also choose what information to send to the public sheet, that way you limit the information that you want to show from each user publicly

---

<div class="post-metadata">

**Author:** ![HollowFruits](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hollowfruits/32/28747_2.png) [@HollowFruits](https://community.glideapps.com/u/HollowFruits)\
**Post date:** [July 8, 2021, 10:49am UTC](https://community.glideapps.com/t/show-user-list/28849/5 "2021-07-08T10:49:44Z")

</div>

Awesome, thank you!

A few more questions:

- Once a new user signs in, how do I “automatically” duplicate the data into the public user sheet?
- How should I tackle the “edit profile” page? Will it be possible to adjust the data in the public user table? (set column?)

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [July 8, 2021, 10:55am UTC](https://community.glideapps.com/t/show-user-list/28849/6 "2021-07-08T10:55:27Z")

</div>

So it will be added automatically if you are using an array column. So when a new user signs up, that info should go to the private sheet, then with the array it will be copied for you. an example of array column would be as follows:  
=arraycolumn(‘PROFILES’!A2:C) Using this formula will take the first three columns of the user’s sheet and copy it in the new/public sheet

The public sheet should never be touched, otherwise the formula won’t work, all the edits should happen in the private sheet

---

<div class="post-metadata">

**Author:** ![HollowFruits](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hollowfruits/32/28747_2.png) [@HollowFruits](https://community.glideapps.com/u/HollowFruits)\
**Post date:** [July 8, 2021, 11:00am UTC](https://community.glideapps.com/t/show-user-list/28849/7 "2021-07-08T11:00:17Z")

</div>

Now it’s clear! Thank you so much for your approach.

One more thing though: Im using Glide 2.0 with Glide tables.  
Array columns aren’t supported yet in Glide tables, is there another approach?

---

<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:** [July 8, 2021, 11:45am UTC](https://community.glideapps.com/t/show-user-list/28849/8 "2021-07-08T11:45:02Z")

</div>

If you are only using glide tables, then use @Darren_Murphy’s suggestion.

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [July 8, 2021, 2:43pm UTC](https://community.glideapps.com/t/show-user-list/28849/9 "2021-07-08T14:43:53Z")

</div>

Yea, unfortunately this won’t work with Glide Tables as Jeff suggests

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/show-user-list/28849/10 "2024-01-17T16:51:40Z")

</div>


