Hello all. I'm new to Airtable and I have been charged with setting up project and task management for our team. We have a team of about 10 with multiple projects and tasks that are randomly assigned based on availability and skill level. Each project has a timeline with tasks, start and end date, status and assignee. The assignee can have multiple tasks on multiple projects at any given time. My question is, do I create one base with each project as the master table or do I create a separate base for each project and sync the tasks, assignee and status. I need to have a calendar view for each assignee with all of their upcoming task due dates and ideally an overall calendar view for the team director who can see all upcoming tasks, due dates, etc.
We also want to share the status with groups outside our team for each project, so the outside team can see the status of tasks and overall project status.
There is another wrinkle in that help desk tickets also create tasks that are assigned for projects. Those also need to be incorporated into the calendar view.
Any guidance on whether I should start with one base or multiple bases would be greatly appreciated.