# Update data in related table via the user table
**URL:** https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291
**Category:** Ask for Help
**Created:** [February 29, 2024, 3:55pm UTC](https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291 "2024-02-29T15:55:18Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@mwza](https://community.glideapps.com/u/mwza)
#### Post date: [February 29, 2024, 3:55pm UTC](https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291/1 "2024-02-29T15:55:18Z")
Hi all
I have a users table and one data table. The data table has a template column to set the current user id. Based on this column I have a relation column in the user table that relates all records in the data table.
I wanted to update all related data table records in this relation via an action using set values for a field in the data table.
I don’t see the option to select the relation as the target for the set values action.
Is this not possible?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 29, 2024, 3:58pm UTC](https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291/2 "2024-02-29T15:58:47Z")
It’s not possible to set column values through a multiple relation.
---
### Author:  [@mwza](https://community.glideapps.com/u/mwza)
#### Post date: [February 29, 2024, 4:36pm UTC](https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291/3 "2024-02-29T16:36:43Z")
Thanks
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 29, 2024, 4:54pm UTC](https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291/4 "2024-02-29T16:54:34Z")
The alternative would be to use an external service, such as Make to update multiple rows through the Glide API.
---
### Author:  [@mwza](https://community.glideapps.com/u/mwza)
#### Post date: [February 29, 2024, 5:12pm UTC](https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291/5 "2024-02-29T17:12:20Z")
Thanks @Jeff_Hager
I am a no coder but learning and clearly ChatGPT offers new tools to assist. Could the same be achieved via a javascript snippet in the data table to cycle through the maximum 100 rows in the data table, resetting all checked boolean values in one field to unchecked?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 29, 2024, 5:23pm UTC](https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291/6 "2024-02-29T17:23:55Z")
No, the javascript column is pretty sandboxed and can only return a value in the same javascript column based on the code. It can’t be used for automation or to change values in other columns. Glide currently does not have any backend automation processing to process multiple rows of data, although I believe that is something they might working on.
If all you are doing is resetting a boolean value, then I recommend having a look at this. It’s an old example with a classic app, so I’m not entirely sure if you can copy it anymore, but it’s worth a shot. It’s a bit of smoke and mirrors to give the appearance that a boolean has been reset for multiple columns.
> [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 7, 2024, 5:24pm UTC](https://community.glideapps.com/t/update-data-in-related-table-via-the-user-table/71291/7 "2024-03-07T17:24:50Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.