654554_en-US

liliconcom

How to put value in spec limit column properties

Hi community, i'm trying my best to solve this but i failed again & again. Can someone tell me where is my mistake?

 

I want to put value text box in the spec limit column properties? I already tried so many times. If i

change

 {LSL(LowL), USL(HighL), Show Limits( 2 )}

into

 {LSL(500), USL(1000), Show Limits( 2 )}

it worked. But i don't want number, i want value in LowL & HighL. 

 

Here my full script</CODE></P><P>&nbsp;</P><PRE><CODE class=" language-jsl">dt = Current Data Table(); // Get the all column names from the data table columnNames = dt << Get Column Names("String"); // Choose the specific column cl = New Window("Column Selection", <<MODAL></MODAL>

 

 

Automation and ScriptingRe: How to put value in spec limit column properties

You will have to evaluate the values Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute . One option is something like this

Eval(EvalExpr(
 col << Add Column Properties(
  Set Property(
   "Spec Limits",
   {LSL(Expr(LowL)), USL(Expr(HighL)), Show Limits(2)}
   
  )
 )
));

Re: How to put value in spec limit column properties

Still did not work for me. The value from text box did not getting into the spec limit.

Re: How to put value in spec limit column properties

UPDATE!!!

After research all the topic in this community i already solve this with research apply all the method given every solution given. Thank god i solve this with helper from god. Alhamdulillah

 

Here my scripts 

 

// Open a data table or replace "Data Table Name" with the name of your data table
dt = Current Data Table();

// Get the all column names from the data table
columnNames = dt << Get Column Names("String");

// Choose the specific column
cl = New Window("Column Selection", <<MODAL></MODAL>

Re: How to put value in spec limit column properties

This does work for me

Names Default To Here(1);

// Open a data table or replace "Data Table Name" with the name of your data table
dt = Current Data Table();

// Get the all column names from the data table
columnNames = dt << Get Column Names("String");

// Choose the specific column
cl = New Window("Column Selection",
 <<MODAL></MODAL>

Also if you would like to, you could combine all those selections into a single modal window

Names Default To Here(1);

dt = Current Data Table();
col_names = dt << Get Column Names("String", Continuous);

nw = New Window("Set Specs", << Modal,
 H List Box(
  Panel Box("Select Column",
   rb_col = Radio Box(col_names)
  ),
  Panel Box("Select Limits",
   Lineup Box(N Col(2),
    Text Box("LSL: "),
    lsl_neb = Number Edit Box("", <<SET width=""></SET>