New to Coda and this whole way of working, even though I did a very little bit of this in Notion a few years back.
I am setting up a document for our small organization that hosts weddings and rental events. My 1st thought was to use one DB for all events, but weddings have different info required than for a music rental let’s say. And looking at other templates (like to-dos and others) it seems they break this stuff up into different tables/DB
Does this method make sense:
- I created separate Tables for Weddings (named, DB:Weddings) and Events (DB:Events), both on the same page.
- I created a table (DB:Room) for the 4 rooms we host these events in. (I am not sure why this should be this way, but looking at various examples, seems like it is most flexible to keep these things separate. Also, then I can add additional rooms if needed?)
- I created a table for the Type (DB:Type) of event: Wedding, Rental, Internal. Again, not sure this is best, instead of just using these as select field in each table? But it seems to make sense all tables get this info from one place?
So, if that all makes sense - can I make a “master” calendar view that will draw from both Wedding and Events tables? So we can see all events coming up in one place?
Thank you for your help. Hoping to learn as I go, so I can ask “better” questions.