# Resource availability schedule

**URL:** <https://forums.knack.com/t/resource-availability-schedule/18807>\
**Category:** Get Answers\
**Created:** [February 24, 2025, 4:29pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807 "2025-02-24T16:29:34Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pete1](https://avatars.discourse-cdn.com/v4/letter/p/67e7ee/32.png) [@Pete1](https://forums.knack.com/u/Pete1)\
**Post date:** [February 24, 2025, 4:29pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807/1 "2025-02-24T16:29:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [February 24, 2025, 8:14pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807/2 "2025-02-24T20:14:16Z")

</div>

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

[Here is a solution](https://forums.knack.com/t/looking-for-a-visual-scheduling-solution-integration/18606/6) that shows visually how many tasks each resource has been allocated per day.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/8/83191e4346ef90912ecb66c99c9e242476749d6f.png)

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](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/6/608e161124f2691633718b8635f5211ec803f356.gif)

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

---

<div class="post-metadata">

**Author:** ![LeighBerre96926](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/leighberre96926/32/4896_2.png) [@LeighBerre96926](https://forums.knack.com/u/LeighBerre96926)\
**Post date:** [February 25, 2025, 11:17am UTC](https://forums.knack.com/t/resource-availability-schedule/18807/3 "2025-02-25T11:17:46Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![Pete1](https://avatars.discourse-cdn.com/v4/letter/p/67e7ee/32.png) [@Pete1](https://forums.knack.com/u/Pete1)\
**Post date:** [March 13, 2025, 12:31pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807/4 "2025-03-13T12:31:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Erik](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/erik/32/982_2.png) [@Erik](https://forums.knack.com/u/Erik)\
**Post date:** [April 4, 2025, 1:32pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807/5 "2025-04-04T13:32:18Z")

</div>

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 “-”

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/2/21a0c0f778e2447fab53eb71ad4e0a2583c3e55c.png)

---

<div class="post-metadata">

**Author:** ![Erik](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/erik/32/982_2.png) [@Erik](https://forums.knack.com/u/Erik)\
**Post date:** [April 4, 2025, 1:33pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807/6 "2025-04-04T13:33:46Z")

</div>

And this is the same, but across all projects.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/a/aed48e65290f685ba3cd5f6e3bb4a0763eacfdea.png)

---

<div class="post-metadata">

**Author:** ![Pete1](https://avatars.discourse-cdn.com/v4/letter/p/67e7ee/32.png) [@Pete1](https://forums.knack.com/u/Pete1)\
**Post date:** [May 8, 2025, 8:23am UTC](https://forums.knack.com/t/resource-availability-schedule/18807/7 "2025-05-08T08:23:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Erik](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/erik/32/982_2.png) [@Erik](https://forums.knack.com/u/Erik)\
**Post date:** [May 8, 2025, 2:59pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807/8 "2025-05-08T14:59:28Z")

</div>

Oh, that’s VERY cool!

---

<div class="post-metadata">

**Author:** ![Erik](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/erik/32/982_2.png) [@Erik](https://forums.knack.com/u/Erik)\
**Post date:** [May 8, 2025, 3:23pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807/9 "2025-05-08T15:23:58Z")

</div>

The example Views are Pivot Tables.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/c/c0578e6857c475e7de66f48c3e78626efce8c5a0.png)

The Data is configured as below:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/4fbaa31771b0ba6d42765fc6deeae4c39902e39a.png)

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

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/2/288c5924f7516dc9f69f1268d63f0c5d984ccbc0.png)

That helps with this error message:

![image](https://us1.discourse-cdn.com/flex020/uploads/knack/optimized/2X/8/8f2908783a21a26d3c2bdad6e2c1c050d3778a33_2_517x45.png)

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

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/b/ba1083cfd637ebdf2de7862ccb187716b881e9cf.png)

---

<div class="post-metadata">

**Author:** ![Erik](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/erik/32/982_2.png) [@Erik](https://forums.knack.com/u/Erik)\
**Post date:** [May 8, 2025, 3:32pm UTC](https://forums.knack.com/t/resource-availability-schedule/18807/10 "2025-05-08T15:32:08Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/d/dc7d7abeed31f40176f0a75d05ac2ce0154455c5.png)

looks like this:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/a/a1e5b0e05aa7c3081297e84aa01120615421028f.png)

Let me know if you have any questions about this.
