Update multiple rows in table

[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…