# How to show unique result in inline list

**URL:** <https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961>\
**Category:** Ask for Help\
**Created:** [March 8, 2021, 7:08pm UTC](https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961 "2021-03-08T19:08:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![MonsterGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monstergo/32/18780_2.png) [@MonsterGo](https://community.glideapps.com/u/MonsterGo)\
**Post date:** [March 8, 2021, 7:08pm UTC](https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961/1 "2021-03-08T19:08:33Z")

</div>

how to setting “only show 1” result when the inline list have 2 or more in same result ?

example: when the inline list have 3 username as John, but only show 1 John instead of 3 John.

---

<div class="post-metadata">

**Author:** ![Alessandro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alessandro/32/25019_2.png) [@Alessandro](https://community.glideapps.com/u/Alessandro)\
**Post date:** [March 8, 2021, 7:14pm UTC](https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961/2 "2021-03-08T19:14:51Z")

</div>

You could group them based on “Name” and limit the visible items to 1. The others will be visible if you click on “See more”

---

<div class="post-metadata">

**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:** [March 8, 2021, 9:43pm UTC](https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961/3 "2021-03-08T21:43:06Z")

</div>

In the Glide Data Editor, relate this list of entries to the user profile sheet via the username. Then, show the relation column in the inline list rather that the list of entries.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 9, 2021, 10:21am UTC](https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961/4 "2021-03-09T10:21:00Z")

</div>

question is … are they same John or deferent ?

---

<div class="post-metadata">

**Author:** ![MonsterGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monstergo/32/18780_2.png) [@MonsterGo](https://community.glideapps.com/u/MonsterGo)\
**Post date:** [March 9, 2021, 10:28am UTC](https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961/5 "2021-03-09T10:28:43Z")

</div>

But my case a bit complicated.

let say, i have 2 merchant, and 2 customers.

Merchant 1= McDonalds  
Merchant 2= Starbucks  
Customer 1= John  
Customer 2= Bob

i want to do that, John profile has show both merchant in his list (McD & Starbucks), because john has been spending at both store. and Bob profile only show Starbucks, because Bob only been spending at Starbucks.

my current situation is, John has spending 3 times at McD , 1 time at Starbucks. my inline list show 4 transaction records, actually i just want to show each merchant for each as John total spending X$ at Mcd & total spending X$ at Starbucks.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 9, 2021, 10:33am UTC](https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961/6 "2021-03-09T10:33:17Z")

</div>

reverse relation, relate merchant to John instead John to merchant, and create IF ELSE column to check if relation is not empty, you will get indicator for merchants where John spend money, You can see that in action in my App [https://e-store.glideapp.io/](https://e-store.glideapp.io/)  
put in cart items from deferent vendors… and you will see how App separate and calculate them

---

<div class="post-metadata">

**Author:** ![MonsterGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monstergo/32/18780_2.png) [@MonsterGo](https://community.glideapps.com/u/MonsterGo)\
**Post date:** [March 9, 2021, 11:24am UTC](https://community.glideapps.com/t/how-to-show-unique-result-in-inline-list/23961/7 "2021-03-09T11:24:13Z")

</div>

Thanks Uzo. let me try to set that