Logical branching to End an App?

I am creating an inspection app for my workplace. As each part comes into Receiving, the inspector chooses the part. From there a list of criteria is generated. However, each list is specific to the part. Some parts have 6 questions; some parts have 22 questions.

Part A:
Q1: Check the span of this hole.
Q2: Check the span of that hole.
Q3: Be sure there is a stamp of XXXX on the part.
Q4: Be sure there is a TRIANGLE stamp on the part.
Q5: Are there any scratches?

Part B:
Q1: Check the overall length.
Q2: Is the part painted?
Q3: (there is no question 3, so end the app)

I have 2 tables. One is the parent to record all inputs. The second is part numbers. The columns are part/name/procedure/q1/q2/q3/q4/q5/q6/etc. Since there are up to 22 questions asked, depending on the incoming part, if an inspector has a part that only has 2 questions like above, I would like it so they donโ€™t have to cycle through 20 more questions that donโ€™t exist. Like the 2 examples above: Part A should see 6 questions. Part B should only see 2.

Is there a way to add an END or conditional formatting to limit what the inspector sees?

Thanks,

0 11 286
11 REPLIES 11
Top Labels in this Space