# How to show Unique Item?

**URL:** <https://community.glideapps.com/t/how-to-show-unique-item/66615>\
**Category:** Ask for Help\
**Created:** [September 29, 2023, 7:36am UTC](https://community.glideapps.com/t/how-to-show-unique-item/66615 "2023-09-29T07:36:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [September 29, 2023, 7:36am UTC](https://community.glideapps.com/t/how-to-show-unique-item/66615/1 "2023-09-29T07:36:03Z")

</div>

I have a few sheets in Service App.

Fleet Page:

ID |

EB1  
EB2  
EB3  
EB4

Inspection Report Page:

Report No | Eq ID

PM-B-001 | EB2  
PM-B-002 | EB2  
PM-B-003 | EB4

Part Replaced Page:

Date | Report No | Part Replaced | Array(Lookup after SelfRelation ReportNo)

2/9/2023 | PM-B-002 | Engine Oil | Engine Oil, Battery, Filter  
2/9/2023 | PM-B-002 | Battery | Engine Oil, Battery, Filter  
2/9/2023 | PM-B-002 | Filter | Engine Oil, Battery, Filter  
4/9/2023 | PM-B-004 | Filter | Filter, Fuel Filter  
4/9/2023 | PM-B-004 | Fuel Filter | Filter, Fuel Filter  
9/9/2023 | PM-B-001 | Tyre | Tyre, Hyd Oil  
9/9/2023 | PM-B-001 | Hyd Oil | Tyre, Hyd Oil

My question is

How to show the list group:

**EB1**

2/9/2023  
PM-B-002  
Engine Oil, Battery, Filter

9/9/2023  
PM-B-001  
Tyre, Hyd Oil

I manage to do something like this:

**EB1**

2/9/2023  
PM-B-002  
Engine Oil, Battery, Filter

2/9/2023  
PM-B-002  
Engine Oil, Battery, Filter

2/9/2023  
PM-B-002  
Engine Oil, Battery, Filter

9/9/2023  
PM-B-001  
Tyre, Hyd Oil

9/9/2023  
PM-B-001  
Tyre, Hyd Oil

Its repeating the same row in Part Replaced Page.  
Do you guys have any ideas on how to filter only unique element?

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e32391cc8ee2d6779240c716f76d19bd58821306.png)

This is a sample the list based on the Part Replaced Page.  
Suppose showing 2 items.  
but the PM-B-0316 is showing 2 because the entry was 2. 1 is battery and another is Engine Oil filter.

---

<div class="post-metadata">

**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:** [September 29, 2023, 10:07am UTC](https://community.glideapps.com/t/how-to-show-unique-item/66615/2 "2023-09-29T10:07:34Z")

</div>

- Add a RowID column
- Create a self-relation (multiple) that matches the Report Number with itself (I think you already have this?)
- Add a Single Value column that fetches the first RowID from the relation
- Add a filter to your collection: RowID is Single Value RowID

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [October 4, 2023, 8:14am UTC](https://community.glideapps.com/t/how-to-show-unique-item/66615/3 "2023-10-04T08:14:28Z")

</div>

Heheheheh thanks darren

---

<div class="post-metadata">

**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:** [October 11, 2023, 8:14am UTC](https://community.glideapps.com/t/how-to-show-unique-item/66615/4 "2023-10-11T08:14:56Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.