# Help with update values in a related colum
**URL:** https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962
**Category:** Ask for Help
**Created:** [August 4, 2022, 6:00pm UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962 "2022-08-04T18:00:18Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@Fab3r](https://community.glideapps.com/u/Fab3r)
#### Post date: [August 4, 2022, 6:00pm UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/1 "2022-08-04T18:00:18Z")
Hi there, I am following the online example from Robert Petitto about a referral app.
So the code is created, and shared with other people.
I have 1 relation (Rel\_Valid) who check the owner of the referral\_code to see when people use the correct code (and subscribe)
And I would like to award the code owner when the referred user reaches the level2.
I am trying to update the EXP value … using the rel\_Valid relation, but… looks like I am doing something wrong
Update action (the one which doesn’t work)
Any help?
Thanks in advance
---
### Author:  [@Fab3r](https://community.glideapps.com/u/Fab3r)
#### Post date: [August 4, 2022, 6:01pm UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/2 "2022-08-04T18:01:17Z")
This is what I am trying to do
Thanks! (sorry as newbie 1 media per post)
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 4, 2022, 11:22pm UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/3 "2022-08-04T23:22:22Z")
Hi @Fab3r
Are you trying to award a user EXP if someone else signs up with their code?
---
### Author:  [@Fab3r](https://community.glideapps.com/u/Fab3r)
#### Post date: [August 5, 2022, 12:17am UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/4 "2022-08-05T00:17:47Z")
Hi @Robert_Petitto and thanks for your reply 🙏
I already find the way to assign XP once a new user signs up with their code (using the WhoUsedMyCode colum + the HowMany)
I would like to award XP to User 1, 'cause my user (Faber who used the User 1 code) has reached the level2: The goal is to award not only signups but an active users.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 5, 2022, 12:36am UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/5 "2022-08-05T00:36:55Z")
Hm…still not following. Do you mean:
- “User 2” uses “User 1” promo code
- “User 1” gets initial XP
- “User 1” gets additional XP when “User 2” levels up?
---
### Author:  [@Fab3r](https://community.glideapps.com/u/Fab3r)
#### Post date: [August 5, 2022, 7:44am UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/6 "2022-08-05T07:44:06Z")
Yes, correct!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 5, 2022, 10:23am UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/7 "2022-08-05T10:23:25Z")
Is it a one-time bonus or recurring multiplier?
---
### Author:  [@Fab3r](https://community.glideapps.com/u/Fab3r)
#### Post date: [August 5, 2022, 11:48am UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/8 "2022-08-05T11:48:25Z")
one-time bonus: once the “User 2” reach the level 2 \> “User 1” gets additional XP
I was thinking to add a column “assigned” as well to track once the XP has been assigned (to avoid double bonus)
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 5, 2022, 12:50pm UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/9 "2022-08-05T12:50:39Z")
I get what you’re trying to do, but I don’t see an easy way of accomplishing this. Glide doesn’t allow for background actions yet so to claim those points, user 1 would be to click a button to initiate the increment. That’s all fine and good except where do you place the button? It would have to be tied to user 2’s profile somehow… perhaps an in-line list of users filtered to the ones that have used User1’s code AND have reached level 2? You wouldn’t display user information but rather some text that says claim bonus points? You can create an action for that in line list that awards points and marks a timestamp or some thing. Would this work?
---
### Author:  [@Fab3r](https://community.glideapps.com/u/Fab3r)
#### Post date: [August 5, 2022, 1:00pm UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/10 "2022-08-05T13:00:37Z")
Yes, I know about the background action, so I planned to connect the action to the Admin panel, once the Admin approve the task/challenge \> I am planning to make a check (“User 2” reaches level-2) and if not already assigned, assign extra XP to “User 1”…
But… Why I cannot update the column using the current table structure and relationships? Every time I using my action (as in the picture) the “User 2” column, EXP increment doesn’t work ☹
Is there something wrong (…ehm yes, for sure) in my structure? Why I cannot update “User 1” EXP if I am in the “User 2” profile, despite the Rel\_valid relation?
By the way @Robert_Petitto congrats for your great videos especially for your way of building app and include a lot of controls. Thanks
---
### Author:  [@Fab3r](https://community.glideapps.com/u/Fab3r)
#### Post date: [August 5, 2022, 1:09pm UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/11 "2022-08-05T13:09:44Z")
But I got your suggestion about the inline list… working on that! Thanks
---
### Author:  [@Fab3r](https://community.glideapps.com/u/Fab3r)
#### Post date: [August 17, 2022, 12:44pm UTC](https://community.glideapps.com/t/help-with-update-values-in-a-related-colum/45962/12 "2022-08-17T12:44:47Z")
Finally it’s working, the full referral system is now able to:
- add referral new users (on the onboarding/welcoming screen)
- add referral network to the user profile
- add notifications
- add XP for new users
- add XP when a new user gain a level
Thanks for the support 🙏