Hi everyone, I'm a fairly "seasoned" Notion user and I use databases on a daily basis.
I've had this problem for a while and I hoped that automations would resolve the issue, but no luck so far.
What I want to do is: every time I create a new lecture page, I want to have as a content block a linked DB view for the tasks related to the lecture.
- I have 4 databases involved in this: Courses, Lectures, Tasks and Projects. The relations are implemented like this: Tasks <-> Lectures <-> Courses <-> Projects <-> Tasks (it's a loop)
- I have a Lecture template where I already have a linked view of the Tasks. It's already filtered by the lecture and I manually have to add the project filter, but I want to do it automatically. The project to use has the same name as the course.
If something's missing, don't hesitate to ask!