Hi,
I have a database with around 100 rows and 70 columns. It’s information about events/shows/concerts. One Canvas column is call sheet for the staff, and I’d like to add another Canvas column with tasks dedicated to that specific event.
Is there a way have a master task-database that’s linked in each and every row of the events database where tasks related to every specific event only shows as a template? I can do this quite easily in Notion, but not as obvious in Coda as far as I can tell.
Many thanks!
Martin
That’s easily achievable in Coda, but you have to use a ‘Relation’ column instead of ‘Canvas’ and then ‘Display it as a table’ in the detail view.
There is more nuance about how to set it up exactly, but it depends on what you mean by ‘shows as a template’
1 Like
Hi! Thanks for getting back so quickly! I think I got it, thank you! So there’s no way to show the tasks as a table inside a Canvas column?
How can I make the call sheet Canvas column to populate a template table when I create a new event in the event database?
Thanks again!
It is possible, but it’s suboptimal. You can set it up as a ‘value for new rows’ but it will create a new view for every row, which can end up affecting performance. Additionally this only works for new rows, for existing ones you would have to set up the views yourself.
Is there any reason why you insist on having the subtable in the canvas column instead of just displaying it in the detail view like I described before?
They look exactly the same. Here you have a small example:
I don’t know what you mean here, it would be easier to help you if you shared your doc.
Hi Martin,
As Pablo said, an example would be helpful. There are a number of ways to get similar things done.
I have a table dbThoughts. Each row is of a specific Thought type, and the thought type stores a canvas column template. When you create a new row, it will pull in the specific template, using the New Row formula.
There is a trick though, you need to create the new row using a button. If you do it manually, the New Row triggers immediately, and there is not an entry in the thought type column yet.
Alternatively you can create a row that acts as a template, and then Duplicate that row.
You will need to determine whether you want to create a new table every creation, or a view of a shared table. If the latter, you will need to filter using parentrow().
A completely separate alternative is to have pages rather than canvas columns. You need to have a button to duplicate a template page, and that button does the new page URL as a result. I used this approach before I got the canvas columns working.
There are old examples of both (I think) in my doc evolution of the Todo list in the gallery.
Regards
Piet
You might need to play around a bit