I’m relatively new to Retool and SQL, so forgive me if I’m not explaining things correctly.
I have a table with lots of rows and columns. When I create a table to show all the rows, it errors out because it’s way bigger than the 100MB limit.
I’m able to significantly cut down the data by selecting specific columns I want to show on the table, instead of selecting them all.
However, I would like to be able to click a row to open a modal with all the data, not just the ones I selected for the main table. At appears this isn’t possible, as the data available to me in the modal are the columns I’ve selected in the main table.
Is there a way for me to access all columns in a modal, regardless of what I select in the main table?