As a “demo” project to get started with Coda I’m trying to build a document to handle prescribed medicine.
As you could see in a simplified example I have a calendar view that contains medicine list prescribed for the day. Medications table has a Take Time column that defines in which time period specific pills should be taken.
The question is how to make a proper calendar visualization basing on provided data so the day in the calendar will contain series of events rather than one event. And events will belong not to date but to morning/noon/evening of the date and basically every day in my specific case will potentially contain 3 events (as per “Medicine Take Times” table: morning, noon, evening). To be more specific 12th of April should contain no events at all (now it contains empty event instead) while 17th of Apr should contain morning event from 9am to 11am with the value of “Chlorophyll, Omega-3, Glycine” and evening event from 8pm to 12am with the value of “Omega-3, Gaba”.