# Bulk update rows when a relation changes

**URL:** <https://community.glideapps.com/t/bulk-update-rows-when-a-relation-changes/67248>\
**Category:** Ask for Help\
**Created:** [October 24, 2023, 8:12pm UTC](https://community.glideapps.com/t/bulk-update-rows-when-a-relation-changes/67248 "2023-10-24T20:12:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ndench](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ndench/32/65501_2.png) [@ndench](https://community.glideapps.com/u/ndench)\
**Post date:** [October 24, 2023, 8:12pm UTC](https://community.glideapps.com/t/bulk-update-rows-when-a-relation-changes/67248/1 "2023-10-24T20:12:32Z")

</div>

I have a “group” table which just contains a name. My users can join a group, which stores the group name in a column on the users table and I have a relationship column based on that.

When someone edits a group name, I’d like to update the group column on every user that is in the group, so that they are still in the same group after the edit. Otherwise they would be in an invalid group.

Is this possible?

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [October 24, 2023, 8:13pm UTC](https://community.glideapps.com/t/bulk-update-rows-when-a-relation-changes/67248/2 "2023-10-24T20:13:40Z")

</div>

Add a `Row ID` to your Groups table and store that in the Users table to make the relation. Then you can change the names as much as you want!

---

<div class="post-metadata">

**Author:** ![ndench](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ndench/32/65501_2.png) [@ndench](https://community.glideapps.com/u/ndench)\
**Post date:** [October 24, 2023, 8:19pm UTC](https://community.glideapps.com/t/bulk-update-rows-when-a-relation-changes/67248/3 "2023-10-24T20:19:41Z")

</div>

Oh right, make the relation work on property that cannot be edited. That makes sense, thanks for the speedy reply!

---

<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 31, 2023, 8:20pm UTC](https://community.glideapps.com/t/bulk-update-rows-when-a-relation-changes/67248/4 "2023-10-31T20:20:24Z")

</div>

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