# Rolling point counter by date

**URL:** https://community.glideapps.com/t/rolling-point-counter-by-date/28519
**Category:** Ask for Help
**Created:** [June 30, 2021, 10:03am UTC](https://community.glideapps.com/t/rolling-point-counter-by-date/28519 "2021-06-30T10:03:25Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [June 30, 2021, 10:19am UTC](https://community.glideapps.com/t/rolling-point-counter-by-date/28519/2 "2021-06-30T10:19:31Z")

</div>

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.

---

_[View the full topic](https://community.glideapps.com/t/rolling-point-counter-by-date/28519)._