I am playing around with Canvas columns at the moment, and have been able to do some really nice things with that.
I am trying to influence the template that a canvas column uses when it is initialised.
For example I have a project table, with different project types. If the new row in the project table is for a research project, it should pull in the page “Research Project” and if the new project is a software project, it should bring in the “Software Project” template from the relevant page.
Any idea how to do?
I could create two tables, but then I need to create a new table and related settings every time that I create a new project. A single project table feels more elegant. Or polymorphic for the nerds…
This was my hack to enable templated canvases. I can do it, but it is not pretty. I eventually opted to avoid canvases and instead use lookups which can be expanded into full tables or cards in the Layout.
But I do not want to create a formula that refers to the row of which the canvas cell is a member.
I want to use different template pages for different rows. So, if I enter a row for a project on software, I want the software project template in the canvas column. If I enter a row for a new research project, I want to the research project template in the canvas column.
The only formula I could get that looks like it would help, is the DuplicatePage() formula. Unfortunately thought, the destination for the new page has to be another page, it cannot be a canvas column.
I have worked around that by having a button on the row, that will create a template page in a parent page, and saving the link in the row. I would have liked the page to be created in a canvas column. but this works as well. (Actually, this is what I did before Canvas columns were made available.)