Resource availability schedule

Has anyone managed to create a page showing a list of resources - each with their own availability calendar?? This would be invaluable for me in scheduling same respurces.
Many thanks

Hi @Pete1, I have been working on this for a couple of other Knacksters recently.

Here is a solution that shows visually how many tasks each resource has been allocated per day.

And here is what I’ve been working on recently for being able to quickly allocate single-day ‘tasks’ between resources and dates.
interactive-scheduling

Do any of these look close to what you’re trying to achieve?

1 Like

I’d be very keen to understand how you are achieving that drag and drop task allocation. I could definitely make use of something like this (especially if there was a way to drag from a pool of unallocated tasks).

1 Like

Hi Stephen,
The second view looks promising…
Could the tasks actually show availability, e.g. - ‘Available’, ‘Free AM’, ‘Not Avail’ and could they be repeatable (e.g. set to ‘Not Available’ every Thursday)?
Many thanks

This is a 1:1 pivot table of a record table.
It works pretty well and is editable in the cells.
Ignore the custom CSS overwriting zeros to “-”

And this is the same, but across all projects.

1 Like

Hi Erik,
What is the data structure behind this? Is it still a Calendar?
Would you be prepared to help create the specific view that I am looking for?
Cheers
Pete

1 Like

Oh, that’s VERY cool!

1 Like

The example Views are Pivot Tables.

The Data is configured as below:

I also Group my dates by Week to reduce the number of potential groupings.

That helps with this error message:

image

The data being pivoted looks like this (the redacted column does not apply here):

So, the underlying data filtered to the same resources and dates as this:

looks like this:

Let me know if you have any questions about this.

1 Like