Hi, I’m new to Airtable and looking to build a database that holds multiple certificates with obtained dates and expiry dates. Is it possible to set one table with all the types of certificates and then link another table with the employee details so that they all end up with a list of different certificates or will I have to enter a whole heap of individual records? I will be use Softr as the app. Thanks for any advice, I havent found a template that does the trick.
+21This usually calls for a junction table, a 3rd table that expresses details about the link between employees and their certifications. In this setup you’d have a table listing all your employees, and another listing all the possible certifications. Then your third table are records linked to an employee and a certification, and this table contains information like certified date and expiration. Short answer is yeah it requires a whole heap of records…
But what's nice about Airtable is you can use automations or record templates to make those records automatically generated. Your approach can vary according to how many certificates you’re tracking, but I’d probably start by looking at something like making a multi-select field on the employee table with all the various certificates, and then an automation that fires when a record matches condition that generates an appropriate junction table record. You could also set up some formulas to automatically set expiry dates (1 year from obtain date, that kind of thing).
+31Here’s an example base of what DisraeliGears01 is talking about for the junction table and you can duplicate it into your own workspace to play with it!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.