# Counting number of submissions

**URL:** <https://community.glideapps.com/t/counting-number-of-submissions/18592>\
**Category:** Ask for Help\
**Created:** [November 18, 2020, 3:58am UTC](https://community.glideapps.com/t/counting-number-of-submissions/18592 "2020-11-18T03:58:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [November 18, 2020, 3:58am UTC](https://community.glideapps.com/t/counting-number-of-submissions/18592/1 "2020-11-18T03:58:57Z")

</div>

Hi,

I am making an APP for photo competition. One criteria that is required is to allow only, for example 5 submissions per user. I can use rollup for count and count unique, but these do not give me the count per user. Count gives total submissions by all users and count unique gives the number of different users that have submitted.

Suggestions please on how to collect the number of submissions per user.

thank you

---

<div class="post-metadata">

**Author:** ![Nadir\_Abdelrahman\_MD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nadir_abdelrahman_md/32/5237_2.png) [@Nadir\_Abdelrahman\_MD](https://community.glideapps.com/u/Nadir_Abdelrahman_MD)\
**Post date:** [November 18, 2020, 4:06am UTC](https://community.glideapps.com/t/counting-number-of-submissions/18592/2 "2020-11-18T04:06:15Z")

</div>

One way to think about it is to create 5 columns, with photo1, photo2 etc.  
User specific lines  
Then use visibility to show/hide upload picture button

---

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [November 18, 2020, 4:58am UTC](https://community.glideapps.com/t/counting-number-of-submissions/18592/3 "2020-11-18T04:58:20Z")

</div>

thanks Nadir.

i found a way to count is to make a relation to the submitter and then do roll up from there.  
this is more flexible as i can adjust the visibility by setting the number instead of worrying about the columns.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 18, 2020, 5:54am UTC](https://community.glideapps.com/t/counting-number-of-submissions/18592/4 "2020-11-18T05:54:02Z")

</div>

Make a relation with the emails in user profiles to the submissions sheet, then a rollup to count the number of submissions for the specific email. Would that work?