# Appear in the list

**URL:** https://community.glideapps.com/t/appear-in-the-list/55851
**Category:** Ask for Help
**Created:** [December 18, 2022, 10:15am UTC](https://community.glideapps.com/t/appear-in-the-list/55851 "2022-12-18T10:15:28Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)
#### Post date: [December 18, 2022, 10:15am UTC](https://community.glideapps.com/t/appear-in-the-list/55851/1 "2022-12-18T10:15:28Z")

</div>

I have a table with repeat customers,  
It should only appear on this list once

How do I find repeating Customers?  
Then I show only one of them  
Any idea help me to do?

 ![لقطة الشاشة 2022-12-18 131418](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/5608b18e9398eb0631fb03d2fa12bfffc3fdcb3d.png)

---

<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: [December 18, 2022, 10:33am UTC](https://community.glideapps.com/t/appear-in-the-list/55851/2 "2022-12-18T10:33:04Z")

</div>

- Add a RowID column to your table
- Create a multiple relation column that matches the CustomerID to itself.
- Add a Single Value column that takes the first RowID from the multiple relation.
- Add an if-then-else column:  
– If Single Value RowID is RowID, then CustomerID

The if-then-else column will contain a list of unique CustomerIDs, and can be used as a filter.

---

<div class="post-metadata">

### Author: ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)
#### Post date: [December 18, 2022, 11:06am UTC](https://community.glideapps.com/t/appear-in-the-list/55851/3 "2022-12-18T11:06:34Z")

</div>

I think something is wrong

I want to get only one from a repeat customer

 ![لقطة الشاشة 2022-12-18 140419](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/efd4973f047d9947527b500abbd83d3cd2ab63b5.jpeg)

---

<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: [December 18, 2022, 11:15am UTC](https://community.glideapps.com/t/appear-in-the-list/55851/4 "2022-12-18T11:15:59Z")

</div>

You are missing the RowID column, which means that both your single value and if-then-else columns are wrong.  
Please follow the steps that I gave you carefully.