Safety Report Question
We are trying to build an inspection form for clamps that are used throughout a manufacturing plant. There are about 100 clamps in total. Each clamp is inspected with the same 11 questions, which can...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you clarify the apparent conflict between these two statements?
"Each clamp is inspected with the same 11 questions"
"we can answer all 11 inspection questions for the applicable area"
Are you saying that the standard questions vary by Area?
Sorry for the confusion.
Every single clamp gets inspected with the exact same 11 questions.
The current way that these clamps are inspected are by area, where a different supervisor for that particular area uses the previously mentioned 11 questions for that area's clamps. What we are trying to do is make one form in Quickbase that all 13 areas can use that will filter out their own 5-15 clamps, and they perform those 11 inspection questions for each one.
Please let me know if any other clarification is needed. Thank you!
- MarkShnier__You
OK, Let's say an Area has 5 Clamps and you want to have one "form" that has 55 questions (5 times 11).
That can be doine but you would need to redesign the app so that One Clamp Inpection Record has Many (ie 11) Clamp Inspection Questions. So when a Clamp Inspection record was created, a Pipeline or a buttn would create the children. (There are two different ways to create the Children).
If the answers were all child records, then you could open up an Area form in Edit Mode and it could show an embedded report of the questions for all clamps in the area.
I suppose there could be a button to push to auto create all of the clamps for a given area and each clamp record within get the 11th child questions attached to it.
But this would be a complete redesign of your app structure.