I tried searching the forum but could not find what I am attempting to do.
My objective is to create a Case Study and Employee Resume master database.
My goal is to be able to select an employee, select a project that the employee worked on, and then receive an output that shows that employees resume description for that project. I’m stuck on how to achieve this in Airtable.
Here are my tables so far:
Employees that Worked on the Project
Description of Project
Role Firm Played
Projects Employee Worked On (Linked)
I’m not certain how to get to the next step. Where should I store the employee’s project description when I have 65 employees? Can I do conditional formatting to be able to select what I want?
Any help would be greatly appreciate.