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