Skip to main content
Question

Checklist variations

  • May 8, 2017
  • 0 replies
  • 56 views

I am looking to create a checklist for our Preventative Maintenance. I am hoping that someone can help me think of an elegant solution to creating this. 

The main issue is that we have many machines, and each has a different set of items to check off. Although, some of the items do cross over but not many of them. 

I currently have a similar checklist set up, but it's a little messy to make updates to, and I'm hoping there may be an easier solution. Currently, I have a checklist with 6 different variations, and I've added 6 sections with the checklist items on them. Each section only appears when it's option is selected. However, this is a lot of fields as I have to add all items under each section. This checklist I have set up already has 10-12 checklist items on it and is already cumbersome to update. These new checklists have 50-100 items on them. 

Does anyone know of some way to make this a little simpler?


I have added some screenshots of the lists I currently have. As you can see in the first image, my first field allows the user to select the type of checklist they are completing. Once this is selected it shows the correlating section for them to complete. This method has these 6 short checklists in one form with 173 fields. Many of these checklist items overlapped, but not in the same order. 

I would appreciate any thoughts on this you may have. 

Thanks!
This topic has been closed for replies.

  • Registered
  • May 8, 2017
I'd recommend turning the checklist into a child table.  Then you would have a template checklist table, and when they pick the 'type' and push a button, only those child records would load into the checklist.

Then you can customize the lists for every type, and if down the road your list changes, you just change the template, without causing any problems to the old checklists.

It is a much more scale-able solution, and gives you much better reporting capabilities. 

  • Registered
  • May 9, 2017
It would be one 'checklist' table.  And you would have one "Template Checklist" table.  

Each 'Release Type' would have many checklist templates.  
You can then make your lists, so for 'x' release type we have these 10 questions, and for 'y' we have these 12 questions.

Each 'Release/Receiving' (or whatever you call the main item) would have many 'Checklists'.
But, instead of picking the the 'type' on the checklist, you would pick the type on the parent (Release/Receiving).

Then you would load (via script) multiple child records or checklist items that match that 'type'.

***I absolutely butchered that explanation.  I can always show better then explain***  

Or do you get what I was trying to say?