cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Due to global connectivity issues impacting AWS Services, users may experience unexpected errors while attempting to authorize JMP. Please try again later or contact support@jmp.com to be notified once all issues are resolved.

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