Bulk update joined table via primary key

App Building
1

I think that this solution will help someone to save a couple of hours that I have already spent on the research.

So, I have the combined table that I get using a query:

SELECT t1.id,t2.id as componentId,t2.component,t2.qty AS available FROM t_bom as t1
LEFT JOIN i_components AS t2 ON t1.componentId = t2.ID

retool_update01
retool_update01590×591 18.4 KB

Bulk update via a primary key works fine with single table, but for joined tables you can use the following solution:

retool_update02
retool_update021040×416 22.7 KB

{{t_projectBOM.recordUpdates.map(row => Object.assign({'ID':row.componentId,'qty':row.available}))}}