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

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

lala — Mon, 28 Aug 2023 10:02:51 GMT

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} );
);

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

mmarchandTSI — Mon, 28 Aug 2023 13:43:58 GMT

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} );
);
)			)
		)
	)
)

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

lala — Fri, 15 Sep 2023 14:33:27 GMT

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!