# Get the count of rows by date and booleans, check in system
**URL:** https://community.glideapps.com/t/get-the-count-of-rows-by-date-and-booleans-check-in-system/72917
**Category:** Ask for Help
**Created:** [April 28, 2024, 6:17pm UTC](https://community.glideapps.com/t/get-the-count-of-rows-by-date-and-booleans-check-in-system/72917 "2024-04-28T18:17:57Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@luminrabbit](https://community.glideapps.com/u/luminrabbit)
#### Post date: [April 28, 2024, 6:17pm UTC](https://community.glideapps.com/t/get-the-count-of-rows-by-date-and-booleans-check-in-system/72917/1 "2024-04-28T18:17:57Z")
I have a simple table:
And Im trying to get the count of Rows by date and by First/second game for this Table.
Any suggestions on how this might be accomplished?
---
### Author:  [@luminrabbit](https://community.glideapps.com/u/luminrabbit)
#### Post date: [April 28, 2024, 6:53pm UTC](https://community.glideapps.com/t/get-the-count-of-rows-by-date-and-booleans-check-in-system/72917/2 "2024-04-28T18:53:14Z")
Im trying a bunch of different things from different posts to put something together and now I have the Count difference between the Booleans (First Game / Second Game) counted.
Now I believe I need to separate them by date somehow?
Im going to give this post a try now (just stumbled across it)
> [@Rolling point counter by date](https://community.glideapps.com/t/rolling-point-counter-by-date/28519/2):
>
> What you need to do is create a template column of the two columns you need to “combine” to apply your rollup. Make a template of the user’s email (or other unique identifier) and the date (you may also want to “lock” in the date formatting by first creating a template column that stores the date as text first — this might not be necessary, but it’s still something I do in these cases).
>
> Once you’ve got the template column (i.e. [email@email.com](mailto:email@email.com) April 1, 2021), create a multiple relation that check if the template matches itself. Then, create a rollup on this relation to get the sum of all the matches.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 28, 2024, 11:18pm UTC](https://community.glideapps.com/t/get-the-count-of-rows-by-date-and-booleans-check-in-system/72917/3 "2024-04-28T23:18:13Z")
What is your ideal outcome? I’m not sure what you’re trying to do here. Is it a count of first games and seconds games for each player?
---
### Author:  [@luminrabbit](https://community.glideapps.com/u/luminrabbit)
#### Post date: [April 29, 2024, 1:35am UTC](https://community.glideapps.com/t/get-the-count-of-rows-by-date-and-booleans-check-in-system/72917/4 "2024-04-29T01:35:55Z")
Hi @ThinhDinh
The intention is to create a checkin system for players and somedays there are 2 games. Once a player is checked into a game I need the count (amount) of players that played.
Some will only play one game. And other may play both games.
I just stumbled across this video although not exactly what I need because they use today but close enough I think I may be able to tweak it 😁
[ ](https://www.youtube.com/watch?v=Ulbt94E9lrE)
I’m new to glide and wrapping my head around how everything works can be challenging as it’s quite different but it’s the only way to learn.
I appreciate all of the help lately, I’ll post back if I can or can’t figure it out.
Thanks