# Maintaining a per-user count of form submissions

**URL:** <https://community.glideapps.com/t/maintaining-a-per-user-count-of-form-submissions/16508>\
**Category:** Ask for Help\
**Created:** [September 29, 2020, 1:19pm UTC](https://community.glideapps.com/t/maintaining-a-per-user-count-of-form-submissions/16508 "2020-09-29T13:19:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 29, 2020, 1:19pm UTC](https://community.glideapps.com/t/maintaining-a-per-user-count-of-form-submissions/16508/1 "2020-09-29T13:19:52Z")

</div>

Within my app, I provide a form to users, and I wish to maintain a column in my user table that tracks how many times each user has submitted the form. I cannot find any obvious way to do this within Glide. I know that it can be done quite trivially within my GSheet, but I need the count to be updated instantaneously, and so the sync delay creates a problem. I thought that a `Rollup` column may be the answer, but that gives me a count of _all_ form submissions - and I need it broken down by user.

Would appreciate a steer in the right direction.

thanks,  
Darren

---

<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 29, 2020, 2:03pm UTC](https://community.glideapps.com/t/maintaining-a-per-user-count-of-form-submissions/16508/2 "2020-09-29T14:03:21Z")

</div>

You can create a rollup on top of a relation column. Create a relation to link email in the user sheet to the email in the form sheet. Then create a rollup that uses that relation.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 29, 2020, 2:11pm UTC](https://community.glideapps.com/t/maintaining-a-per-user-count-of-form-submissions/16508/3 "2020-09-29T14:11:16Z")

</div>

oooh, so simple. Thanks @Jeff_Hager!!