How do I maintain a template for a “Value for New Row” canvas column that references items in the parent table? I demonstrate how I can accomplish this in the table below, but this is hacky: I have a broken formula in the page “Template For New Row Embed”.
Thanks, this solves a problem that I have on my to-do list!
But why does it bother you that the formula does not work in the template page? The reason it is not working, is because the formula references thisrow() which does not exist as the formula is on a page. But as soon as the template is copied into the table, it is now in a row, and the formula will work.
This works for me but I am hoping for a less hacky solution. The fact that the formulas are broken means that renaming fields or Coda doc upgrades can break this solution.