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

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?

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)

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?

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

[image] 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.

Would you mind showing me screen shots of the relevant tables, so I can get a clear picture?

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?

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.

Thank you so much! I will try this.

Here are some screenshots of the what the flow looks like. [image] Is there some issue in workflow? I cant see anything under results of JSON query Ask for Help Query the JSON Once, Outside the Loop [Screenshot 2025-06-03 at 8.32.24 AM] Loop over the transformed JSON [Screenshot 2025-06-03 at 8.32.44 AM] Extract Specific Values Inside the Loop (e.g. userID) [Screenshot 2025-06-03 at 8.32.54 AM] Use the Extracted Values in Your “Add Row” Action [Screenshot 2025-06-03 at 8.41.48 AM] Hope this helps!

Updating multiple rows

Ask for Help

Eric_Penn June 10, 2025, 2:07pm 11

Here are some screenshots of the what the flow looks like.

Topic		Replies	Views
Updating multiple rows at once Ask for Help	8	1117	October 20, 2024
Glide API & Make.com \| "Get all Rows" to update one row? Ask for Help	2	584	March 2, 2023
Extracting line items Ask for Help actions	4	75	February 8, 2025
Turn JSON array into rows in separate table Ask for Help	12	352	August 10, 2025
Set columns in multiple rows - Glide API Ask for Help	7	802	April 11, 2023

Updating multiple rows

Related topics