cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
lala
Level IX

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 IX

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

 

 

Recommended Articles