# How to apply "signed in user"filter except admin user

**URL:** <https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817>\
**Category:** Ask for Help\
**Created:** [August 10, 2020, 5:01pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817 "2020-08-10T17:01:47Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 10, 2020, 5:01pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/1 "2020-08-10T17:01:47Z")

</div>

Hi,

In my app, as a admin I can approve or reject client request. I want to filter so that user can see only own post/submission not others but admin user can see all post. When I apply filter ‘signed in user’ then i am also treated as user not admin, I am using single app for submission and approval. Here i have customized edit option to approve/reject any submission.

---

<div class="post-metadata">

**Author:** ![adelhammoud](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adelhammoud/32/5587_2.png) [@adelhammoud](https://community.glideapps.com/u/adelhammoud)\
**Post date:** [August 10, 2020, 5:11pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/2 "2020-08-10T17:11:59Z")

</div>

> [@Md\_Jakir\_Hossain](#):
>
> He

Add a column = role which can be either Admin or User.  
Add if condition (show component if User’s role is Admin or Record owner is sign-in user.

Refer to this good video by Glide

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [August 10, 2020, 5:30pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/3 "2020-08-10T17:30:19Z")

</div>

For additional security you could also use row owner on the email column in your users table and make this column an array column containing both the user’s email and an admin email.

Finally, depending on whether you need Pro app or not, you could of course use two apps, which can sometimes have advantages in terms of simplicity and, again, data security.

---

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 10, 2020, 5:48pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/4 "2020-08-10T17:48:28Z")

</div>

Hi,  
I’ve gone through everything properly but this is not what i am looking for, i want that when admin log in he can see all submission but user only can see his own submission;

---

<div class="post-metadata">

**Author:** ![adelhammoud](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adelhammoud/32/5587_2.png) [@adelhammoud](https://community.glideapps.com/u/adelhammoud)\
**Post date:** [August 10, 2020, 6:01pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/5 "2020-08-10T18:01:10Z")

</div>

I have to make some assumptions here as can’t see your App:

Assuming under sheet=users , there is a column called “Role” - and for each user row, this column is Admin or empty (empty means not-admin)

Assuming also you have a column in the sheet capturing submission info to store posted\_by\_user, hence ownership -  
In your form, the User’s email form this special form value will go to this “posted\_by\_user” column.

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

Now, under the inline list of all submitted records, going to visibility set two OR conditions

Condition 1: when posted\_by\_user = Sign-in User  
OR  
Condition 2: User\_Role=Admin

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

---

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 15, 2020, 7:45pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/6 "2020-08-15T19:45:30Z")

</div>

Hi,  
You helped to fix it almost, but I like to share something about my app.

In my app, there are two sheets one is user and other is user submission. As u suggested, it works for both admin and other user. But I need to know that when admin user can see all submitted data via inline list not directly from submission sheet where only signed in user can see not other. Is it possible to see all data from submission sheet as admin.

I thank you for your valuable suggestion.

---

<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:** [August 15, 2020, 10:43pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/7 "2020-08-15T22:43:49Z")

</div>

Not sure I catch what you mean in the last 2 sentences. How is it different from your first requirement, can you show some screenshots of what you want to achieve?

---

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 16, 2020, 4:58pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/8 "2020-08-16T16:58:32Z")

</div>

Hi,  
Here is my problem details: I have two sheet called Employee list and leave application. As admin I can edit data posted by other user and view them from User tab with help of inline list. That,s enough for now but how i can apply filter on second tab(leave application) so that admin can see all record from second tab but other users only their own.

First Pic:As admin I can see all data for respective user from ‘Employee list’ tab whereas user can see own data not others. (Working properly)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f86df40c5337f441d57cef56779e552108e1075b.jpeg)

Second Pic Here all records are seen but I like to apply filter so that admin can see all but others user only own data.

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

---

<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:** [August 16, 2020, 5:04pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/9 "2020-08-16T17:04:39Z")

</div>

How are you structuring the Leave Application sheet, I assume you only have the email of the employee who applied for leave?

---

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 16, 2020, 5:30pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/10 "2020-08-16T17:30:57Z")

</div>

Right u are.  
Here are more pics for Leave Application sheet.

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

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

---

<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:** [August 16, 2020, 11:03pm UTC](https://community.glideapps.com/t/how-to-apply-signed-in-user-filter-except-admin-user/13817/11 "2020-08-16T23:03:41Z")

</div>

You can filter the screen by email is signed in user or user’s role is Admin.

Another way is using an array column of 2 emails, assuming you only have 1 admin, populating email 1 as the employee email, email 2 as the admin email.
