# Number of matches

**URL:** https://community.glideapps.com/t/number-of-matches/76372
**Category:** Ask for Help
**Created:** [September 14, 2024, 11:31am UTC](https://community.glideapps.com/t/number-of-matches/76372 "2024-09-14T11:31:34Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Jeuk\_Jung](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeuk_jung/32/78989_2.png) [@Jeuk\_Jung](https://community.glideapps.com/u/Jeuk_Jung)
#### Post date: [September 14, 2024, 11:31am UTC](https://community.glideapps.com/t/number-of-matches/76372/1 "2024-09-14T11:31:35Z")

</div>

I’ve recorded the results of the players’ matches in the row. I want to record how many times the results entered this time are for that player, so how can I get them?

---

<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: [September 14, 2024, 12:05pm UTC](https://community.glideapps.com/t/number-of-matches/76372/2 "2024-09-14T12:05:47Z")

</div>

Create a Relation linking the player to itself. Then create a Rollup counting the number of rows in the relation.

---

<div class="post-metadata">

### Author: ![Jeuk\_Jung](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeuk_jung/32/78989_2.png) [@Jeuk\_Jung](https://community.glideapps.com/u/Jeuk_Jung)
#### Post date: [September 14, 2024, 1:10pm UTC](https://community.glideapps.com/t/number-of-matches/76372/3 "2024-09-14T13:10:13Z")

</div>

Thank you for your help.  
But that way (relation and rollup) gets every row has the same result.  
I want to have each row get different result. For example 1st game get 1, second game get 2.

 ![IMG_2711](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c2436190ba1316a78ea4ef68530694a5dfdb0b56.jpeg)

---

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [September 14, 2024, 1:21pm UTC](https://community.glideapps.com/t/number-of-matches/76372/4 "2024-09-14T13:21:17Z")

</div>

Follow Jeff’s advice and make sure the rollup is using the relation as its source

---

<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: [September 14, 2024, 3:39pm UTC](https://community.glideapps.com/t/number-of-matches/76372/5 "2024-09-14T15:39:50Z")

</div>

Can I assume that you have a different table that is just a list of all players?

---

<div class="post-metadata">

### Author: ![Jeuk\_Jung](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeuk_jung/32/78989_2.png) [@Jeuk\_Jung](https://community.glideapps.com/u/Jeuk_Jung)
#### Post date: [September 15, 2024, 2:09am UTC](https://community.glideapps.com/t/number-of-matches/76372/6 "2024-09-15T02:09:24Z")

</div>

Yes. There is players DB. And we input through ‘input UI’ each result using dropdiwn.

---

<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: [September 15, 2024, 9:45pm UTC](https://community.glideapps.com/t/number-of-matches/76372/7 "2024-09-15T21:45:44Z")

</div>

I would create a Relation and Rollup column in the Players DB table. Then create a Math column that adds 1 to the Rollup number. Whenever you add a row to the Results table, write the value from that math column.