I've looked at many of the Retool templates that show the concept of a master-detail view. They generally seem to load all data into a table and then reference the
selectedRow of the table to populate elements on the detail view e.g. PostgreSQL Admin Panel Template
I would like to do something different.
selectedRow on the
table is changed, I would like to trigger a SQL query that fetches additional information from the database and then render that information in the detail view.
Is this possible and what's the easiest way? I was hoping to somehow simply bind the results to a
Key Value component but that component doesn't seem to have any methods for setting the data.
I know I can hook into the
Row select changed event on the
table and run a
JS script from there but I can't see any easy way to bind the results to components.