Hello All,
I need to navigate to the next screen based on different text merged together as shown below.
Set(ProdDir, LookUp(BatchTrack, 'Batch ID'= BatchID1.Text && 'Wafer ID'= WaferID1.Text, Product.Value));
Set(ProdStep, Switch(ProdDir,
"Prod1",
LookUp(Prod1, OpCode01 = Value(OpCode1.Text), Step),
"Prod2",
LookUp(Prod2, OpCode01 = Value(OpCode1.Text), Step),
"Trial",
LookUp(Trial, OpCode01 = Value(OpCode1.Text), Step)
));
Set(ProdStage, Switch(ProdDir,
"Prod1",
LookUp(Prod1, OpCode01 = Value(OpCode1.Text), Stage),
"Prod2",
LookUp(Prod2, OpCode01 = Value(OpCode1.Text), Stage),
"Trial",
LookUp(Trial, OpCode01 = Value(OpCode1.Text), Stage)
));
Set(Direct, ProdStep & ProdStage);
Navigate(Direct)
I was expecting having a variable in the navigate function wouldn't be an issue, but it doesn't compile.
Any ideas?
Thank you in advance.
Rob