# Filter by signed-in user, where email is blank

**URL:** <https://community.glideapps.com/t/filter-by-signed-in-user-where-email-is-blank/3955>\
**Category:** Ask for Help\
**Created:** [January 25, 2020, 6:17am UTC](https://community.glideapps.com/t/filter-by-signed-in-user-where-email-is-blank/3955 "2020-01-25T06:17:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mattbrowning](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattbrowning/32/32_2.png) [@mattbrowning](https://community.glideapps.com/u/mattbrowning)\
**Post date:** [January 25, 2020, 6:17am UTC](https://community.glideapps.com/t/filter-by-signed-in-user-where-email-is-blank/3955/1 "2020-01-25T06:17:22Z")

</div>

Further to [this thread](https://community.glideapps.com/t/help-what-happened-to-the-filter-by-signed-in-user/3689), there is a workaround for people who still want some of the old functionality for signed-in users.

Previously, if you ticked the box “Filter by signed-in user” on a particular component, that would then show if there was either that person’s email address on that row, or if the email address row was blank. Now it doesn’t.

If you would like to keep this functionality then you just need to add a new column in the Glide data editor:

1. Give it whatever label you want (For this purpose I call mine Email\_check)
2. The column type is If ➡ Then ➡ Else
3. Under Cases, the first If will be:  
a. The first case will be: If Email is signed-in user then enter value: Yes  
b. The second case will be: If Email is empty then enter value: Yes  
c. Else No

Then in the Glide Layout editor, I can use this with the Visibility or Filter to show data based on Email\_check is Yes.

I hope that helps, sing out if not and I can steer you through it!

---

<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:** [January 25, 2020, 5:01pm UTC](https://community.glideapps.com/t/filter-by-signed-in-user-where-email-is-blank/3955/2 "2020-01-25T17:01:42Z")

</div>

Just want to add that this should still work on the filter under the features tab if you add an ‘or’ and set to the email column to ‘is empty’. Your idea may work better if people start needing multiple filters though.

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

---

<div class="post-metadata">

**Author:** ![mattbrowning](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattbrowning/32/32_2.png) [@mattbrowning](https://community.glideapps.com/u/mattbrowning)\
**Post date:** [January 26, 2020, 12:16am UTC](https://community.glideapps.com/t/filter-by-signed-in-user-where-email-is-blank/3955/3 "2020-01-26T00:16:05Z")

</div>

Ahh yes, good point Jeff, I didn’t clarify that - it’s for the case when you want multiple filters as well as the old “Filter by signed-in user” where people can see data assigned to their email address or rows with blank email addresses. Thanks for clarifying.

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [January 26, 2020, 9:10am UTC](https://community.glideapps.com/t/filter-by-signed-in-user-where-email-is-blank/3955/4 "2020-01-26T09:10:16Z")

</div>

Thanks, nice workaround