Skip to main content

Hello,

I’m looking for a way to create a schedule based on projects stored in a main list (with the project name and team assignment).
I’d like to display a calendar running from 7 AM to 4 PM, Monday through Friday only.

A single project may be assigned to multiple days, and I’d like the view to show:

  • Teams arranged along the X-axis,

  • Days of the week along the Y-axis.

The planning would be managed in AirTable, but visualized in Noloco.

I’ve been trying different approaches but haven’t managed to get a clear solution.

If a kind soul could help me set up such an interface, it would be greatly appreciated!

Gauthier Arnould

 

Hi ​@Gauthier Arnould! How did you go with this one?

If you’re still working through it, a Timeline interface like the below might tick most of your boxes.

  • Your projects (here ‘Tasks’) are the key (i.e. ‘fact’) record 
  • Each one has a start and end date (which defines the extent of the bars below)
  • Each one is assigned to a team (which is what the ‘group by’ was set to below)

Where a compromise may have to take place:

  • If you want to have team/task down the X axis, you won’t be able to have ‘time of day’ down the X axis (this applies to any visualisation, not just Airtable).
  • Unless you are scheduling (and maintaining) things by the precise hour, it’s often easier to just have the project straddle a number of days and say ‘8 hours per day’ or ‘total 30 hours for project’.

Natural extensions you can do from here:

  • Colour-coding of each bar based on a single-select or a condition (e.g. overdue)
  • Summary statistics (the 2, 2, 2, 2, 0, 1, 1, etc you see below) which can tell you e.g. how many projects are currently active for that team on that day (i.e. what the below is) or some other calculation, including team utilisation if you have resource capacity data in there as well.