I’ve seen a lot of people trying to reference the parent row inside of a templated canvas, but I’ve only seen one question in reverse which offered an alternative solution that doesn’t necessarily work for my use case. I’m looking to reference a table that exists within a canvas column in the parent table.
I am working on a document to track a TTRPG I’m running. I’ve created an XP Ledger template table, which gets added as the default value for new rows in a canvas column in the Characters table, which creates a copy of the template table per row.
I’d love to be able to reference the table that’s inside this canvas from the parent table so I can display current & accumulated XP, as well as then also being able to reference it from the Skills canvas table using something likeparentRow.[XP Ledger].
The only other suggestion I saw from the community would be to instead make the table you’re trying to reference a single table and have the canvas just filter for that particular parent row. But my use case relies on the previous row to calculate the balance after each purchase and other calculations that will happen elsewhere in the document would be made more complicated if I unify these tables.
Do I have any options here?
Here’s a demo.