# Using email address domain as filtering **URL:** \ **Category:** Ask for Help\ **Created:** [August 24, 2023, 12:53am UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325 "2023-08-24T00:53:12Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Glidewithme123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glidewithme123/32/63240_2.png) [@Glidewithme123](https://community.glideapps.com/u/Glidewithme123)\ **Post date:** [August 24, 2023, 12:53am UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325/1 "2023-08-24T00:53:12Z")
Hello. I am creating an app for many different businesses. I simply want to allow them to view their content without a lengthy registration or a lot of work from me. I am adding @domain.com in the rows that I want that company to view. I tried creating this email column as row owner, but that doesn’t work. I have tried adding filtering rules: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/92caa5518a0f83c2ae514f476d56ac49638eccfb.png) But this does not work either. Any help would be appreciated! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [August 24, 2023, 1:10am UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325/2 "2023-08-24T01:10:17Z")
This will need to be in a text column that’s set as the Role in the user’s table. > [@🛡️Roles and Row Owners DEMYSTIFIED](https://community.glideapps.com/t/roles-and-row-owners-demystified/22956): > > wave Hey all, I meant to share this earlier today—I spent some time last night playing around with Row Owners and Roles (two Glide features I don’t often get the chance to use) and ended up learning quite a bit. The result? Another tutorial video for you all about how and when to use Row Owners and Roles, their benefits and limitations. Enjoy! [[Glide: Row Owners and Roles DEMYSTIFIED] ](https://www.youtube.com/watch?v=RmMLZINOwjQ) Wondering WHY you can’t assign row owners to a computed column (If then else, lookup, template… ---
**Author:** ![Glidewithme123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glidewithme123/32/63240_2.png) [@Glidewithme123](https://community.glideapps.com/u/Glidewithme123)\ **Post date:** [August 24, 2023, 1:33am UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325/3 "2023-08-24T01:33:23Z")
Robert. Thank you. I have been watching a lot of your videos. But my main concern is that I still have to add in roles for every business member. Why doesn’t my filtering rule work in this instance? Is there any other Google sheets automation I can do to speed this up? ---
**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:** [August 24, 2023, 2:51am UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325/4 "2023-08-24T02:51:57Z")
> [@Glidewithme123](#): > > Why doesn’t my filtering rule work in this instance? Bit difficult to say, but it looks like you might be using “is included in” where you should be using “includes” - what does the Email column actually contain? Question: How important is data security? That is, if a user from one company is able to discover the data of another company, would that be a problem? If it would, then filtering is not the correct solution. ---
**Author:** ![Glidewithme123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glidewithme123/32/63240_2.png) [@Glidewithme123](https://community.glideapps.com/u/Glidewithme123)\ **Post date:** [August 24, 2023, 4:57am UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325/5 "2023-08-24T04:57:52Z")
Mr Murphy, thank you for your response. Filtering by company is sufficient for their usage. They just want to see their own data pertaining to their company, but none is sensitive for an individual user. My email column contains “@domain.com” In theory the statement should work, but it never gave me the desired outcome. I knowingly tried every _operator_ available, but none of them gave me the results I desired. I swapped values and effects as well :(. ---
**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:** [August 24, 2023, 10:12am UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325/6 "2023-08-24T10:12:52Z")
I just did a quick test, and it works for me. Email in user profile is `darren@example.com`. With filter: ![CleanShot 2023-08-24 at 18.10.26@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b5b9fb27b952efd71e2289ae6bed594644d79374.png) Without filter: ![CleanShot 2023-08-24 at 18.10.43@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df38886dc1322a3e40a47be0ba5dbc497f0851bc.png) Do you have Row Owners in the mix anywhere? ---
**Author:** ![Glidewithme123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glidewithme123/32/63240_2.png) [@Glidewithme123](https://community.glideapps.com/u/Glidewithme123)\ **Post date:** [August 24, 2023, 4:59pm UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325/7 "2023-08-24T16:59:23Z")
You are a genius, thank you. I got it working. There were empty fields under my email column and was including all data. I added a 2nd condition and it worked like a charm. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/1879cdac93cfcd9730ac75a76ae443bcfe297366.png) ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [August 31, 2023, 5:00pm UTC](https://community.glideapps.com/t/using-email-address-domain-as-filtering/65325/8 "2023-08-31T17:00:15Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.