Canvas Template - formula to reference thisrow

[Danny_Pettiona]

Hey all,

I’ve created a canvas template.

It contains formulas - I want these formulas to reference ‘thisrow’.

Is there a way to do this in the template?

For example,

Start references the start time for this task.
End references start time for this task + duration.

[Christiaan_Huizer]

Last Saturday I would have responded that you can filter the view of a table living in the canvas column by something like :

thisRow.Contains(parentRow)

and I would have added a screenshot to support the functioning. However in my timezone it is Monday morning and this logic is gone.

anybody?

[Christiaan_Huizer]

well the thing is that it works, but not as expected

I created the filter and saw this first:

then I pressed the enter button and so I got the first row which gave me this:

the mentioned formula works, but it may not show an immediate result. Maybe the parentRow is a bit slower than the thisTable or thisRow references we are used to. I would love to read some @Coda1 feedback in this regard,

Cheers, Christiaan

[Lena_Webster]

Hey @Danny_Pettiona, thanks for posting this question here.

It doesn’t look like this is possible when you create the template in a “true” page. But if you create the template in a canvas column page, you should be able to include formulas that include “thisRow.” And you can then reference this canvas column template in the “value for new rows” field of your canvas column settings.

Let me know if you have questions or run into issues with that!

[Danny_Pettiona]

Thanks for the update Lena and Christian for your help!