Setting default column type in canvas

[requira]

Hi,

Just started looking at Coda and trying to get my head around the formulae used to set the default value on a relation column.

Here’s where I’ve got to.

• I’ve connected my Daily Journal table with my Journal Entries table
• I’ve set up the template page to be used in the canvas column which is showing the filtered list of all Journal Entries related to that Daily Journal record (via the Cycle - Daily column)

My issue is that I can’t seem to use the ParentRow function (if that is the right one to be using) so that when I add a new Journal Entry, the Cycle - Daily column is defaulted to the same day of the Daily Journal record. In this case 28/05/2023.

Any help would be most appreciated.

Thanks!

[requira]

As Murphy’s Law would have it, managed to find a workaround using a button to add a row.

I’m guessing that because the button is on the canvas of my Daily Journal record, that I don’t need to worry about using the ParentRow function. Instead, I’ve set the button to set the Cycle - Daily field to the value I need.

However, my next issue is that my formula only sets “28/05/2023” as a text value rather than as one of the available relations.

So, my follow up question is how to have the button set the value so it’s a relation and not just text?

[Pch]

HI @requira and Welcome to the Community !

Would you mind sharing a screenshot or the formula you used in your canvas button ?

[requira]

@Pch : Thanks for your reply. I eventually managed to figure it out and then on how simple the answer was.

What I was doing wrong was pulling in the value of the primary column on Daily Journal record rather than the actual record itself.

So, had the random thought of just setting the value to thisRow and nothing else and that’s working as I wanted.

HTH

[Pch]

As someone who tends to overcomplicate things, I can tell you that this kind of things just happens !

Congrats for figuring it out !

Don’t hesitate if you have any other questions or encounter some issues !