# Email filtering in inline list **URL:** \ **Category:** Ask for Help\ **Created:** [March 9, 2020, 3:41am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298 "2020-03-09T03:41:17Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 9, 2020, 3:41am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/1 "2020-03-09T03:41:17Z")
Hi y’all. I’m struggling a bit with filtering by signed in user in an inline list. AS you can see below, I’m changing the email, however I still get the same results. I tried with an if-then column, however I can’t use that column in the filters… What do you recommend? Is there a way to filter the whole sheet by email (I remember seeing that in Glide’s previous version) so each user only sees the data they’re supposed to see? Thanks again, sheet: [Meser App - Glide - Google Sheets](https://docs.google.com/spreadsheets/d/1zDTVbsVx-qb1co7wdK-E48ZInxwV9nYraAgB_WDcaGg/edit?usp=sharing) app: [oiibv.glideapp.io](http://oiibv.glideapp.io) ![Kapture 2020-03-08 at 22.38.40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/fea2624a857672b8842d9302262eb8b6e3995095.gif) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [March 9, 2020, 3:46am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/2 "2020-03-09T03:46:52Z")
That is the visibility condition for the entire list, not individual list items. You want to add a Filter for this. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 9, 2020, 3:52am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/3 "2020-03-09T03:52:21Z")
You mean add a filter in the inline list? What kind of filter? ![Screen Shot 2020-03-08 at 10.51.38 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dd8d7ce78a8973c9908f50116ead33e886a36117.png) ---
**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:** [March 9, 2020, 3:56am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/4 "2020-03-09T03:56:37Z")
Two options: > **[Filtering data per user](https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/per-user-data)** > > Show different data to different users > **[Row owners](https://docs.glideapps.com/all/reference/privacy-and-per-user-data/row-owners)** > > A secure way to give users access to certain records ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 9, 2020, 4:02am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/5 "2020-03-09T04:02:20Z")
Wow!! How had I missed the “row owner” stuff?? This is lit! 🥳 Thanks Jeff! I owe you (again) a cold Corona 🍻 ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 9, 2020, 10:27pm UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/6 "2020-03-09T22:27:09Z")
Jeff sorry to bother you again. I went down the rabbit hole in your concepts app, but couldn’t figure it out by myself. With the above tip, I already filter by owner, so the owner can only see the info of his restaurants. Now, I want within an inline list, to only show information regarding 1 restaurant, and his waiters. I have a feeling the way we have the data doesn’t help to “filter” the waiters by restaurant, and I’m stuck here again. What I need is the screen to show only the waiters for the restaurant I’m looking it. Here’s the GIF link since I couldn’t upload it because it’s too heavy: > **[Kapture 2020-03-09 at 17.20.11.gif](https://drive.google.com/file/d/1dGt7QL405EpaCwefMKoX7685CzNnQrB7/view?usp=sharing)** > > Google Drive file. Thanks! ---
**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:** [March 10, 2020, 12:47am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/7 "2020-03-10T00:47:15Z")
The concepts app is not a great example because I have it set to public. I’m kind of faking it out to give the illusion of email filtering, but actually it’s using relations instead. Your GIF first shows the list of records in the Sales by Restaurant sheet. You then click on one of the list items to view it’s details. Your inline list is the Waiters sheet, correct? Do you have a relation column set up from the Sales sheet to the Waiters sheet? If you do, then you just need to point your inline list to the relation instead of the entire Waiters sheet. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 10, 2020, 11:27pm UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/8 "2020-03-10T23:27:27Z")
Hey Jeff, thanks again. Yes, my inline list is the waiters sheet… however I need to show a bunch of stuff from that sheet, that’s why I’m not pointing to the relation. What I’m trying to achieve here is that when I’m seeing Restaurant 1, I only want restaurant 1’s waiters to appear… I was planning to do that with a filter or a condition, however I don’t seem to find a way to filter it this way. If a filter using a relations column, then I only have the “is empty” or “is not empty” options and it doesn’t work out. ![Screen Shot 2020-03-10 at 6.26.47 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f9cdab042c055227f449403c7f003b4d9ae65bfd.png) ![Screen Shot 2020-03-10 at 6.26.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/106711702a722e29ae05a3095ef91a987c262594.png) What do you recommend? > **[Meser App](https://oiibv.glideapp.io/)** > > maestros de la atención Thanks again, ---
**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:** [March 10, 2020, 11:56pm UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/9 "2020-03-10T23:56:07Z")
Just change your inline list source to the relation (that links the restaurant sheet to the waiters sheet). That’s it! Everything will work the same but your list will only contain waiter for that restaurant. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 11, 2020, 3:31am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/10 "2020-03-11T03:31:32Z")
Thanks Jeff!! ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 12, 2020, 7:43pm UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/11 "2020-03-12T19:43:26Z")
Hi again Jeff. I’m a pain 😔 With your help I’ve figured out the past 2 issues. Now the third… When I’m in **restaurant 1** , I want to show total sales per type (lunch, dinner, bar, etc) of only that restaurant. So I filter by menu\_type, however I keep getting the total amount of dinner, for example, for all restaurants, and not only restaurant 1. I’ve been playing with the sheet in the [subcategories post](https://docs.glideapps.com/all/guides/deep-dives/design/subcategories#relations-and-inline-lists), but I don’t know if that’s the right way to display this information, or I should filter it in a different way. ![Screen Shot 2020-03-12 at 2.41.24 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/14e4e964ceeb70baf1834a99f6aed37d4f832077.png) Would you mind giving me a hand again? > **[Meser App](https://oiibvv.glideapp.io/)** > > maestros de la atención > **[Meser App - Glide](https://docs.google.com/spreadsheets/d/1zDTVbsVx-qb1co7wdK-E48ZInxwV9nYraAgB_WDcaGg/edit?usp=sharing)** > > Sales by Restaurant > > Data Updated,Restaurant,Owner,Menu Type,Period,Sales,Sales (Var%),# Orders,# Orders (Var%),Sales with Waiters,Sales without Waiters > 9:25pm 15/3/2020,Restaurant 1,owner@meser.app,Total,WTD,10,170,3.0,10,8.00%,$100,$111 > 9:25pm... ---
**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:** [March 13, 2020, 4:22am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/12 "2020-03-13T04:22:18Z")
You should only need a relation from restaurants to sales by restaurant. Don’t use filter. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 13, 2020, 2:59pm UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/13 "2020-03-13T14:59:33Z")
Ok, I’m **almost** there. ![Screen Shot 2020-03-13 at 9.55.14 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9e6bc481f1b9ccb8477567bf133282b19d2fdcca.png) When I’m seeing my restaurants, how do I add that inline list, named \*\*relation 2 \*\*(the relation you just mentioned above) to my restaurants view? When I’m in restaurants and add a new **inline list** component, I don’t see **relation 2** column. This is all I see. ![Screen Shot 2020-03-13 at 9.58.44 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/ddb78d2819036f2ef5070c69eee512b1624b8682.png) Thanks Jeff ---
**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:** [March 15, 2020, 6:05pm UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/14 "2020-03-15T18:05:46Z")
I’m taking the time to take a deeper look at your app. It looks like the copy tab points to the Restaurants sheet. I don’t know if you are just testing things, but currently you don’t have that tab filtered by signed in user, so only Restaurant 1 is going to show. As for your question about relation 2, I see you have it set up and are currently showing tiles. Are you still having issues with this? ---
**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:** [February 4, 2024, 4:32am UTC](https://community.glideapps.com/t/email-filtering-in-inline-list/5298/15 "2024-02-04T04:32:45Z")