With the new update Notion finally did the thing I wanted it to do!!
I can now finally add relations from all my tasks, habits, savings, and expenses, all to that day's journal page automatically. This is exactly what I wanted to be able to do in notion and have been trying to do for over a year.
Now I can just open my journal page for that day in the morning and everything I need to do that day can all be in it and more importantly everything I did or missed that day will stay in it.
Edit: I will explain in more detail when I come back from work this evening. While I am not sure if they did it this update or secretly added before, it is a small tweak with automations "trigger page." That did not exist before when I was attempting to do this last year.
Edit 2: Thanks everyone for commenting and showing interest and sorry for the wait. I was too excited yesterday when I finally figured it out and needed to let it off my system. Here's what I meant in detail. I have attached screenshots as well to help understand.
What I was trying to do is not just be able to see my to-dos in my journal page but also look back and see what tasks I did or missed any particular day.
Before I was doing this by with a button that will relate all the tasks with today's date to that day's journal page. The journal page is automatically created everyday so all I need to do is remember to press the button at the start of the day and everything I need to do will come up in that new page. This is done by setting up the database view in the template by filter [ Journal -> "this page" ] or whatever the name of the template is. Both the button and the table view needs to be inside the journal template for it to work. Though automations and buttons are supposed to be similar they are not. The "this page" or "trigger page" option just did not used to appear in automations no matter what I tried. But now it does now though still not in the way I wanted it to.
First and foremost the automation happens in the Journal database. This is the Automation:
When page is added edit pages in so and so database where date is today. Edit property: Journal - add - trigger page.
This does not need to be in the template and it will run automatically when the daily journal is created. By changing it to "add" instead of "replace" it creates a record of how many times the task was postponed. The Tabbed layout also helps in making things a lot more easier but it is mainly whether or not you get the "trigger page" or "This page" option and after this update it does show in automations. This option still does not show when you set automations to "Every" which is why I have to depend on the template to be automatically created everyday. I still need to end the day with a button to be able to add that day's expenses and savings. I am planning to work around this by setting my journal template to be created at 6 in the evening as by that time I am usually home but still enough time before I retire to bed.
While I don't know when this change was added but at the time of posting this I genuinely believe it was added this update. If you have any questions about it let me know. Also if you have a better way of doing this please do tell. Again sorry for making all of you wait so long.