I am trying to update a column with a formula given a text edit box input. I have attempted other solutions found on the discussions page but with no luck
In the beginning of my code I define the area as 1 as a default. This is also the default value inside of the number edit box:
area = 1;
I have a column that uses the area variable:
dt << New Column( "Current Density",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( column(7) / area )
) << Move Selected Columns( {:Current Density}, after( column(7)) );
Then I have the function of the button. The hope is that it will take the updated value, plug it into the column and then rerun the formula in order to then update the plots I have in my JMP app.
NEB1 << Set Function(
NEB1 = Number Edit Box();
dt << set table variable( "area", NEB1 << get );
);
NEB1 << Set Number Changed(
NEB1 = Number Edit Box();
dt << set table variable( "area", NEB1 << get );
dt << Rerun Formulas;
Currently it returns the variable as "."
Here are other possibly relevant settings for NEB1
NEB1 << Set( 1 );
NEB1 << Set Lock( 0 );
NEB1 << Set Minimum( 0 );
NEB1 << Set Exclude Minimum( 1 );
NEB1 << Set Maximum( . );
NEB1 << Set Exclude Maximum( 1 );
NEB1 << Set Increment( . );
NEB1 << Set Integer Only( 0 );
I'm not sure what I'm doing wrong. Any help to return a number and update the column would be greatly appreciated.
Thanks!