How to automatically generate a checklist

[brianna_eagen]

I am using a customized version of the Employee onboarding Template base. The template seems to be set up to duplicate the base for every new hire that is being onboarded. I would like to use one base that generates a checklist for the employer onboarding tasks every time a new hire is created (I have a synced table with new hire records). I thought maybe I could use the new record templates feature, but the problem I'm encountering is that just linking tasks means that I can't use the "Complete" checkbox because it applies to the task record, not the task for a specific new hire. I hope this makes sense. 

Can anyone advise on how to make it so that everytime a new hire record is created, a series of tasks are created for that new hire specifically that can be used as a dynamic checklist?

[ScottWorld · Accepted solution]

The only way that you can do this is to completely restructure the entire database as a "many-to-many relationship", which is a more complicated type of relationship that requires 3 tables (instead of 2 tables) for your record linking.

You can read more about many-to-many relationships in Airtable's support document here.

Also, If your company has a budget for this project and you’d like to hire an expert Airtable consultant to help you set all of this up for you, please feel free to contact me through my website:

Airtable consulting — ScottWorld

[brianna_eagen]

Thank you; this article is helpful but I'm struggling to imagine what my three tables are. New hires, onboarding tasks and ??

[ScottWorld]

You can call it whatever you want: “junction table” or “individual tasks” or “new hires x onboarding tasks” or whatever you want!

[TheTimeSavingCo]

You could try using an automation with repeating groups if you'd like.  Make an automation that'll trigger when a new employee record gets created, look for all your template tasks, and create them all and link them to the new employee:

Link to base

[ScottWorld]

Record templates are the newer & easier way to automatically create linked records, but @brianna_eagen will still need to have a 3rd junction table in her base.

[brianna_eagen]

Thanks - I'm not stuck on the naming, more what the actual content of that table would be. Just to track the additional field of complete? In this scenario, is there one row per employee per task?

Employee name, task name, complete y/n

Employee name, task 2 name, complete y/n

[ScottWorld]

Each record would link to one employee and one task. So you will have 2 linked record fields: one linked record field for employee and one linked record field for task.