2. PHPRunner General questions
  3. Complicated checklist
This topic is locked

Complicated checklist

 		1/14/2014 10:35:04 AM
PHPRunner General questions
R
 rgfischerjr author

I'm starting to work on an application that will be used to capture results from daily checklists. The general parameters are:

  • app will be used by multiple locations
  • app will consist of multiple checklists (i.e. am opening, pm closing, line check, bar opening, bar closing, etc.)
  • checklists are performed daily and each days results need to be stored, viewed, but not editable after submitted by user
  • each location will use multiple checklists, but not all locations will use all checklists
  • items on the checklists will vary by location
  • checklist will need ability to be 'suspended' as the checklist may be started, stopped several times before the list is fully completed
    I would greatly appreciate thoughts, suggestions and comments on how to best implement this.
    Thanks!
Sergey Kornilov admin 1/14/2014

If you want something really simple - create a separate table for each check list and filling a checklist will be as simple as adding a new record to that table. You might need to add fields like date created, user id etc.
Another option - use Survey template. In this case to create a new check list you need to create a new survey, setup all fields as checkboxes and this is it.
R
 		rgfischerjr author 1/14/2014

Hi Sergey -
Happy New Year!
I purchased Survey Template yesterday and am experimenting with it - I thought that it might be a good solution.
I got stuck on creating a separate table for each checklist because they are not static - for example the Bar Opening list might contain Items 1, 2 and 3 for Location A, and only Item 2 and 3 for Location B. Next week, Location A may need to add new Items 4 and 5 and drop Item 1. Given 15 locations, 20 or 30 checklists with a couple hundred potential items... this can get messy very quickly.