How to calculate and show daily workload

[tommaso_1988]

Hi All!
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.

Something like that (even without colors).

I hope I have explained

Thank you all!

[Grunty]

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: