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