← ObsidianCONTENT HISTORY
WHAT CHANGED
Update to Obsidian
Snapshot Nov 18, 2026 · 06:20 UTC · version 1.2.0
Collection source: downloaded plugin package.
First saved snapshot
No earlier snapshot is available to establish a change.
Save Obsidian and check future changes in Following.
Up to 3 plugins free · no card required.
Compare saved observations
Download comparison JSONFull technical diff · 0 changed fields
Full snapshot data
{
"description": "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, kanban boards, filters, or formulas in Obsidian.",
"included_files": [
{
"relative_path": "references/FUNCTIONS_REFERENCE.md",
"size_in_bytes": 7538
}
],
"name": "obsidian-bases",
"skill_md_contents": "---\nname: obsidian-bases\ndescription: 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, kanban boards, filters, or formulas in Obsidian.\n---\n\n# Obsidian Bases Skill\n\n## Workflow\n\n1. **Create the file**: Create a `.base` file in the vault with valid YAML content\n2. **Define scope**: Add `filters` to select which notes appear (by tag, folder, property, or date)\n3. **Add formulas** (optional): Define computed properties in the `formulas` section\n4. **Configure views**: Add one or more views (`table`, `cards`, `list`, `map`, or `kanban`) with `order` specifying which properties to display\n5. **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`\n6. **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. If it doesn't open as a base at all, check that Bases is turned on in Settings → Core plugins\n\n## Schema\n\nBase files use the `.base` extension and contain valid YAML.\n\n```yaml\n# Global filters apply to ALL views in the base\nfilters:\n # Can be a single filter string\n # OR a recursive filter object with exactly ONE key: and, or, or not\n and:\n - 'status == \"active\"'\n - not:\n - 'file.hasTag(\"archived\")'\n\n# Define formula properties that can be used across all views\nformulas:\n formula_name: 'expression'\n\n# Configure display names and settings for properties.\n# Note properties need the `note.` prefix here, or the setting is ignored.\nproperties:\n note.property_name:\n displayName: \"Display Name\"\n formula.formula_name:\n displayName: \"Formula Display Name\"\n file.ext:\n displayName: \"Extension\"\n\n# Define custom summary formulas\nsummaries:\n custom_summary_name: 'values.mean().round(3)'\n\n# Define one or more views\nviews:\n - type: table | cards | list | map | kanban\n name: \"View Name\"\n limit: 10 # Optional: limit results\n groupBy: # Optional: group results\n property: property_name\n direction: ASC | DESC\n groupOrder: # Optional: only these groups, in this order\n - value_one\n - null # Files with no value for the groupBy property\n sort: # Optional: sort results (supports multiple properties)\n - property: property_name\n direction: ASC | DESC\n filters: # View-specific filters follow the same rules\n and:\n - 'status == \"active\"'\n order: # Properties to display in order\n - file.name\n - property_name\n - formula.formula_name\n summaries: # Map properties to summary formulas\n property_name: Average\n```\n\n## Filter Syntax\n\nFilters narrow down results. They can be applied globally or per-view.\n\n### Filter Structure\n\n```yaml\n# Single filter\nfilters: 'status == \"done\"'\n\n# AND - all conditions must be true\nfilters:\n and:\n - 'status == \"done\"'\n - 'priority > 3'\n\n# OR - any condition can be true\nfilters:\n or:\n - 'file.hasTag(\"book\")'\n - 'file.hasTag(\"article\")'\n\n# NOT - exclude matching items\nfilters:\n not:\n - 'file.hasTag(\"archived\")'\n\n# Nested filters\nfilters:\n or:\n - file.hasTag(\"tag\")\n - and:\n - file.hasTag(\"book\")\n - file.hasLink(\"Textbook\")\n - not:\n - file.hasTag(\"book\")\n - file.inFolder(\"Required Reading\")\n```\n\n### Filter Operators\n\n| Operator | Description |\n|----------|-------------|\n| `==` | equals |\n| `!=` | not equal |\n| `>` | greater than |\n| `<` | less than |\n| `>=` | greater than or equal |\n| `<=` | less than or equal |\n| `&&` | logical and |\n| `\\|\\|` | logical or |\n| <code>!</code> | logical not |\n\n## Properties\n\n### Three Types of Properties\n\n1. **Note properties** - From frontmatter: `note.author` or just `author`\n2. **File properties** - File metadata: `file.name`, `file.mtime`, etc.\n3. **Formula properties** - Computed values: `formula.my_formula`\n\nIn `order`, `filters`, `groupBy`, and `sort`, a note property can be written bare (`author`) or prefixed (`note.author`). In the top-level `properties:` section, always write `note.author`, because Obsidian ignores a bare key there and shows the raw name as the column header.\n\n### File Properties Reference\n\n| Property | Type | Description |\n|----------|------|-------------|\n| `file.name` | String | File name |\n| `file.basename` | String | File name without extension |\n| `file.path` | String | Full path to file |\n| `file.folder` | String | Parent folder path |\n| `file.ext` | String | File extension |\n| `file.size` | Number | File size in bytes |\n| `file.ctime` | Date | Created time |\n| `file.mtime` | Date | Modified time |\n| `file.tags` | List | All tags in file |\n| `file.links` | List | Internal links in file |\n| `file.backlinks` | List | Files linking to this file. Slow in large vaults and doesn't refresh when the vault changes; prefer reversing the lookup with `file.links` |\n| `file.embeds` | List | Embeds in the note |\n| `file.properties` | Object | All frontmatter properties. Doesn't refresh when the vault changes |\n| `file.file` | File | File object, only usable in specific functions |\n\n### The `this` Keyword\n\n- In main content area: refers to the base file itself\n- When embedded: refers to the embedding file\n- In sidebar: refers to the active file in main content\n\n## Formula Syntax\n\nFormulas compute values from properties. Defined in the `formulas` section.\n\n```yaml\nformulas:\n # Simple arithmetic\n total: \"price * quantity\"\n\n # Conditional logic\n status_icon: 'if(done, \"✅\", \"⏳\")'\n\n # String formatting\n formatted_price: 'if(price, price.toFixed(2) + \" dollars\")'\n\n # Date formatting\n created: 'file.ctime.format(\"YYYY-MM-DD\")'\n\n # Calculate days since created (use .days for Duration)\n days_old: '(now() - file.ctime).days'\n\n # Calculate days until due date\n days_until_due: 'if(due_date, (date(due_date) - today()).days, \"\")'\n```\n\n## Key Functions\n\nMost commonly used functions. For the complete reference of all types (Date, String, Number, List, File, Link, Object, RegExp), see [FUNCTIONS_REFERENCE.md](references/FUNCTIONS_REFERENCE.md).\n\n| Function | Signature | Description |\n|----------|-----------|-------------|\n| `date()` | `date(string): date` | Parse string to date (`YYYY-MM-DD HH:mm:ss`) |\n| `now()` | `now(): date` | Current date and time |\n| `today()` | `today(): date` | Current date (time = 00:00:00) |\n| `if()` | `if(condition, trueResult, falseResult?)` | Conditional |\n| `duration()` | `duration(string): duration` | Parse duration string |\n| `file()` | `file(path): file` | Get file object |\n| `link()` | `link(path, display?): Link` | Create a link |\n\n### Duration Type\n\nWhen subtracting two dates, the result is a **Duration** type (not a number).\n\n**Duration Fields:** `duration.days`, `duration.hours`, `duration.minutes`, `duration.seconds`, `duration.milliseconds`\n\n**IMPORTANT:** Duration does NOT support `.round()`, `.floor()`, `.ceil()` directly. Access a numeric field first (like `.days`), then apply number functions.\n\n```yaml\n# CORRECT: Calculate days between dates\n\"(date(due_date) - today()).days\" # Returns number of days\n\"(now() - file.ctime).days\" # Days since created\n\"(date(due_date) - today()).days.round(0)\" # Rounded days\n\n# WRONG - will cause error:\n# \"((date(due) - today()) / 86400000).round(0)\" # Duration doesn't support division then round\n```\n\n### Date Arithmetic\n\n```yaml\n# Duration units: y/year/years, M/month/months, d/day/days,\n# w/week/weeks, h/hour/hours, m/minute/minutes, s/second/seconds\n\"now() + \\\"1 day\\\"\" # Tomorrow\n\"today() + \\\"7d\\\"\" # A week from today\n\"now() - file.ctime\" # Returns Duration\n\"(now() - file.ctime).days\" # Get days as number\n```\n\n## View Types\n\n### Table View\n\n```yaml\nviews:\n - type: table\n name: \"My Table\"\n order:\n - file.name\n - status\n - due_date\n summaries:\n price: Sum\n count: Average\n```\n\n### Cards View\n\n```yaml\nviews:\n - type: cards\n name: \"Gallery\"\n order:\n - file.name\n - cover_image\n - description\n```\n\n### List View\n\n```yaml\nviews:\n - type: list\n name: \"Simple List\"\n order:\n - file.name\n - status\n```\n\n### Kanban View\n\nRequires Obsidian 1.14+. Cards are grouped into columns by the `groupBy` property, which a kanban view needs. `groupOrder` sets which columns show and in what order; use `null` to include files with no value. Without `groupOrder`, every value gets a column. Dragging a card to another column updates that property in the note. Only Markdown notes can be moved, except when grouping by `file.folder`, where moving a card moves the file to that folder. When grouping by a formula or by a file property other than `file.folder`, cards and columns can't be moved and notes can't be created from a column.\n\n```yaml\nviews:\n - type: kanban\n name: \"Projects\"\n groupBy:\n property: note.status\n direction: ASC\n groupOrder:\n - Planned\n - In progress\n - Done\n order:\n - file.name\n - due_date\n```\n\n### Map View\n\nRequires latitude/longitude properties and the Maps community plugin.\n\n```yaml\nviews:\n - type: map\n name: \"Locations\"\n # Map-specific settings for lat/lng properties\n```\n\n## Sorting\n\nSort results by one or more properties. Each sort entry specifies a `property` and `direction`, which must be uppercase `ASC` or `DESC`; an entry with any other value, or a sort written as a string, is silently ignored. Multiple sort entries are applied in order — the first entry is the primary sort key, subsequent entries break ties.\n\n```yaml\nviews:\n - type: table\n name: \"Sorted Tasks\"\n sort:\n - property: due\n direction: ASC\n - property: file.name\n direction: ASC\n order:\n - file.name\n - due\n - status\n```\n\nSort options depend on the property type:\n\n| Property Type | ASC | DESC |\n|---------------|-----|------|\n| Text | A→Z | Z→A |\n| Number | 0→9 | 9→0 |\n| Date | Old→New | New→Old |\n\nYou can sort by any property including formulas (`formula.my_formula`), file properties (`file.mtime`), and note properties.\n\n## Default Summary Formulas\n\n| Name | Input Type | Description |\n|------|------------|-------------|\n| `Average` | Number | Mathematical mean |\n| `Min` | Number | Smallest number |\n| `Max` | Number | Largest number |\n| `Sum` | Number | Sum of all numbers |\n| `Range` | Number | Max - Min |\n| `Median` | Number | Mathematical median |\n| `Stddev` | Number | Standard deviation |\n| `Earliest` | Date | Earliest date |\n| `Latest` | Date | Latest date |\n| `Range` | Date | Latest - Earliest |\n| `Checked` | Boolean | Count of true values |\n| `Unchecked` | Boolean | Count of false values |\n| `Empty` | Any | Count of empty values |\n| `Filled` | Any | Count of non-empty values |\n| `Unique` | Any | Count of unique values |\n\n## Complete Examples\n\n### Task Tracker Base\n\n```yaml\nfilters:\n and:\n - file.hasTag(\"task\")\n - 'file.ext == \"md\"'\n\nformulas:\n days_until_due: 'if(due, (date(due) - today()).days, \"\")'\n is_overdue: 'if(due, date(due) < today() && status != \"done\", false)'\n priority_label: 'if(priority == 1, \"🔴 High\", if(priority == 2, \"🟡 Medium\", \"🟢 Low\"))'\n\nproperties:\n note.status:\n displayName: Status\n formula.days_until_due:\n displayName: \"Days Until Due\"\n formula.priority_label:\n displayName: Priority\n\nviews:\n - type: table\n name: \"Active Tasks\"\n filters:\n and:\n - 'status != \"done\"'\n order:\n - file.name\n - status\n - formula.priority_label\n - due\n - formula.days_until_due\n groupBy:\n property: status\n direction: ASC\n sort:\n - property: due\n direction: ASC\n - property: file.name\n direction: ASC\n summaries:\n formula.days_until_due: Average\n\n - type: table\n name: \"Completed\"\n filters:\n and:\n - 'status == \"done\"'\n order:\n - file.name\n - completed_date\n```\n\n### Reading List Base\n\n```yaml\nfilters:\n or:\n - file.hasTag(\"book\")\n - file.hasTag(\"article\")\n\nformulas:\n reading_time: 'if(pages, (pages * 2).toString() + \" min\", \"\")'\n status_icon: 'if(status == \"reading\", \"📖\", if(status == \"done\", \"✅\", \"📚\"))'\n year_read: 'if(finished_date, date(finished_date).year, \"\")'\n\nproperties:\n note.author:\n displayName: Author\n formula.status_icon:\n displayName: \"Status\"\n formula.reading_time:\n displayName: \"Est. Time\"\n\nviews:\n - type: cards\n name: \"Library\"\n order:\n - cover\n - file.name\n - author\n - formula.status_icon\n filters:\n not:\n - 'status == \"dropped\"'\n\n - type: table\n name: \"Reading List\"\n filters:\n and:\n - 'status == \"to-read\"'\n order:\n - file.name\n - author\n - pages\n - formula.reading_time\n```\n\n### Daily Notes Index\n\n```yaml\nfilters:\n and:\n - file.inFolder(\"Daily Notes\")\n - '/^\\d{4}-\\d{2}-\\d{2}$/.matches(file.basename)'\n\nformulas:\n word_estimate: '(file.size / 5).round(0)'\n day_of_week: 'date(file.basename).format(\"dddd\")'\n\nproperties:\n formula.day_of_week:\n displayName: \"Day\"\n formula.word_estimate:\n displayName: \"~Words\"\n\nviews:\n - type: table\n name: \"Recent Notes\"\n limit: 30\n order:\n - file.name\n - formula.day_of_week\n - formula.word_estimate\n - file.mtime\n```\n\n## Embedding Bases\n\n### Embed a `.base` file\n\nEmbed an external `.base` file in any Markdown note:\n\n```markdown\n![[MyBase.base]]\n\n<!-- Specific view -->\n![[MyBase.base#View Name]]\n```\n\n### Embed inline with a code block\n\nBases can also be embedded **inline** directly inside a note using a `base` fenced code block. This is useful for note-level filters (e.g. using `this.file.links`) and avoids creating a separate `.base` file:\n\n````markdown\n```base\nfilters:\n and:\n - file.hasTag(\"example\")\nviews:\n - type: table\n name: Table\n order:\n - file.name\n - status\n```\n````\n\nWhen embedded inline this way, the `this` keyword refers to the containing note, so you can build per-note views such as showing all notes linked from the current file.\n\n## YAML Quoting Rules\n\n- Use single quotes for formulas containing double quotes: `'if(done, \"Yes\", \"No\")'`\n- Use double quotes for simple strings: `\"My View Name\"`\n- Escape nested quotes properly in complex expressions\n\n## Troubleshooting\n\n### YAML Syntax Errors\n\n**Unquoted special characters**: Strings containing `:`, `{`, `}`, `[`, `]`, `,`, `&`, `*`, `#`, `?`, `|`, `-`, `<`, `>`, `=`, `%`, `@`, `` ` ``, `!` must be quoted.\n\n```yaml\n# WRONG - colon in unquoted string\ndisplayName: Status: Active\n\n# CORRECT\ndisplayName: \"Status: Active\"\n```\n\n**Mismatched quotes in formulas**: When a formula contains double quotes, wrap the entire formula in single quotes.\n\n```yaml\n# WRONG - double quotes inside double quotes\nformulas:\n label: \"if(done, \"Yes\", \"No\")\"\n\n# CORRECT - single quotes wrapping double quotes\nformulas:\n label: 'if(done, \"Yes\", \"No\")'\n```\n\n### Common Formula Errors\n\n**Duration math without field access**: Subtracting dates returns a Duration, not a number. Always access `.days`, `.hours`, etc.\n\n```yaml\n# WRONG - Duration is not a number\n\"(now() - file.ctime).round(0)\"\n\n# CORRECT - access .days first, then round\n\"(now() - file.ctime).days.round(0)\"\n```\n\n**Missing null checks**: Properties may not exist on all notes. Use `if()` to guard.\n\n```yaml\n# WRONG - crashes if due_date is empty\n\"(date(due_date) - today()).days\"\n\n# CORRECT - guard with if()\n'if(due_date, (date(due_date) - today()).days, \"\")'\n```\n\n**`displayName` ignored, column shows the raw name**: prefix note properties with `note.` in the `properties:` section.\n\n```yaml\n# WRONG - displayName ignored, column header shows \"status\"\nproperties:\n status:\n displayName: Status\n\n# CORRECT - column header shows \"Status\"\nproperties:\n note.status:\n displayName: Status\n```\n\n**Empty `displayName` doesn't hide a header**: `displayName: \"\"` falls back to the property name, the same as leaving it out, so `formula.status_icon` shows `status_icon`. Use a non-empty name such as `displayName: \"Status\"`.\n\n**Referencing undefined formulas**: Ensure every `formula.X` in `order` or `properties` has a matching entry in `formulas`.\n\n```yaml\n# This will fail silently if 'total' is not defined in formulas\norder:\n - formula.total\n\n# Fix: define it\nformulas:\n total: \"price * quantity\"\n```\n\n## References\n\n- [Bases Syntax](https://help.obsidian.md/bases/syntax)\n- [Functions](https://help.obsidian.md/bases/functions)\n- [Views](https://help.obsidian.md/bases/views)\n- [Formulas](https://help.obsidian.md/formulas)\n- [Complete Functions Reference](references/FUNCTIONS_REFERENCE.md)\n"
}SHA-256 of public snapshot: d9002ea351536d7e291c5ba70bb21a9d07fd7b26ecf86e89f8673c64d7fea23b