- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 02, 2021 10:51 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 04, 2021 08:44 AM
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:
