I have a main table with two specific data columns I load into two separate drop downs in another table. In the new table, picture selecting a value and wanting to populate the adjacent cell at the same time.
In other words, I have two populated drop-down cells in a new table based off of collected column data from the main table.
I need the new table to populate the (pin cavity) value column based on the selected (pin name) value column and vice versa.
I can get each column to correctly provide the data in each drop-down table cell but they work only independent to one another.
The attached image shows how I got the independent dropdowns populated. I need to have them work together when either drop-down selection is made.
I'm new to Retool so I'm not sure.
I'm relying on data in the main table to populate the drop-downs of the I/O Function with another cell drop down populated with pin cavities (check).
I want to select either the I/O function value or pin cavity and auto populate the other based off of the accompany selection made.
Hi @cz0840! Welcome to Retool and to the community.
I'm not actually sure this is currently possible. A table's staged edits are all stored in something called the changesetArray; unfortunately, its value is read-only and thus can't be set dynamically. We've had quite a few customers reach out with use cases that require write access to the changesetArray, so I do think this will eventually be an option. I'll update that internal conversation with the use case that you've described here!
It's a little hard to tell based on the screenshots that you've shared, but would it be possible to recreate the same app without a table component? The problem that you're facing could be easily solved with two regular inputs.
