I’m trying to interface with a database within a shiny app in R. The gist of the issue is that the table in question has many rows and I’d prefer not to pull the entire table down to save on data transmission times. Instead, I’d like to iteratively pull data based on user input – specifically some combination of pagination controls with other shiny inputs to drill down the data (not shown).

Is there a way to set default reactable table options (e.g., compact = T and striped = T) throughout instead of copy/pasting the same options for each reactable table?

I have ‘reactable’ data table and would like to create plot if on UI selected row in this table. The ‘condition’ is not workable.

I have a shiny app which stores a names of data frames. This names work as a SQL queries – when user clicks on the name, it should run the query and display result. I thought that I could use for that {reactable} to store the names and details parameter to call a function which runs a query ({DBI}). But what I want is to compute the query only when user clicks the name / row (I don’t even want to store the result – if user closes the details of row, results should be garbage collected).

This simple shiny app creates a two column table. I want to set the filterValue in the first column Name to Bob when I press the Set Filter button. At the moment, the table is displayed, but nothing happens when I press the Set Filter button.