ReadyOneIndustries Posted February 12, 2020 Report Share Posted February 12, 2020 Good morning, We have a workflow on our production line where Garment X has to go through Lining Inspection, Shell Inspection and Final Inspection. It can't go to Final without first hitting the other 2. That being said, at any point Garment X may fail due to a quality defect and have to go to Rework/Repair In and then Rework/Repair Out or Non-Conforming if it's an irregularity that cannot be fixed. Once it's done with Rework/Repair IN and OUT it will need to go back to the failing station. This is what I have so far: Virtual Field 1: SELECT MAX(StationNumber) FROM Test WHERE Barcode=target.[@field: Barcode] Virtual Field 2: CASE WHEN '[@cbParamVirtual1]' = 'Lining Inspection' THEN 1 WHEN '[@cbParamVirtual1]' = 'Shell Inspection' THEN 2 ELSE 3 END Virtual Field 3: CASE WHEN [@field:StationNumber] = 'Lining Inspection' THEN 1 WHEN [@field:StationNumber] = 'Shell Inspection' THEN 2 ELSE 3 END Virtual Field 4: CASE WHEN '[@cbParamVirtual1]' = '' THEN 1 ELSE CASE WHEN '[@cbParamVirtual4]' + 1 != '[@cbParamVirtual6]' THEN 1/[@cbParamVirtual7] ELSE 0 END END Virtual Field 5: 0 Datapage: https://c1abq060.caspio.com/dp/40146000736502fab3184014a614 What currently happens, is if you enter Serial 123456 into Lining Inspection, it will pass. When you enter Serial 123456 into Final Inspection instead of Shell Inspection, it will be rejected as it should. The issue I'm running into, is I need to be able to make lateral movements. If Serial 123456 fails Lining Inspection, I need to be able to send it to Rework/Repair IN and then OUT before sending it back to Lining Inspection. Please let me know if I didn't explain this well enough. Thanks in advance! Quote Link to comment Share on other sites More sharing options...
geoffdude Posted February 13, 2020 Report Share Posted February 13, 2020 Can you provide a wire-frame of the flow that way we can see what's supposed to happen. Like: Product = GARMENT X Serial Number = 123456 Emp Id = TestID-00001 Station = Choices (Station A, Station B, etc) Then create the wire-frame for us to look at ... like this example below, except show your form fields w/names and what should happen with it's use (It will help us to figure out the flow/logic.) kpcollier 1 Quote Link to comment Share on other sites More sharing options...
ReadyOneIndustries Posted February 14, 2020 Author Report Share Posted February 14, 2020 Quote Link to comment Share on other sites More sharing options...
ReadyOneIndustries Posted February 14, 2020 Author Report Share Posted February 14, 2020 Please let me know if this helps! Quote Link to comment Share on other sites More sharing options...
geoffdude Posted February 17, 2020 Report Share Posted February 17, 2020 Still a bit confusing to me .. however, how would the product "fail" lining inspection? What process in the flow validates/checks for a "pass" or "fail"? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.