How to update a specific cell in a table using Javascript

[cz0840]

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).

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

[Darren]

Hey @cz0840! I'll summarize some of the points I've made elsewhere, as I think this is a common point of confusion among users that are relatively new to the platform.

The key to understanding Retool tables is realizing that they actually aren't that similar to spreadsheets. Instead, they are a visual representation of data - typically a backing database but almost always the return value of some query.

As such, the most reliable way to update the contents of a table is to instead update the backing data source!

This typically means making a request to the database, as I demoed here. Let me know if you have any questions about implementing this!