# How to create a point balance system?

**URL:** <https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260>\
**Category:** Ask for Help\
**Created:** [February 21, 2023, 6:45pm UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260 "2023-02-21T18:45:18Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Orsolya\_Faludi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/orsolya_faludi/32/54659_2.png) [@Orsolya\_Faludi](https://community.glideapps.com/u/Orsolya_Faludi)\
**Post date:** [February 21, 2023, 6:45pm UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260/1 "2023-02-21T18:45:18Z")

</div>

Hi Everyone,

I’m creating a babysitting exchange app, where moms watch each other’s kids in turns and earn points, that they can later redeem within the network. 1 hour of babysitting is 1 point, and each user starts with 5 points upon sign-up.

I have created the user profiles already, and I created a form where users can submit who watched whose kids, and for how long. I want the app to calculate the current point balance of each user based on this form, so add the points equaling the hours for the first user and subtract the points from the second user.

I’m using Glide tables, how can I do this? I assume it should be a transactions sheet and a points sheet linked to the user sheet, and using maybe some math columns, if-then-else or action setups, maybe a rollup column? I’m lost a bit… 😊

Thanks a lot 🙏

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 21, 2023, 9:11pm UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260/2 "2023-02-21T21:11:56Z")

</div>

This might help:

> [@gem\_stone Gamify Glide Apps (Updated 2022-11-28 - Episode 11: Craft Items)](https://community.glideapps.com/t/gamify-glide-apps-updated-2022-11-28-episode-11-craft-items/24303):
>
> Gamify Glide Apps Reboot #1: Onboarding & User Profiles Create your spreadsheet, design an onboarding experience, and set up user profiles! [[Gamify Glide Apps Reboot #1: Onboarding & User Profiles] ](https://www.youtube.com/watch?v=GqfOJdS52a0)

---

<div class="post-metadata">

**Author:** ![Orsolya\_Faludi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/orsolya_faludi/32/54659_2.png) [@Orsolya\_Faludi](https://community.glideapps.com/u/Orsolya_Faludi)\
**Post date:** [February 24, 2023, 9:22am UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260/3 "2023-02-24T09:22:38Z")

</div>

Thanks a lot, it’s quite a comprehensive series. I watched the episodes but I still feel uncertain about how exactly to proceed.

I have created user onboarding and a form where users can submit who provided the service for who and for how long. 1 hour = 1 point for simplicity.

1. I need to link the points earned to the user who provided the service and the points lost to the user for whom the service was provided. I guess it should be relation, but I’m not sure which columns to connect to work properly.
2. I need to add points earned to the starting balance from one user and I need to subtract the points paid from the starting balance of the other user, but I’m not sure how to do this, so it’s always updating itself.
3. I need to calculate the current balance to be able to show it to users  
 ![Screenshot 2023-02-24 at 9.36.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e34fb25b4cc5a09a12215cb1110b5d3afdb04f4.jpeg)  
 ![Screenshot 2023-02-24 at 9.36.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e236770c85bf0166b7e6478654bb891b50c61562.jpeg)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 24, 2023, 1:06pm UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260/4 "2023-02-24T13:06:07Z")

</div>



---

<div class="post-metadata">

**Author:** ![Orsolya\_Faludi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/orsolya_faludi/32/54659_2.png) [@Orsolya\_Faludi](https://community.glideapps.com/u/Orsolya_Faludi)\
**Post date:** [February 25, 2023, 4:21pm UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260/5 "2023-02-25T16:21:52Z")

</div>

Thanks a lot Robert 🙏 Let me give it a try and if I can’t do it by myself I’ll be grateful for the link 🙂

---

<div class="post-metadata">

**Author:** ![Orsolya\_Faludi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/orsolya_faludi/32/54659_2.png) [@Orsolya\_Faludi](https://community.glideapps.com/u/Orsolya_Faludi)\
**Post date:** [February 25, 2023, 5:40pm UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260/6 "2023-02-25T17:40:08Z")

</div>

Woohoo, it did work, thanks a lot. It was really so easy, I was overcomplicating it.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 25, 2023, 6:14pm UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260/7 "2023-02-25T18:14:07Z")

</div>

Amazing! Well done.

---

<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:** [February 26, 2023, 6:14pm UTC](https://community.glideapps.com/t/how-to-create-a-point-balance-system/58260/8 "2023-02-26T18:14:15Z")

</div>

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