I’m trying to figure out a way to show projects and upcoming bookings in a clear way for our small business - potentially using the calendar.
Unfortunately, Gantt chart displays of our projects are not working well since we cannot zoom into just this week…
Either, we see a zoomed out view (some projects go for months) or if I make a filter to zoom in, it excludes all the longer project from the view.
So - this is what it looks like without filtering - its not great, especially for the short turn around projects.
I then tried mucking around with calendars again, and the multi-day display. Which on week view works great. Except, you are left with the empty calendar underneath. Even setting the work hours to the minimum possible (which is 1 hour - from say 9am to 10am - its arbitary) means you loose screen real-estate and need to scroll down to see we have more info underneath…
Indeed - underneath we have a second calendar showing bookings.
As far as I know, there is no way of showing two tables on one calendar, although in this case that would be excellent. Projects at the top as all day events and bookings underneath.
All advice on the forum has been to change the data structure, which is not appropriate in this case given the one to many nature of bookings to projects, and then the other data structures around project deliverables, tasks, budget items, deliveries, invoices etc.
Is there perhaps a way to show JUST the all day events section of the calendar. That way I could just have another (differnet) table view underneath showing just the bookings. This would at least give me something semi-usable.
Has anyone got any other possible thoughts?
BTW : the bookings part of the calendar looks something like this :
You’ll probably notice the attempts of us to put more info into the cals with icons etc - but that too is a massive pain point right now for bookings! Especially when more than one studio is visable and the bookings get extremely thin in the display.
(Two other questions : 1. Is there any way to get the week scroll icons - the “<” and “>” to stay in the same position? At the moment they move which makes moving through a calendar extremely laborious! 2. Can we please have the DAY printed at the top of a weekly calendar - and along with that, the ability to start a week on a monday? I’ve searched threads and help, and I don’t think any of these are possible, but its always worth a try!)
Right now I’m thinking I’ll try use g-cal sync. But I don’t think this is fast enough - it needs to be real time sync, and I’ll need to sync from 2 tables to gcal, and then from gcal back to a single table for a single coda calendar. I can’t actually see it working, but you never know.
Any thoughts / ideas / other options for displaying the data muchly appreciated!