obsidian-bases Checked

Nested filters

filters:

or:

• file.hasTag("tag")
• and:
• file.hasTag("book")
• file.hasLink("Textbook")
• not:
• file.hasTag("book")
• file.inFolder("Required Reading")

### Filter Operators

| Operator | Description |
|----------|-------------|
| `==` | 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

| Property | Type | Description |
|----------|------|-------------|
| `file.name` | String | File name |
| `file.basename` | String | File name without extension |
| `file.path` | String | Full path to file |
| `file.folder` | String | Parent folder path |
| `file.ext` | String | File extension |
| `file.size` | Number | File size in bytes |
| `file.ctime` | Date | Created time |
| `file.mtime` | Date | Modified time |
| `file.tags` | List | All tags in file |
| `file.links` | List | Internal links in file |
| `file.backlinks` | List | Files linking to this file |
| `file.embeds` | List | Embeds in the note |
| `file.properties` | Object | All 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.

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](references/FUNCTIONS_REFERENCE.md).

| Function | Signature | Description |
|----------|-----------|-------------|
| `date()` | `date(string): date` | Parse string to date (`YYYY-MM-DD HH:mm:ss`) |
| `now()` | `now(): date` | Current date and time |
| `today()` | `today(): date` | Current date (time = 00:00:00) |
| `if()` | `if(condition, trueResult, falseResult?)` | Conditional |
| `duration()` | `duration(string): duration` | Parse duration string |
| `file()` | `file(path): file` | Get file object |
| `link()` | `link(path, display?): Link` | Create 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.

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

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

views:

• type: table

name: "My Table"

order:

• file.name
• status
• due_date

summaries:

price: Sum

count: Average

### Cards View

views:

• type: cards

name: "Gallery"

order:

• file.name
• cover_image
• description

### List View

views:

• type: list

name: "Simple List"

order:

• file.name
• status

### Map View

Requires latitude/longitude properties and the Maps community plugin.

views:

• type: map

name: "Locations"

Map-specific settings for lat/lng properties

## Default Summary Formulas

| Name | Input Type | Description |
|------|------------|-------------|
| `Average` | Number | Mathematical mean |
| `Min` | Number | Smallest number |
| `Max` | Number | Largest number |
| `Sum` | Number | Sum of all numbers |
| `Range` | Number | Max - Min |
| `Median` | Number | Mathematical median |
| `Stddev` | Number | Standard deviation |
| `Earliest` | Date | Earliest date |
| `Latest` | Date | Latest date |
| `Range` | Date | Latest - Earliest |
| `Checked` |