Safety Report Question

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 have one of three answers (Pass/Needs Repairs/Fail). The clamps are divided up by areas throughout the plant, so each area's current paper form has anywhere from 5-15 clamps. Each clamp is also assigned a unique serial number, and one of five model numbers.

Is there a way to set this form up so that by selecting one of the 13 areas, we can answer all 11 inspection questions for the applicable area? Ideally all personnel throughout the plant use the same form which filters out only their applicable area and respective clamps.

We have tried using lookup tables by creating a table with all clamps and their associated serial #, model #, area, etc. and have run into issues with getting the questions to populate as a multiple-choice field in the inspection form.

Any help would be greatly appreciated!

markshnier__you · Answer

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

benrizz17 · Answer

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 · Answer

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.

Forum Discussion

Safety Report Question