# How to create unique tallies with 1 table

**URL:** <https://community.glideapps.com/t/how-to-create-unique-tallies-with-1-table/73013>\
**Category:** Ask for Help\
**Created:** [May 2, 2024, 5:43pm UTC](https://community.glideapps.com/t/how-to-create-unique-tallies-with-1-table/73013 "2024-05-02T17:43:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [May 2, 2024, 5:43pm UTC](https://community.glideapps.com/t/how-to-create-unique-tallies-with-1-table/73013/1 "2024-05-02T17:43:45Z")

</div>

I let my users upload photos to showcase their business:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9a17187d50a7c8a63099b6e3fdbdbf7fd4243bd8.jpeg)

I want to put a limit on how many photos my free users can upload.

I wanted to create a condition that if this user is a free profile and they’ve upload \< 9 photos that the “+” photo button goes away.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/1578d3d519ae4e9892c1992954132151108fe88b.jpeg)

Each time a photo is uploaded, I identify the profile it goes to based on the email address, so how do i get a count on how many photos each email address has uploaded?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/9238b75d647d2247c98b75cc1693e169312f0f35.jpeg)

Unless that is an overly complicated way to do it, in which case please let me know!

---

<div class="post-metadata">

**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\
**Post date:** [May 2, 2024, 5:52pm UTC](https://community.glideapps.com/t/how-to-create-unique-tallies-with-1-table/73013/2 "2024-05-02T17:52:14Z")

</div>

May be i don’t understand clearly, but you just need to create relation from member email in the images table to the member email in the images table (mean multiple relation on it self) and do Rollup count thru this m. rel.  
And create Single relation from user row from user email to member email in the image table and create lookup thru this email to the count column described above. This will give current user images count.

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [May 2, 2024, 5:57pm UTC](https://community.glideapps.com/t/how-to-create-unique-tallies-with-1-table/73013/3 "2024-05-02T17:57:18Z")

</div>

ah perfection, got it! Thanks!

---

<div class="post-metadata">

**Author:** ![fraser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fraser/32/68111_2.png) [@fraser](https://community.glideapps.com/u/fraser)\
**Post date:** [May 3, 2024, 5:05pm UTC](https://community.glideapps.com/t/how-to-create-unique-tallies-with-1-table/73013/4 "2024-05-03T17:05:37Z")

</div>

I did something similar - adding the count to the user table and then using this number to hide fields (eg your image picker field) once the user# \> ref number. For added slickness you could make a new field appear saying sorry you are past your free limit’