Forum Discussion

GrahamHaskin's avatar
GrahamHaskin
Qrew Trainee
7 years ago

Processing New Hire Checklists

I'm trying to build a set of checklists for my company that will help in processing new hires.
The checklists themselves aren't hard, but I'm having a problem because each new hire will fall into one of four employee types, and each type has a different checklist.

Ideally, I'd like to have one table to record the new employee data, then a second table that is used for the checklists, but I don't have a good way of keeping all the checklists on one table.

The best I've come up with so far is to build one giant form with each checklist under its own section header, then use Dynamic Form Rules to show the appropriate section based on a drop down menu recording the employee type. It works, but means that any task that shows up on more than one checklist needs a duplicate field entry (since I can't use the same field in multiple places on the same form).

So my questions are:
Is there a better way of doing this? I've looked at both Automation and Copy Master & Detail Records, but either I'm not doing those right, or they're not what I need (I couldn't get them to populate empty fields to be filled out when completing the checklist)

Is there a way to load a form inside of a form? (My thinking is I could do some lookup fields at the top of the master form that will display the employee data needed (name, ID #, etc), then load the appropriate checklist form under those)
  • I have done New Hire checklist apps.  A low tech solution is to use the copy parent detail wizard.  Set up 4 model Employees.  Use that wizard 4 times to create, respectively, 4 buttons to import children from specific records.

    Then use a form rule to only show the user the correct button according to the EE type.  
    • GrahamHaskin's avatar
      GrahamHaskin
      Qrew Trainee
      I guess I must be using the Copy Parent Detail system wrong, can you give a few steps for this process?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      Well just follow that wizard but when it gets to a point it will ask you if you always want to copy children from a specific record, choose that option.
    • KristopherLesli's avatar
      KristopherLesli
      Qrew Member
      Alternatively, you could use a Google Form, fill that in, and have the results imported into QuickBase. 

      IMHO if this is a checklist for IT, then it would be a bad idea. But if it's a checklist for other dept's, then it's a decent idea. In my company, we still have a word doc for the checklist for HR and the admin side. For my IT dept, we are walled off intentionally from that process as it doesn't work well for us.

      If you break down the process, New Hires have many Checklists (New Hires < Checklists) so you can see how the relationship works.

      If you'd like to provide an example of some of the fields you're using, I can make a demo app and share it with you quickly.
  • I agree with the CopyMasterDetail solution for this - I have implemented this many times for this purpose/function.  You can build multiple "templates" for different purposes and have users create separate templates or combine templates to give a complete list on a single button click.  You can also post multiple buttons on a single field and show/hide the ones that meet criteria to make it easier when using these buttons from reports.