How to update a specific cell in a table using Javascript

I have a query (query1) that is triggered when a drop down is selected in my table (table9). That query gathers the table row (0) and value (J2-5) needed for insertion into a column (PinCavity) within the same table (table9).

console

I know that changesetArray/changesetObject are read only arrays.

I've read all the postings on the forum but I haven't found anything that was concise on how to insert data into a table cell within a query.

So to recap, I have a query (query1), a table (table9) that I need to insert data (J2-5) at row 0, column PinCavity, how would that happen?

Any help would be greatly appreciated. Thank you :slight_smile: