# Rollup Unique User Id values

**URL:** <https://community.glideapps.com/t/rollup-unique-user-id-values/66531>\
**Category:** Ask for Help\
**Created:** [September 26, 2023, 1:25pm UTC](https://community.glideapps.com/t/rollup-unique-user-id-values/66531 "2023-09-26T13:25:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mitchell\_Francis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mitchell_francis/32/45916_2.png) [@Mitchell\_Francis](https://community.glideapps.com/u/Mitchell_Francis)\
**Post date:** [September 26, 2023, 1:25pm UTC](https://community.glideapps.com/t/rollup-unique-user-id-values/66531/1 "2023-09-26T13:25:05Z")

</div>

Hey Guys, Hope you are all well!

This screenshot is from a table called Payments [It is populated via a zap when someone makes a new payment. It populates their wallet balance and their User ID (User Table - Row ID)]

 ![Screenshot 2023-09-26 at 15.17.02](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4ec7c54769895ca15999508382fbced0c58cd2e7.png)  
s

I then have a relation to in the User ID and then a Lookup Wallet balance and Roll Up in the users table. When the same user top ups their wallet (The same USER ID) more than once, how can I get it so that the Wallet Balance in the User table is a sum of all the top ups they did?

 ![Screenshot 2023-09-26 at 15.18.53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/ee4934d67c272048155a020ece96ea01627b646b.png)  
Hopes that makes sense?

Regards,  
Mitch

---

<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 26, 2023, 1:56pm UTC](https://community.glideapps.com/t/rollup-unique-user-id-values/66531/2 "2023-09-26T13:56:49Z")

</div>

You don’t need a Lookup. Just make sure the Rollup column uses the relation you already created, and perform the rollup through that relation. Also change your relation to a multiple relation.

---

<div class="post-metadata">

**Author:** ![Mitchell\_Francis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mitchell_francis/32/45916_2.png) [@Mitchell\_Francis](https://community.glideapps.com/u/Mitchell_Francis)\
**Post date:** [September 26, 2023, 2:01pm UTC](https://community.glideapps.com/t/rollup-unique-user-id-values/66531/3 "2023-09-26T14:01:19Z")

</div>

![Screenshot 2023-09-26 at 16.00.42](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27e8e50ffe931a0e7d9afda39331b2e7c8a17c9f.jpeg)  
It dosent let me choose the relation in the payments table or in the users column…

---

<div class="post-metadata">

**Author:** ![Mitchell\_Francis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mitchell_francis/32/45916_2.png) [@Mitchell\_Francis](https://community.glideapps.com/u/Mitchell_Francis)\
**Post date:** [September 26, 2023, 2:02pm UTC](https://community.glideapps.com/t/rollup-unique-user-id-values/66531/4 "2023-09-26T14:02:34Z")

</div>

Ahh nevermind…got it…Thanks alot mate!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 3, 2023, 2:02pm UTC](https://community.glideapps.com/t/rollup-unique-user-id-values/66531/5 "2023-10-03T14:02:38Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.