Jump to content

Recommended Posts

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!

 

Link to post
Share on other sites

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.)
 

example_wireframe.png.38b615690bc982a7e477226bd7616220.png

Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...