Nesting base view in file/template

Help
1

What I’m trying to do

I’m a newbie, so bear with me.

I’m trying to create a file (more specifically a template file) that has a nested base/view in it. I’m basing my work on the Wanderloots video titled “How To Easily Organize Projects & Tasks With Obsidian Bases”.

It’s mostly working the way I want, but the snag is in adding a nested database view in a file. I filter it where Parent (a property field) is set to this.Name (to inherit the parent of the form the view is embedded within). So, e.g., if I have a Domain of Music, and I want to add a focus area of Musicals, I add a row for Musicals in the NestedFocusAreas view of the Chaos Management.base base.

But it doesn’t work. Instead of evaluating the formula this.Name into the appropriate name (e.g., Musi or [[Music]]), it literally puts the string “this.Name” in the parent field. Thus, this FocusArea record shows up in every Domain I define (Music, Writing, Filmmaking, etc).

And if I manually enter the Parent value of “Music” or “[[Music]]”, the filter doesn’t match, and it doesn’t show up.

I guess I’m confused about when and how to force evaluation of the formula. I want the table to contain the cooked value of hte expression this.Name (e.g., “Music”), rather than the expression itself. And I want the filter condition to correctly match the actual file name.

How do I do this? How do I correctly initialize the Parent property with the actual name of the nesting file, and how do I get the filter to actually match on the filename? What’s the syntactical sugar for each?

I’m sure this will be dead simple once I see the solution, but I’m stuck.

Here is the Music.md file:

---
Tier: Domain
Name:
Parent:
Description:
tags:
  - "#ChaosWrangling"
  - "#Domain"
---

# Music
I am a lifelong musician and music lover. I play several instruments, build virtual synthesizers, have performed and recorded original music for decades. I've written and produced one [[musical]], and am working on another one. 
My interest in music breaks down into several focus areas:


![[Chaos Dashboard.base#NestedFocusAreas]]

![[Chaos Dashboard.base#NestedDomains]]

… and here’s Chaos Dashboard.base:

filters:
  and:
    - "!Tier.isEmpty()"
    - '!file.path.contains("Template")'
formulas:
  Nester: this.file
  Test formula: file.name
  this.name: this.Nameame
properties:
  file.name:
    displayName: Name
  file.mtime:
    displayName: Last Touched
  formula.this.name:
    displayName: this.Name
views:
  - type: table
    name: Chaos Dashboard
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
      - Start
      - Completed
      - file.mtime
    sort:
      - property: file.mtime
        direction: ASC
    columnSize:
      note.Status: 98
  - type: table
    name: Domains
    filters:
      and:
        - Tier == "Domain"
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
      - Start
      - Completed
      - file.mtime
  - type: table
    name: Focus Areas
    filters:
      and:
        - Tier == "FocusArea"
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
      - Start
      - Completed
      - file.mtime
  - type: table
    name: Action Items
    filters:
      and:
        - Tier == "ActionItem"
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
      - Start
      - Completed
      - file.mtime
  - type: table
    name: Problems
    filters:
      and:
        - Tier == "Problem"
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
      - Start
      - Completed
      - file.mtime
    sort:
      - property: file.name
        direction: ASC
  - type: table
    name: NestedDomains
    filters:
      and:
        - Tier == "Domain"
        - Parent == ["this.file"]
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
  - type: table
    name: NestedFocusAreas
    filters:
      and:
        - Tier == "FocusArea"
        - Parent == ["this.file"]
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
      - formula.Nester
      - formula.this.name
    sort:
      - property: formula.Nester
        direction: DESC
  - type: table
    name: NestedActionItems
    filters:
      and:
        - Tier == "ActionItem"
        - Parent == ["this.file"]
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
  - type: table
    name: NestedProblems
    filters:
      and:
        - Tier == "ActionItem"
        - Parent == ["this.file"]
    order:
      - file.name
      - Parent
      - Priority
      - Status
      - Description
  - type: table
    name: Test
    order:
      - file.name
      - formula.Test formula
      - formula.this.name
    sort:
      - property: formula.Test formula
        direction: ASC

Things I have tried

I followed along in the above video, I read the entire help file for bases, and I googled for a possible solution. Then I came here.

Thanks for the help!

2

I am a bit lost in your text.

First, the md file you shared has no value for Name, so nothing can be displayed.

Second, your this.Name formula has a wrong property assigned this.Nameame.

Third, I dont see you using the formula for any filter.

Maybe an explanation what should happen:

this.Name is equal to this.properties.Name which will return the value of the property Name. this. points to different files depending on the context. In a base file, it will point to the base file. As base files cannot have properties, it will not return a value. In a nested base, it will point to the file a base is nested in. Thus, it will return the value of the Name property of this file.

3

So I managed to fix my problem this morning. I realized that Name was just a property I created, and I went back and reviewed the tutorial video.

Turns out what I needed was Parent = this.file.

I knew it would be simple, and I feel pretty silly. But it helped me to post my question.

Thanks for your help!