@Warwick @Dean2, sorry for the delay. I was coming up with a better solution because I wasn’t super happy with the set up on the original I showed you.
My old method required two separate views, a heavy-duty API call, and a separate modal page.
My new method uses one grid view with some JS manipulation to do the following:
- Loop through the next 30 days, and add a column to the grid for each
- For each date, loop through each task and check if it overlaps that date, and add a 1 to the respective date column
- For each row grouping, count the number of tasks overlapping that date for the tasks that sit beneath it
- Add collapsible groups for better readability
You can see the below video for how it works and how to interact with it:
Current limitations are:
- 1,000 record limit - based on the current Knack limit for rows per page, and to not have to fetch data via an API call
- Groups do not remain expanded after inline edits/page refreshes
- Does not display resource groupings that haven’t already been assigned
- No drag-and-drop functionality
Happy to answer any more questions, and keen to hear any feedback! If you’re interested in installing this solution, please contact me.