Sounds like a good solution for this might be the Virtual List technique. You can read about it here:
To get your coloured squares you'll want to put conditional formatting on the fields displayed in the virtual list.
Thanks, so, thinking aloud. My table has only 'event' i.e. a block from start to end. Assuming (because that's how it is) that the range is less than or equal two weeks I can now have a third. calculation field with 15 repetitions that is each date they are employed.
Then, from those articles, I create a report, that shows the results of the calculation field with, as you say, conditional formatting.
For those trading this way, a report on progress so far;
My table bookings has two fields Date Start and Date End
I create a third field with 31 repetitions DayState.
I have a layout with DayState as the horizontal component of the grid with 31 repetitions
I choose a month and make a variable with that month
I increment the days as an index $i
Compare with Date Start and Date End
If between the two (inclusive) I make a non-zero entry in the DayState repetition corresponding to $i
I then use conditional formatting to colour the square.
There's some housekeeping to do but basically I am there.
Is this a Virtual List? (genuine question, I don't know?)
We have a product called soSIMPLE Calendar. It looks like our timeline view may do exactly what you're looking for.
Then click "Month > Timeline"
We use a variety of solutions to accomplish this in our "Kosmas" FileMaker solution. Specifically, we use PivotTable.js to show total counts by day (see image). It pulls data from our Orders and Projects modules and shows them against schedules with crew members assigned.
We also use SeedCode's DayBack for Pro/Go and soSIMPLE Calendar for our WebDirect version. Finally, we use a Gantt Chart from Scarpetta Group for more serious long term planning.
Hopefully you figure out what works best for you!
Hey there - I've been looking for something like this for a while! Do you happen to have a sample file you could share?