I’m required to track my activities daily and I use an excel spreadsheet now. I’m wanting to make it better in Coda but I’m stuck on how to get only one view of the “date” and show a list of my activities.
Coda has me putting in the date for each activity and that leads to a repetitive view of the date in my table.
You would need to work with 2 tables linked to each others using a relation field and a linked relation field which would allow you to link a specific date to many activities .
So you would need :
One table to store the dates (which would act as a “Summary” table for your activities) with 1 date per row
One table to store each individual activity (1 activity per row) and its relevant info.
If you take a look at the sample doc below, the first table you’ll see is the table called Dates storing well, the dates …
This table is linked to the table Logs (which is the last table in the page, below the detail [View of Dates]) where, for each individual activity in the table, I’ve manually selected a Date in the relation field Dates (which could be done formulaically too).
This has now linked a date to some activities in the Logs table .
On the other hand, in the Dates table, this link is reflected in the multi select linked relation field Logs, where each activity selected for a day has been gathered .
And because I left the 2 way sync enabled, this work in both ways :
So, in the table Dates, you can select activities for a specific date in the table and see this link being directly reflected in Logs … and vice-versa
The [View of Dates] is just there to show how the Dates table would look like displayed as Details as you did in your screenshot.