Skip to main content

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!

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 🙂

Reply


Terms & Conditions