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.
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?