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?
Create a Relation linking the player to itself. Then create a Rollup counting the number of rows in the relation.
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.
Follow Jeff’s advice and make sure the rollup is using the relation as its source
1 Like
Can I assume that you have a different table that is just a list of all players?
1 Like
Yes. There is players DB. And we input through ‘input UI’ each result using dropdiwn.
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.
1 Like