Hi, I'm working on a Retool table to input multiple rows of data and save them all at once.
One of the columns is category_id
, which uses a Select
component inside the table cell to let the user choose from a list.
The dropdown displays properly, and I can select a value from the list.
However, when I try to log the value from the selected row, it returns null
.
Here’s what I’ve checked:
- The
Select
uses data from a query like select_category_query.data
value
and label
are both mapped correctly (item.id
, item.name
)
- I confirmed that the select component is working visually, but in my
console.log(table_data_var.value)
, the row index is correct but the value of category_id
is always null
Screenshot:
Any ideas why the value is not getting captured?
Thanks in advance!
Hey @krsailer82,
I can try this as a demo in my app. You can give it a shot too:
const editedData = table_entry.changesetArray;
console.log("Edited rows:", editedData);
Just replace selectedrows
with changesetArray
, and it should work perfectly.
Also, make sure that the mapped value for the category_id
editable column is set correctly.
Let me know if you'd like any more adjustments!
1 Like
Thanks for reaching out, @krsailer82! This is a common point of confusion. To @WidleStudioLLP's point, table edits are are not propagated to the backing data source - and thus table.data
- unless you specifically write queries to do so. All edits are instead stored in what we call the "changeset", either changesetArray
or changesetObject
, depending on how you want it formatted.
I hope that helps! Let us know if you have any clarifying questions.
2 Likes