# Display the Count of items matched in a 'Relation' list

**URL:** https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302
**Category:** Ask for Help
**Created:** [February 5, 2020, 11:10pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302 "2020-02-05T23:10:35Z")
**Posts on this page:** 10
**Page:** 2

<div class="post-metadata">

### Author: ![arvind](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arvind/32/15962_2.png) [@arvind](https://community.glideapps.com/u/arvind)
#### Post date: [December 1, 2020, 3:04pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/22 "2020-12-01T15:04:58Z")

</div>

I’m trying to do the latter (may not even be possible now that I think about it)

---

<div class="post-metadata">

### 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 1, 2020, 3:19pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/23 "2020-12-01T15:19:13Z")

</div>

I don’t think there is a way to count multiple matches in the same row.

---

<div class="post-metadata">

### Author: ![arvind](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arvind/32/15962_2.png) [@arvind](https://community.glideapps.com/u/arvind)
#### Post date: [December 1, 2020, 3:27pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/24 "2020-12-01T15:27:00Z")

</div>

Got it - okay that’s helpful for me to close the loop and stop chasing it. Really appreciate your help here Jeff and David as well!

---

<div class="post-metadata">

### 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 1, 2020, 3:30pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/25 "2020-12-01T15:30:44Z")

</div>

Technically, you still could, but you would have to set up a relation for each search query separately. I don’t think that would work with split text though, since you can’t single out each item in the array. It would probably require separate entry componts for each search query word, separate relations, and separate rollups on each relation. Gets a little messy.

---

<div class="post-metadata">

### Author: ![Andrew\_Learned](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_learned/32/67008_2.png) [@Andrew\_Learned](https://community.glideapps.com/u/Andrew_Learned)
#### Post date: [November 9, 2022, 11:32am UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/26 "2022-11-09T11:32:50Z")

</div>

I’m having this same issue. In my case, I’m trying to match siblings.

I built a relation that relates children when they share the same parent name. The issue is that every row’s parent name matches the same row’s parent name, in addition to any subsequent row. So what ends up happening is each kid shows one sibling (self) in addition to any other.

How would I remove the relation to self, leaving the true sibling relation (say, in an inline list)?

---

<div class="post-metadata">

### 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: [November 9, 2022, 12:41pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/27 "2022-11-09T12:41:02Z")

</div>

Is this just for a count? You could create a math column that always subtracts 1 from the count.

---

<div class="post-metadata">

### Author: ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)
#### Post date: [January 20, 2023, 5:15pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/28 "2023-01-20T17:15:00Z")

</div>

Hi

Not sure if this helps, but I just achieved exactly this.

A comments table for another table of “issues”

In my “Issues” table - I have a relation back to the comments table - using the Row ID  
I then had a roll up field set on the Relation field set to count the values of that related field

Screen shot attached.

Hope that helps.

Andrew

 ![Screenshot 2023-01-20 at 17.14.05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9afc3878bb049b5f142fba5c1a9933c57144ba50.jpeg)

---

<div class="post-metadata">

### Author: ![LowCountry](https://avatars.discourse-cdn.com/v4/letter/l/d78d45/32.png) [@LowCountry](https://community.glideapps.com/u/LowCountry)
#### Post date: [October 28, 2023, 3:26pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/29 "2023-10-28T15:26:21Z")

</div>

The relation columns don’t appear as an option for the rollup field type when I try and attempt this strategy in my database.

---

<div class="post-metadata">

### Author: ![LowCountry](https://avatars.discourse-cdn.com/v4/letter/l/d78d45/32.png) [@LowCountry](https://community.glideapps.com/u/LowCountry)
#### Post date: [October 28, 2023, 3:31pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/30 "2023-10-28T15:31:29Z")

</div>

Never mind. I figured out what I was doing. I finally noticed that my relation column was appearing at the top of the list when setting up the rollup. I kept choosing the table to locate the relation column.

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302/31 "2024-01-17T16:49:06Z")

</div>



[Previous page](https://community.glideapps.com/t/display-the-count-of-items-matched-in-a-relation-list/4302.md?page=1)
