Update multiple rows in table

[agaitan026]

Hi i got a table where user may change product quantities

like this:

action when click save

but, when i change both rows and press save changes button it only updates one row, is this normal?

thank you

[benbarry]

recordUpdates is an array, and you're only passing the first index 0.

You'll need to do a Javascript query and iterate through the array to run your update query for each item in the array.

Similar to:

How to run a REST API/Query for each item in an array and return all results together

Similar to https://docs.retool.com/docs/scripting-retool#section-triggering-a-query-for-each-item-in-an-array, this setup using Async JS promises will make the .data property of this query include ALL of the results of the triggered queries. Using a Run JS Code type query, we will trigger another query for each item in an array, and after the last is completed return all of the results together in the jsCodeQueryName.data value. Where get_assignment is a REST Api query, taking an input of {{as…