How to put value in spec limit column properties

mystylelife19

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, HListBox( Panel Box("Make a selection", VlistBox( usropt = RadioBox(columnNames, prmtr=usropt<<get ) ) ) ) ); //Text Box Put value spec limit Upper & Lower wd = New Window( "Spec Limit", << modal(), hlistbox( Text Box( "HighL:" ), High_Limit = Text Edit Box( "",<<set width( 90 ) ), ), Button Box( "OK", HighL = High_Limit << get number(); ) ); wd = New Window( "Spec Limit", << modal(), hlistbox( Text Box( "LowL:" ), Low_Limit = Text Edit Box( "",<<set width( 90 ) ), ), Button Box( "OK", LowL = Low_Limit << get number(); ) ); //Put value Spec Limit on choosen column col = Column(prmtr); col << Add Column Properties( Set Property( "Spec Limits", {LSL(LowL), USL(HighL), Show Limits( 2 )} ) );

 

 

mystylelife19

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,
    HListBox(
		  Panel Box("Make a selection",
			VlistBox(
			  allcolumn = RadioBox(columnNames, 
			     prmtr=allcolumn<<get
					)
				)
			)	
		)
	);

//Text Box Put value spec limit Upper & Lower


wd = New Window( "Spec Limit", << modal(),
	hlistbox(
		Text Box( "HighL:" ),
		High_Limit = Number Edit Box( "",<<set width( 10 ) ),
	),
	Button Box( "OK", 
		HighL=High_Limit<<get;
		)
	);
	
// If cancel or X was clicked, stop the script
If( wd == {Button( -1 )}, Stop() );	
		
wd = New Window( "Spec Limit", << modal(),
	hlistbox(
		Text Box( "LowL:" ),
		Low_Limit = Number Edit Box( "",<<set width( 10 ) ),
	),
	Button Box( "OK", 
		LowL=Low_Limit<<get;
		)
	);

// If cancel or X was clicked, stop the script
If( wd == {Button( -1 )}, Stop() );



//Put value Spec Limit on choosen column

col = Column(prmtr);

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