# Updating multiple rows **URL:** \ **Category:** Ask for Help\ **Created:** [June 10, 2025, 6:24am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363 "2025-06-10T06:24:44Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Alina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alina/32/65894_2.png) [@Alina](https://community.glideapps.com/u/Alina)\ **Post date:** [June 10, 2025, 6:24am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/1 "2025-06-10T06:24:44Z")
Hello Gliders! Is there a way to edit multiple rows with workflow? I had an idea to trigger JSON to a Glide webhook and I get an array of row IDs and numbers which I need to to update according to those row IDs. But I can’t loop over that array. The initial numbers are from user specific column. I will appreciate any help ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 10, 2025, 6:31am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/2 "2025-06-10T06:31:50Z")
Yes, it’s possible. Can you describe your use case a bit more please? For example: - are you wanting to update all rows, or just some subset of the rows? - will you be setting the same values in each row, or different values per row? ---
**Author:** ![Alina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alina/32/65894_2.png) [@Alina](https://community.glideapps.com/u/Alina)\ **Post date:** [June 10, 2025, 9:04am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/3 "2025-06-10T09:04:12Z")
Darren, thank you for your reply! Here is my use case: I have an inventory and need to update items quantity in the column there. I have row IDs of the rows I need to update those items quantities in. Initially I have Tasks with those items related. So when I complete the task and use specific items in the process, I need to subtract them from the Inventory table. I also put the quantity of used items first in the user specific column (different values) and then I need to subtract them from Inventory. Honestly, I lost sleep over this thing) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 10, 2025, 9:27am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/4 "2025-06-10T09:27:43Z")
hmm, I’m a little bit lost… You have a list of RowIDs that represent the rows that need updating. And you have a list of item quantities used. How do you know which quantity goes with which RowID? Also, would it not be better to update your Inventory in real time as each item is used? ---
**Author:** ![Mazen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mazen/32/84042_2.png) [@Mazen](https://community.glideapps.com/u/Mazen)\ **Post date:** [June 10, 2025, 9:30am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/5 "2025-06-10T09:30:12Z")
I agree, but for example sometimes people order in bulk for many products and its frustrating to do them 1 by 1, I think he meant he wants to use the row ID as a search key ---
**Author:** ![Alina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alina/32/65894_2.png) [@Alina](https://community.glideapps.com/u/Alina)\ **Post date:** [June 10, 2025, 10:07am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/6 "2025-06-10T10:07:22Z")
> [@Darren\_Murphy](#): > > How do you know which quantity goes with which RowID? They are in pairs. Please, ask what is not clear. And yes, I mean bulk row editing here. In ideal world user puts the quantity of items used into the entry fields and then presses the submit button. This seems to be nice UI. I know how to edit items one by one, this is not my question. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 10, 2025, 10:18am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/7 "2025-06-10T10:18:05Z")
Would you mind showing me screen shots of the relevant tables, so I can get a clear picture? ---
**Author:** ![Alina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alina/32/65894_2.png) [@Alina](https://community.glideapps.com/u/Alina)\ **Post date:** [June 10, 2025, 10:51am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/8 "2025-06-10T10:51:13Z")
And in which direction are you thinking? Well here is JSON which I get to my webhook, for example: { “items”: [ { “id\_”: “z0meYwlgQuKqA2VZHKR6Og”, “qty”: 1 }, { “id\_”: “P5M0T5ZvQ3SRPSmoj5HuQw”, “qty”: 2 } ] } It contains item row ID (in Inventory table) and the new quantity to put in this row. How for love of god, I loop over this thing? Is it even possible? I also can get 2 arrays with Query JSON respectively of row IDs and quantities: [ “z0meYwlgQuKqA2VZHKR6Og”, “P5M0T5ZvQ3SRPSmoj5HuQw” ] and [ 1, 2 ] Are there at least any hints or any tutorials I could try? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 10, 2025, 11:19am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/9 "2025-06-10T11:19:59Z")
Okay, that’s useful. Here is how you can do it: - Pass your JSON to a workflow. It needs to be either a Manual or Webhook triggered workflow. - Add a Query JSON node, and point it at the Trigger Data, and extract `items` - Add a Loop and target the transformed JSON from the Query - Inside the Loop, add the following: – Two Query JSON nodes, one each to extract the `id_` and `qty` – A Query node that matches the extracted `id_` with the RowID in the table you want to update. Be sure not to select “Match multiple” – A Set Column Values node that targets the Query, and updates the appropriate column with the extracted `qty` value. ---
**Author:** ![Alina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alina/32/65894_2.png) [@Alina](https://community.glideapps.com/u/Alina)\ **Post date:** [June 10, 2025, 11:36am UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/10 "2025-06-10T11:36:31Z")
Thank you so much! I will try this. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 10, 2025, 2:07pm UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/11 "2025-06-10T14:07:02Z")
Here are some screenshots of the what the flow looks like. > [@Is there some issue in workflow? I cant see anything under results of JSON query](https://community.glideapps.com/t/is-there-some-issue-in-workflow-i-cant-see-anything-under-results-of-json-query/82219/2): > > Query the JSON Once, Outside the Loop Loop over the transformed JSON Extract Specific Values Inside the Loop (e.g. userID) Use the Extracted Values in Your “Add Row” Action Hope this helps! ---
**Author:** ![Alina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alina/32/65894_2.png) [@Alina](https://community.glideapps.com/u/Alina)\ **Post date:** [June 11, 2025, 8:13pm UTC](https://community.glideapps.com/t/updating-multiple-rows/82363/12 "2025-06-11T20:13:11Z")
Thank you! I will try this too