671657_en-US

liliconcom

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

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

Use the <

 

: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?

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!