Automatically have first row in table selected on page load

💬 App Building
1

I am wanting the first row in my table to be selected with the page loads as I have subsequent tables filtered on that table's selected row.. Since that row is not selected, it causes confusion with the user as no data is rendered in subsequent tables.

I tried using the table setting Default Row, Index: 0 but it doesn't not appear to work.

I found this post, where a suggested workaround is to add a success handler of the table's query to select the row of index: 0 with a debounce delay value. I am surprised this type of workaround would be needed for a behavior that seems like it should be native.

1 Like
2

Hello @isaacjm,

You may prefer this retool community forum Getting Row Focus on a Table

1 Like
3

Its OK, I have solved the problem.

I have just posted my solution on the Retool Community Site.

Mike

4

Hi @mdsmith1 - thanks for sharing your findings! Your suggestion is working, but might be an unintentional outcome of removing the Primary Key. I would guess the Retool framework team would not advise leaving Primary Key blank as it is an important field for other functionality... would like to hear from Retool team on if this is a confirmed bug or if there is an advised solution.

1 Like
5

Issac:

I used to use the Legacy Table and did not have these problems.

I had to do 2 work arounds to get a row to highlight when the table came up.

I consider this a bug.

I have also had to add special code to get the selected row to color up properly. If I use the tools, then red (Accent color) becomes pink.

I consider this a bug as well.

Mike

6

Hello @isaacjm,

Apologies for the issue. We have an open bug ticket to have some engineer attention on this to fix it.

What type of data source are you using? I haven't been able to reproduce this behavior, if you can share a video of the row selection not working on page load that would be very helpful for reproducing and fixing this!

I found that on my end either running a JS Query on page load and calling table1.selectRow() worked as well as setting the default index from the table's inspector panel worked for me as well.

7

8

Hi @Jack_T,

Here is a screen recording on google drive:

My resource query is for a Postgres db and my Retool version is 3.131.0
image

9

@isaacjm Thank you for sharing the video!

It looks like that drive is private but I just requested access to it :+1:

So to confirm with you, your table is not behaving the way that my table was in the video I shared above? Changing the default selected index in the table inspect to different values all do not apply a default select on page load?

10

Hi @isaacjm,

I was able to reproduce the bug!

Very odd, at first I thought it might have something to do with the filtering being applied.

It seems that if any row index besides zero is selected, it will correctly work on page refresh.

But, if the selected row is zero, it has to be toggled in the inspector/typed into the index input field and then it works until refresh.

My guess is this might be related to the default table loading in with zero as the default input. Filing the bug report for this now!