topic Re: Linked columns and inter-table row selection in Discussions

Linked columns and inter-table row selection

ehchandlerjr — Tue, 28 Nov 2023 05:17:16 GMT

Hello - I don't think this exists, but thought I would ask anyway. I have a few different projects where I link columns. I have had a few times where I have thought that it would be super useful to be able to select the row of one of the linked tables, and then the corresponding rows in the other gets highlighted. I have one 50k row table and another 150k row table, and scrolling through can get tedious, as can trying to grab just those points. Of course there are row selection menus, but this takes a long time when you are switching your selection a few dozen times.

Is there a way to do this?

Thanks!

Re: Linked columns and inter-table row selection

mmarchandTSI — Tue, 28 Nov 2023 13:58:27 GMT

Event Handler can accomplish what you're describing. Something like this:

For readability/copy/paste:

Function( {thisTable, thisColumn, iRow},
{ /* list of local variables, if needed */ },
dt2 << Select Where(:name == thisTable:thisColumn[iRow] )
);

Re: Linked columns and inter-table row selection

ehchandlerjr — Tue, 28 Nov 2023 16:38:55 GMT

This is awesome! Thank you so much!

I did notice that you can only do one row at a time. Is there a way to do an arbitrary selection of rows?

Thanks!

Re: Linked columns and inter-table row selection

mmarchandTSI — Tue, 28 Nov 2023 17:43:20 GMT

The Event Handler Column Property performs an action when you click on a row in the column, so this solution would be for only very simple selections, one at a time. Are you thinking you'd like to select corresponding rows in the linked table every time you select a row or group of rows in the main table? If so, I'd consider adding a simple table script.

sel = :name[Current Data Table() << Get Selected Rows];
dt << Select Where( Contains( sel, :name ) );

If you save that as a table script, you can select the rows you want and then just click the green triangle. Sure beats scrolling through 100,000 rows!

Re: Linked columns and inter-table row selection

ehchandlerjr — Tue, 28 Nov 2023 19:30:03 GMT

Dang dude - This is awesome. Extremely helpful. If I could give you two kudos, I would.

Kinda seems like an obvious and easily implementable feature for linked data tables. At least to have a checkbox to turn the feature on or off, since it might be annoying sometimes. Hmmmm. I might add this to the feature requests.

Thanks again! This really helps, and you've introduced me to Event Handler (and that whole bottom section of column properties I never go to). Super useful!

Re: Linked columns and inter-table row selection

hogi — Fri, 22 Dec 2023 16:02:07 GMT

That's really cool - thanks for asking - thanks for the nice solution :)

@ehchandlerjr wrote:
Kinda seems like an obvious and easily implementable feature for linked data tables. At least to have a checkbox to turn the feature on or off, since it might be annoying sometimes.

For linked data tables, actually, there exists such a one-click checkbox:

sourceTable:linkID << Set Property( "Link ID", 1 );

targetTable:linkID << Set Property(
	"Link Reference",{	Reference Table( sourceTable), Options( Row States Synchronization with Referenced Table( Dispatch( 1 ), Row States( Select ) ))
);

(view in My Videos)

Re: Linked columns and inter-table row selection

mmarchandTSI — Tue, 28 Nov 2023 21:34:48 GMT

Good information, @hogi. I never use actual linked tables, so I hadn't thought about digging into the options there. Good to know!

Re: Linked columns and inter-table row selection

ehchandlerjr — Wed, 29 Nov 2023 02:42:42 GMT

Wow. I had originally mosied over to the column properties for the Link column and didn't see it, but I'm confused why I never thought to look over at the link reference. Thanks for showing that! This thread now has three completely distinct answers.