Table inside of a canvas to refer to the row where the canvas lives


I’m playing around with the canvas a bit and I trying to do the following:

  1. Table A has a canvas column, and another column X
  2. Inside of the canvas, there is a table B

Now inside of Table B, is there anyways to refer to the row in table A where this specific instance of table B lives, and be able to refer to thisRow.column X?

I created a named formula in the canvas that pointed to the parent row’s column and then referenced it from the table. This is because thisRow in the table refers to the canvas table and not the parent table. parentRow did not work in this scenario.

If you set things up this way, you can also keep around a templated canvas like in the following example. It’s a hack and it is not pretty but it works:


ah, a nice hack though, Basically turning parent row parameters into text.

1 Like

i love it !
very clever

1 Like