# Showing one row of many **URL:** \ **Category:** Ask for Help\ **Created:** [December 28, 2021, 7:46pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438 "2021-12-28T19:46:35Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 28, 2021, 7:46pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/1 "2021-12-28T19:46:35Z")
The sheets contain 7 rows with the same name. I just want the first of these 7 on the screen. How do I do that? ![zeven regels](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/731a84a4037163cabdf38df041e1c9c61b363f55.png) Uploading: zeven databe.jpg… ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 28, 2021, 7:47pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/2 "2021-12-28T19:47:57Z")
![zeven databe](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/4425f32a6d0e288a47a900a0e1845e52bb46c8a4.jpeg) ---
**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:** [December 28, 2021, 9:06pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/3 "2021-12-28T21:06:58Z")
I’ve wanted a native feature like this as well (filter by unique values). Here’s one way: 1. Create a multiple relation column matching the ma’am receipt column to itself 2. Create a single value column to grab the first RowID value from the relation in step 1. 3. Add a filter on the inline list where RowID is the Single Value column ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 28, 2021, 9:31pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/4 "2021-12-28T21:31:12Z")
I also found this way but… Maybe I wasn’t clear enough. I would like to have every 1st value. So also the next one (“Fuji apple” and “Greek yogurt”) some with more rows. Thanks so far. ![extra](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a972712eefe4e93d56244c931f2d1bd0c5c67705.jpeg) ---
**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:** [December 28, 2021, 9:35pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/5 "2021-12-28T21:35:33Z")
Right…my solution above should work for your request. ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 28, 2021, 9:43pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/6 "2021-12-28T21:43:34Z")
Unfortunately it doesn’t work as I entered it. ![extra info](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/6678cb70ac09a78d9be3ee6329ed09c3bb5ce4ee.jpeg) ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 28, 2021, 11:15pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/7 "2021-12-28T23:15:20Z")
Found a solution. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/30388c496e170f9ef792882982f4cfce932fcddc.jpeg) That is how it works. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8cf096ff5b72a366264a7eb163fc8714ba39d8e7.png) Robert, thank you for helping me. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [December 28, 2021, 11:34pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/8 "2021-12-28T23:34:54Z")
> [@Hans\_Op\_het\_Roodt](#): > > Unfortunately it doesn’t work as I entered it. If you want this method to work, your relation needs to be a multiple relation (like Robert said!). Then, you’d need an IFTHENELSE Column like Robert mentioned. Your method above looks like it’s working for you though, but it’s not very dynamic if new data is added to the sheet. ---
**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:** [December 28, 2021, 11:43pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/9 "2021-12-28T23:43:48Z")
> [@Robert\_Petitto](#): > > Here’s one way: > > 1. Create a _ **multiple** _ relation column matching the ma’am receipt column to itself Yup 👆 ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 29, 2021, 10:38am UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/10 "2021-12-29T10:38:55Z")
Searched for a better solution and found it with the “UNIQUE formula”. Unique is used in Google sheets. Search Glide Library for UNIQUE. ---
**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:** [December 29, 2021, 11:05am UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/11 "2021-12-29T11:05:25Z")
No offence, but any “solution” that relies on Google Sheet formulas is definitely _not_ better by any stretch of the imagination. A native Glide solution is almost _always_ preferable, and @Robert_Petitto already gave you one (which you appear to have either ignored or not understood). > [@Robert\_Petitto](#): > > - Create a multiple relation column matching the ma’am receipt column to itself > - Create a single value column to grab the first RowID value from the relation in step 1. > - Add a filter on the inline list where RowID is the Single Value column ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 29, 2021, 12:45pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/12 "2021-12-29T12:45:53Z")
It doesn’t work, no new rowID appear. ![appear](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f6e4355698a9fe024431b498c3532ac52b6981f.jpeg) ---
**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:** [December 29, 2021, 12:47pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/13 "2021-12-29T12:47:23Z")
Your relation needs to be multiple, and your single value needs to refer to the relation instead of the sheet. ---
**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:** [December 29, 2021, 2:55pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/14 "2021-12-29T14:55:15Z")
Check the box on your relation column to “Match Multiple” ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 29, 2021, 4:40pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/15 "2021-12-29T16:40:58Z")
It does indeed work as you explained. I checked the “Match multiple” and in the single value changed the reference to “rel name recipe \> Row ID”. Thank you guys. ---
**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:** [December 30, 2021, 4:41pm UTC](https://community.glideapps.com/t/showing-one-row-of-many/36438/16 "2021-12-30T16:41:54Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.