# Ratings drop when user name changes

**URL:** <https://community.glideapps.com/t/ratings-drop-when-user-name-changes/63836>\
**Category:** Ask for Help\
**Created:** [July 12, 2023, 8:02pm UTC](https://community.glideapps.com/t/ratings-drop-when-user-name-changes/63836 "2023-07-12T20:02:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![brian\_edwards](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brian_edwards/32/57534_2.png) [@brian\_edwards](https://community.glideapps.com/u/brian_edwards)\
**Post date:** [July 12, 2023, 8:02pm UTC](https://community.glideapps.com/t/ratings-drop-when-user-name-changes/63836/1 "2023-07-12T20:02:35Z")

</div>

I have an app with profiles and user names and ratings for users. When a user edits their name all previous ratings drop off. I understand it is due to the relation between the user name and the rating. Does anyone know of a way to maintain this info even if the user name changes?

---

<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:** [July 12, 2023, 10:05pm UTC](https://community.glideapps.com/t/ratings-drop-when-user-name-changes/63836/2 "2023-07-12T22:05:54Z")

</div>

Using name to establish a relation is bad practices for exactly that reason. Names can change. It’s better to use Row ID’s to create relations because Row ID’s will not change. You would use the Row ID from your user table and write that to each new row in the ratings table. Then use the ID’s to create the relation.

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [July 13, 2023, 4:16pm UTC](https://community.glideapps.com/t/ratings-drop-when-user-name-changes/63836/3 "2023-07-13T16:16:47Z")

</div>

What Jeff said 👆

Just adding a example! : [Things in Things | Glide Tips - YouTube](https://youtu.be/2lZ75iPXc2E?t=569) ( made by @JackVaughan 💪 )
