I am new to airtable but I feel like it has a lot of potential in order to manage my employees.
What I want to achieve is fairly simple:
- I want a list of all my employees (easy to do)
- I want a list of all my worksites (easy to do)
- a) I want to assign my employees to certain worksites and then be able to see on a calendar which employees is available for an upcoming project.
- b) I want to be able to filter that calendar by employee and / or by worksites
Daniel is working on project 1 in September and December
Roger is working on project 1 only in September but on project 2 in November and December
I have an upcoming project in November and want to see which employees are free in October
What would be the best way to go about successfully implementing step 3 in airtable?
I found a couple of templates but they seem to be too complex for what I’m trying to accomplish.