I’m looking to build a relational frontmatter/property system in Obsidian.
The goal is to have dependent metadata fields where selecting a value from one dropdown automatically populates related fields from a centralized dataset.
Example:
Selecting:
state: AK
would automatically populate:
state_name: Alaska
region_us: West - Pacific
country: US
The system should function similarly to dependent picklists / relational database lookups, using a centralized source of truth (Markdown table, JSON, YAML, CSV, linked notes, etc.).
The primary objective is to eliminate repetitive manual metadata entry and maintain standardized structured data across notes.