I think i’ve run up against a limitation of coda’s calendar’s…
I’ve read many times people asking about wanting calendars from two tables in one calendar.
And the answer has always been to redesign the schema.
I completely understand this solution… but riddle me this!
My schema involves
which can have multiple tasks associated with each project
which can have multiple bookings associated with each task.
So three separate tables.
I’d like the start/end dates of my projects AND the times of each booking (usually just half day bookings) to show up in a calendar view.
Can anyone suggest a schema that would combine this data into a single table? I feel like it would get extremely massive if I ended up going that way…?
OR - is there potentially another way? Is it now possible to display data from more than one table in a cal?
OR - should I just use gcal - and send the info there? (This looks like being a viable solution, as I can send to 2 different gcals but just display them both at the same time. We are lucky in that the small business has gsuite to run all our email/cals up to this point!)
Hope I’ve made sense. Cheers.