I’ll try to describe my situation.
I’ve got 3 tables: Team Members, Project and Roles.
Each role is linked to a project and a team member.
Each role contains, as information, a start date, an end date and the number of hours / day.
For example, Tommaso will be lead developer on project one from 01/03/2021 to 12/03/2021 with a with a commitment of 4 hours/day.
Tommaso will also be Sw Architect on project Two from 1/02/2021 to 4/03/2021, with a commitment of 3 hours/day.
Here’s the question: is there a way to show the daily workload on a calendar view or a gantt view?
For each day I would like to see the sum of the H / days on the various projects, for each team member.
Sure there is a way. But in my personal opinion, your question exceeds the scope of technical inquiries this forum is intended for. In fact, it could be the matter for a small project in its own.
Here’s a hint:
In your table an important role is missing: Database Designer.
So I’d start off by adding an entry on the Projects table: Three, “Airtable development of team calendar”,
Then add a team member and assign the role: Db Designer for that project.
I think you get the idea :slightly_smiling_face: