cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
lala
Level VII

How can use JSL to automatically add code to "Event Handler" in "Properties" of a specified column?

Big Class.jmp

Thanks!

Function( {thisTable, thisColumn, iRow},
 {},
 n1rows = thisTable << Get Rows Where( :n1 == thisTable:thisColumn[iRow] );
 n2rows = thisTable << Get Rows Where( :n2 == thisTable:thisColumn[iRow] );
 thisTable << Select Columns( {thisColumn, :n1, :n2} ) << Clear Cell Colors;
 thisColumn << Color Cells( {3, {iRow}} );
 :n1 << Color Cells( {3, n1rows} );
 :n2 << Color Cells( {3, n2rows} );
);

2023-08-28_17-42-16.png

1 ACCEPTED SOLUTION

Accepted Solutions
mmarchandTSI
Level V

Re: How can use JSL to automatically add code to "Event Handler" in "Properties" of a specified column?

Use the <<Add Column Properties message:

 

:name << Add Column Properties(
	Set Property(
		"Event Handler",
		Event Handler(
			Click(JSL Quote(Function( {thisTable, thisColumn, iRow},
 {},
 n1rows = thisTable << Get Rows Where( :n1 == thisTable:thisColumn[iRow] );
 n2rows = thisTable << Get Rows Where( :n2 == thisTable:thisColumn[iRow] );
 thisTable << Select Columns( {thisColumn, :n1, :n2} ) << Clear Cell Colors;
 thisColumn << Color Cells( {3, {iRow}} );
 :n1 << Color Cells( {3, n1rows} );
 :n2 << Color Cells( {3, n2rows} );
);
)			)
		)
	)
)

View solution in original post

2 REPLIES 2
mmarchandTSI
Level V

Re: How can use JSL to automatically add code to "Event Handler" in "Properties" of a specified column?

Use the <<Add Column Properties message:

 

:name << Add Column Properties(
	Set Property(
		"Event Handler",
		Event Handler(
			Click(JSL Quote(Function( {thisTable, thisColumn, iRow},
 {},
 n1rows = thisTable << Get Rows Where( :n1 == thisTable:thisColumn[iRow] );
 n2rows = thisTable << Get Rows Where( :n2 == thisTable:thisColumn[iRow] );
 thisTable << Select Columns( {thisColumn, :n1, :n2} ) << Clear Cell Colors;
 thisColumn << Color Cells( {3, {iRow}} );
 :n1 << Color Cells( {3, n1rows} );
 :n2 << Color Cells( {3, n2rows} );
);
)			)
		)
	)
)
lala
Level VII

Re: How can use JSL to automatically add code to "Event Handler" in "Properties" of a specified column?

If I want to implement in the "event handler" of this column property that clicking on a cell in the name column automatically opens a web image with the text of that name with JMP Do I want to encode this Function() content?

 

Assuming that the site is:

https://community.jmp.com/KATIE.png

Thanks!

2023-09-15_22-24-18.png