Obsidian Bases

作者 kepano3ccff5338ea7無授權條款49K 個星標收錄於 2026年10月8日更新於 2026年10月8日儲存庫3 週前更新

Create and edit Obsidian Bases (.base files) with views, filters, formulas, and summaries. Use when working with .base files, creating database-like views of notes, or when the user mentions Bases, table views, card views, filters, or formulas in Obsidian.

僅含說明Documents & Office
AI 產生的概覽

建立與編輯 Obsidian Bases（.base）YAML 檔案，支援篩選、公式、彙總以及表格、卡片、清單或地圖檢視。

功能
此技能引導代理撰寫 Obsidian Bases 檔案：包含全域與各檢視篩選、公式屬性、顯示名稱設定、自訂彙總，以及一或多個檢視的有效 YAML。內容說明了篩選運算子、檔案與筆記屬性、公式語法、時長與日期運算、檢視類型與預設彙總公式。也涵蓋在 Markdown 中嵌入 base，以及排查 YAML 引號與公式錯誤。產出是可用的 .base 檔案，而非算繪後的檔案。
適用情境
適用於建立或編輯 .base 檔案、為筆記建立類資料庫檢視，或使用者提到 Obsidian Bases、表格或卡片檢視、篩選或公式時。也適合排查現有 base 中的 YAML 或公式錯誤。
執行需求
無指令碼，僅為說明文件。需要 Obsidian 來建立與測試 .base 檔案，地圖檢視需要 Maps 社群外掛。隨附的參考檔案記錄了完整函式集。

Obsidian Bases Skill

Workflow

  1. Create the file: Create a .base file in the vault with valid YAML content
  2. Define scope: Add filters to select which notes appear (by tag, folder, property, or date)
  3. Add formulas (optional): Define computed properties in the formulas section
  4. Configure views: Add one or more views (table, cards, list, or map) with order specifying which properties to display
  5. Validate: Verify the file is valid YAML with no syntax errors. Check that all referenced properties and formulas exist. Common issues: unquoted strings containing special YAML characters, mismatched quotes in formula expressions, referencing formula.X without defining X in formulas
  6. Test in Obsidian: Open the .base file in Obsidian to confirm the view renders correctly. If it shows a YAML error, check quoting rules below

Schema

Base files use the .base extension and contain valid YAML.

yaml
# Global filters apply to ALL views in the basefilters:  # Can be a single filter string  # OR a recursive filter object with exactly ONE key: and, or, or not  and:    - 'status == "active"'    - not:        - 'file.hasTag("archived")'
# Define formula properties that can be used across all viewsformulas:  formula_name: 'expression'
# Configure display names and settings for propertiesproperties:  property_name:    displayName: "Display Name"  formula.formula_name:    displayName: "Formula Display Name"  file.ext:    displayName: "Extension"
# Define custom summary formulassummaries:  custom_summary_name: 'values.mean().round(3)'
# Define one or more viewsviews:  - type: table | cards | list | map    name: "View Name"    limit: 10                    # Optional: limit results    groupBy:                     # Optional: group results      property: property_name      direction: ASC | DESC    filters:                     # View-specific filters follow the same rules      and:        - 'status == "active"'    order:                       # Properties to display in order      - file.name      - property_name      - formula.formula_name    summaries:                   # Map properties to summary formulas      property_name: Average

Filter Syntax

Filters narrow down results. They can be applied globally or per-view.

Filter Structure

yaml
# Single filterfilters: 'status == "done"'
# AND - all conditions must be truefilters:  and:    - 'status == "done"'    - 'priority > 3'
# OR - any condition can be truefilters:  or:    - 'file.hasTag("book")'    - 'file.hasTag("article")'
# NOT - exclude matching itemsfilters:  not:    - 'file.hasTag("archived")'
# Nested filtersfilters:  or:    - file.hasTag("tag")    - and:        - file.hasTag("book")        - file.hasLink("Textbook")    - not:        - file.hasTag("book")        - file.inFolder("Required Reading")

Filter Operators

OperatorDescription
==equals
!=not equal
>greater than
<less than
>=greater than or equal
<=less than or equal
&&logical and
||logical or
<code>!</code>logical not

Properties

Three Types of Properties

  1. Note properties - From frontmatter: note.author or just author
  2. File properties - File metadata: file.name, file.mtime, etc.
  3. Formula properties - Computed values: formula.my_formula

File Properties Reference

PropertyTypeDescription
file.nameStringFile name
file.basenameStringFile name without extension
file.pathStringFull path to file
file.folderStringParent folder path
file.extStringFile extension
file.sizeNumberFile size in bytes
file.ctimeDateCreated time
file.mtimeDateModified time
file.tagsListAll tags in file
file.linksListInternal links in file
file.backlinksListFiles linking to this file
file.embedsListEmbeds in the note
file.propertiesObjectAll frontmatter properties

The this Keyword

  • In main content area: refers to the base file itself
  • When embedded: refers to the embedding file
  • In sidebar: refers to the active file in main content

Formula Syntax

Formulas compute values from properties. Defined in the formulas section.

yaml
formulas:  # Simple arithmetic  total: "price * quantity"
  # Conditional logic  status_icon: 'if(done, "✅", "⏳")'
  # String formatting  formatted_price: 'if(price, price.toFixed(2) + " dollars")'
  # Date formatting  created: 'file.ctime.format("YYYY-MM-DD")'
  # Calculate days since created (use .days for Duration)  days_old: '(now() - file.ctime).days'
  # Calculate days until due date  days_until_due: 'if(due_date, (date(due_date) - today()).days, "")'

Key Functions

Most commonly used functions. For the complete reference of all types (Date, String, Number, List, File, Link, Object, RegExp), see FUNCTIONS_REFERENCE.md [blocked].

FunctionSignatureDescription
date()date(string): dateParse string to date (YYYY-MM-DD HH:mm:ss)
now()now(): dateCurrent date and time
today()today(): dateCurrent date (time = 00:00:00)
if()if(condition, trueResult, falseResult?)Conditional
duration()duration(string): durationParse duration string
file()file(path): fileGet file object
link()link(path, display?): LinkCreate a link

Duration Type

When subtracting two dates, the result is a Duration type (not a number).

Duration Fields: duration.days, duration.hours, duration.minutes, duration.seconds, duration.milliseconds

IMPORTANT: Duration does NOT support .round(), .floor(), .ceil() directly. Access a numeric field first (like .days), then apply number functions.

yaml
# CORRECT: Calculate days between dates"(date(due_date) - today()).days"                    # Returns number of days"(now() - file.ctime).days"                          # Days since created"(date(due_date) - today()).days.round(0)"           # Rounded days
# WRONG - will cause error:# "((date(due) - today()) / 86400000).round(0)"      # Duration doesn't support division then round

Date Arithmetic

yaml
# Duration units: y/year/years, M/month/months, d/day/days,#                 w/week/weeks, h/hour/hours, m/minute/minutes, s/second/seconds"now() + \"1 day\""       # Tomorrow"today() + \"7d\""        # A week from today"now() - file.ctime"      # Returns Duration"(now() - file.ctime).days"  # Get days as number

View Types

Table View

yaml
views:  - type: table    name: "My Table"    order:      - file.name      - status      - due_date    summaries:      price: Sum      count: Average

Cards View

yaml
views:  - type: cards    name: "Gallery"    order:      - file.name      - cover_image      - description

List View

yaml
views:  - type: list    name: "Simple List"    order:      - file.name      - status

Map View

Requires latitude/longitude properties and the Maps community plugin.

yaml
views:  - type: map    name: "Locations"    # Map-specific settings for lat/lng properties

Default Summary Formulas

NameInput TypeDescription
AverageNumberMathematical mean
MinNumberSmallest number
MaxNumberLargest number
SumNumberSum of all numbers
RangeNumberMax - Min
MedianNumberMathematical median
StddevNumberStandard deviation
EarliestDateEarliest date
LatestDateLatest date
RangeDateLatest - Earliest
CheckedBooleanCount of true values
UncheckedBooleanCount of false values
EmptyAnyCount of empty values
FilledAnyCount of non-empty values
UniqueAnyCount of unique values

Complete Examples

Task Tracker Base

yaml
filters:  and:    - file.hasTag("task")    - 'file.ext == "md"'
formulas:  days_until_due: 'if(due, (date(due) - today()).days, "")'  is_overdue: 'if(due, date(due) < today() && status != "done", false)'  priority_label: 'if(priority == 1, "🔴 High", if(priority == 2, "🟡 Medium", "🟢 Low"))'
properties:  status:    displayName: Status  formula.days_until_due:    displayName: "Days Until Due"  formula.priority_label:    displayName: Priority
views:  - type: table    name: "Active Tasks"    filters:      and:        - 'status != "done"'    order:      - file.name      - status      - formula.priority_label      - due      - formula.days_until_due    groupBy:      property: status      direction: ASC    summaries:      formula.days_until_due: Average
  - type: table    name: "Completed"    filters:      and:        - 'status == "done"'    order:      - file.name      - completed_date

Reading List Base

yaml
filters:  or:    - file.hasTag("book")    - file.hasTag("article")
formulas:  reading_time: 'if(pages, (pages * 2).toString() + " min", "")'  status_icon: 'if(status == "reading", "📖", if(status == "done", "✅", "📚"))'  year_read: 'if(finished_date, date(finished_date).year, "")'
properties:  author:    displayName: Author  formula.status_icon:    displayName: ""  formula.reading_time:    displayName: "Est. Time"
views:  - type: cards    name: "Library"    order:      - cover      - file.name      - author      - formula.status_icon    filters:      not:        - 'status == "dropped"'
  - type: table    name: "Reading List"    filters:      and:        - 'status == "to-read"'    order:      - file.name      - author      - pages      - formula.reading_time

Daily Notes Index

yaml
filters:  and:    - file.inFolder("Daily Notes")    - '/^\d{4}-\d{2}-\d{2}$/.matches(file.basename)'
formulas:  word_estimate: '(file.size / 5).round(0)'  day_of_week: 'date(file.basename).format("dddd")'
properties:  formula.day_of_week:    displayName: "Day"  formula.word_estimate:    displayName: "~Words"
views:  - type: table    name: "Recent Notes"    limit: 30    order:      - file.name      - formula.day_of_week      - formula.word_estimate      - file.mtime

Embedding Bases

Embed in Markdown files:

markdown
![[MyBase.base]]
<!-- Specific view -->![[MyBase.base#View Name]]

YAML Quoting Rules

  • Use single quotes for formulas containing double quotes: 'if(done, "Yes", "No")'
  • Use double quotes for simple strings: "My View Name"
  • Escape nested quotes properly in complex expressions

Troubleshooting

YAML Syntax Errors

Unquoted special characters: Strings containing :, {, }, [, ], ,, &, *, #, ?, |, -, <, >, =, !, %, @, ` must be quoted.

yaml
# WRONG - colon in unquoted stringdisplayName: Status: Active
# CORRECTdisplayName: "Status: Active"

Mismatched quotes in formulas: When a formula contains double quotes, wrap the entire formula in single quotes.

yaml
# WRONG - double quotes inside double quotesformulas:  label: "if(done, "Yes", "No")"
# CORRECT - single quotes wrapping double quotesformulas:  label: 'if(done, "Yes", "No")'

Common Formula Errors

Duration math without field access: Subtracting dates returns a Duration, not a number. Always access .days, .hours, etc.

yaml
# WRONG - Duration is not a number"(now() - file.ctime).round(0)"
# CORRECT - access .days first, then round"(now() - file.ctime).days.round(0)"

Missing null checks: Properties may not exist on all notes. Use if() to guard.

yaml
# WRONG - crashes if due_date is empty"(date(due_date) - today()).days"
# CORRECT - guard with if()'if(due_date, (date(due_date) - today()).days, "")'

Referencing undefined formulas: Ensure every formula.X in order or properties has a matching entry in formulas.

yaml
# This will fail silently if 'total' is not defined in formulasorder:  - formula.total
# Fix: define itformulas:  total: "price * quantity"

References

來源與署名

來源：kepano/obsidian-skills位於skills/obsidian-bases提交3ccff53

授權條款： 無授權條款

內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。

檢舉或申請下架

更多來自 kepano/obsidian-skills 的技能

Obsidian Markdown

kepano

建立與編輯 Obsidian 風格 Markdown 筆記，支援 wikilink、嵌入、標註、屬性、標籤等 Obsidian 語法。

Writing & Content49K3 週前更新

Obsidian Cli

kepano

使用 Obsidian CLI 讀取、建立、搜尋與管理 Obsidian 儲存庫中的筆記、任務和屬性，並開發外掛。

Productivity & Workflow49K3 週前更新

Knap

kepano

使用 Knap CLI 將範本與 JSON 或 CSV 資料算繪成 Markdown 筆記，並支援批次產生。

Documents & Office49K3 週前更新

Json Canvas

kepano

建立與編輯包含節點、邊、群組與連接的 JSON Canvas（.canvas）檔案。

Documents & Office49K3 週前更新

Defuddle

kepano

使用 Defuddle CLI 從網頁擷取乾淨的 Markdown 或中繼資料。

Research & Analysis49K3 週前更新

更多Documents & Office技能

View Pdf

anthropics

精選

在互動式檢視器中開啟 PDF，用於註解、填寫表單和放置視覺化簽名。

Documents & Office27K今天更新

Wiki Ado Convert

microsoft

精選

產生一個 Node.js 指令碼，將 VitePress/GFM markdown 轉換為相容 Azure DevOps Wiki 的 markdown 副本。

Documents & Office2026年10月8日

Pdf

openai

精選

讀取、建立並以視覺方式檢查 PDF 檔案，將頁面算繪成影像，並使用 Python 函式庫進行產生與擷取。

Documents & Office2026年10月8日

Esign Field Placement

affaan-m

以書面工作流程約定，用數值座標在瀏覽器簽署器中放置電子簽章欄位，預設存為草稿並設操作員閘門。

Documents & Office275K3 天前更新

Visa Doc Translate

affaan-m

將簽證申請文件影像翻譯成英文，並產出包含原圖與譯文的雙語 PDF。

Documents & Office275K3 天前更新

Google Workspace Ops

affaan-m

操作 Google Workspace 的文件、試算表、簡報與雲端硬碟資源：尋找、檢查、編輯並清理共用檔案。

Documents & Office275K3 天前更新