Programmatically Expand/Collapse (Expandable) Rows in Table

[MiguelOrtiz]

Just to share another post to allow only a single row in a table to be expanded

.i, ri, currentRow, currentSourceRow not resolved right in expandable row

Hello there, Just to share, we added this script to an expand row event handler to automatically collapse the row previously expanded. This enables only one row to be expanded at one time. Not sure if it is the most efficient way, but it works for now. table1.collapseRows({ mode:"key", key: variable1.value }) await variable1.setValue(table1.selectedRowKey); UPDATE: There was an issue when users collapsed and expanded the same row, I added an "only run when" [image]

[shawnhoffman]

@Tess

Why am I unable to reference something in the expanded row?

I put {{expandedRowText}} for example as a text input in the expanded row.

Then I want to add an event handler to an action button on the table itself that is conditioned on {{!expandedRowText.hidden}} so it only occurs if the row is expanded. I'm not understanding how to reference an object in the expanded row or how to reference the expanded row itself.

[MiguelOrtiz]

Hi Shawn,

One way of referencing a component within an expanded row is by referencing the index of the selected row in your table, e.g. {{expandedRowText[table1.selectedDataIndex].hidden}}.

Bear in mind that the component would only be available if the row has been expanded any time during the user's session, so you'll have to make sure you're action button on the table is disabled if the row has not been expanded (as it won't find the component referenced in it).

[shawnhoffman]

I just keep getting 'expandedRowText is not defined'

[Tess]

Hi @shawnhoffman,

I don't think you can accurately use the expandedRowText's hidden property alone to check if a row is expanded

If you look at the state for the expandable row's child components, the component doesn't exist in state until you've expanded the row

Haven't expanded any rows yet:

State after expanding the first two rows (stays the same after closing the first row):

I thought Miguel's idea of checking if the row has ever been expanded, it'll be in the state, and can therefore be evaluated was working for me, but I seem to be running into some caching issues. We have a feature request for a collapse row event handler that would be helpful for maintaining a list of the currently expanded rows

[peter.b]

Doesnt look like this is available on-prem cant see any expandRow method

[Tess]

Hi @peter.b what version are you using? I believe it shipped out in 3.37-edge (Self-hosted Retool 3.37 Edge release notes | Retool Docs)

[peter.b]

we are at 3.33(stable) - which explains why we dont have it yet

[Omar_Tarek]

Hello @Tess ,
Can we expand grouped rows programmatically?

[Tess]

Hi @Omar_Tarek, that feature request is still in our queue

[TomJaud]

Can we expand expandable rows yet?
not grouped ones!

[Cassab]

I'm trying to collapse all rows and than expand just the selected one. Is that possible? If so, how can I do it?

[Tess]

Hi @Cassab,

You could have a select row event that expands the selected row & a separate expand row event that collapses all but the selected row

@TomJaud, yes there are expandRows and collapseRows methods for the table