83180_en-US

liliconcom

Update NE Box from Cell in Same Row of Table Referenced by Combo Box

Hello all

 

I've been trying to update a script handed down to me, and while I've had a lot of success with it, one item keeps tripping me up. Instead of having users enter a height and width (used later in the script to generate a bivariate map), I want to have the option to auto-poplulate those values in number edit boxes (in case the user still wants to input the values manually) based on the values that correspond to a part name in a table. Modifying the example I found, it would be something like this:

 

dt = Open( "$SAMPLE_DATA\Big Class.jmp" );
Summarize( a = By( :name ) );
Insert Into( a, "<SELECT name="">", 1 );
New Window( "Example",
 <<MODAL></MODAL></SELECT>

 

 

Re: Update NE Box from Cell in Same Row of Table Referenced by Combo Box

Well, after a lot of trial and error, I eventually figured it out. The problem was trying to set a number in the number edit box. It ended up being easier—for me, at least—to make the number a string and set text, converting it back to num when it's retrieved. It ended up looking something (but not at all, heh) like this:

 

dt = Open( "$SAMPLE_DATA\Big Class.jmp" );
Summarize( a = By( :name ) );
Insert Into( a, "<SELECT name="">", 1 );
NameAge = "--";
NameWeight = "--";

New Window( "Example",
<<MODAL></MODAL></SELECT>

Likely not the most elegant solution, but hey.