ReadyOneIndustries

Please let me know if this helps!

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!

I have an submission form that allows you to scan barcodes into the system. It goes through several stations and we need it to reject an entry if one or more of the stations do not have records of that serial number making a stop there. Here's how it currently looks: Entry fields: Garment barcode Employee ID barcode Station barcode Virtual fields: When a Garment barcode is scanned, a virtual field displays where it was last scanned (which station) When an Employee ID barcode is scanned, a virtual field displays who the last Employee was that interacted with that item When a Station barcode is scanned, a virtual field displays which station last touched that garment What we would like, is if SN: 123456 reaches Station 2 without first going through Station 1, Station 3 without first Station 2, etc., it's rejected upon attempt to submit the form.