Skip to content

Instantly share code, notes, and snippets.

@davidnunez

davidnunez/on_this_day.base

Last active September 10, 2025 16:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save davidnunez/8bbe746dd42d7306fef7c96f81edd86f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save davidnunez/8bbe746dd42d7306fef7c96f81edd86f to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. davidnunez revised this gist Sep 10, 2025. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions on_this_day.base
    View file
    Original file line number Diff line number Diff line change
    @@ -13,6 +13,7 @@ formulas:
    file_date_year: formula.file_date.year
    on_this_day_now: (now().month == date(formula.file_date).month) && (now().day == date(formula.file_date).day)
    on_this_day_file_date: (formula.file_date.month == formula.this_date.month) && (formula.file_date.day == formula.this_date.day)
    rating_stars: [icon("star"), icon("star"), icon("star"), icon("star"), icon("star")].filter(index < rating)
    properties:
    formula.file_date_year:
    displayName: Year
  2. davidnunez revised this gist Sep 10, 2025. 1 changed file with 55 additions and 13 deletions.
    68 changes: 55 additions & 13 deletions on_this_day.base
    View file
    Original file line number Diff line number Diff line change
    @@ -1,25 +1,67 @@
    filters:
    and:
    - '!file.path.contains("Templates")'
    - formula.on_this_day
    - '!file.folder.startsWith("x/Visuals")'
    formulas:
    title_day: file.name.replace(/^(?:.*?(\b\d{4}-\d{2}-\d{2}\b).*|.*)$/, "$1")
    file_date: if(formula.title_day, date(formula.title_day).format("YYYY-MM-DD"), if(created, date(created).format("YYYY-MM-DD"),date(file.ctime).format("YYYY-MM-DD")))
    file_year: date(formula.file_date).year
    file_month: date(formula.file_date).month
    file_day: date(formula.file_date).day
    on_this_day: (now().month == formula.file_month) && (now().day == formula.file_day) && (now().year != formula.file_year)
    this_ctime: this.file.ctime
    file_ctime: file.ctime
    this_date_string: this.file.name.replace(/^(?:.*?(\b\d{4}-\d{2}-\d{2}\b).*|.*)$/, "$1")
    file_date_string: file.name.replace(/^(?:.*?(\b\d{4}-\d{2}-\d{2}\b).*|.*)$/, "$1")
    this_date: if(formula.this_date_string, date(formula.this_date_string), if(this.created, date(this.created),date(this.file.ctime)))
    file_date: if(formula.file_date_string, date(formula.file_date_string), if(created, date(created),date(file.ctime)))
    file_explicit_date: formula.file_date_string + " " + created
    file_date_year: formula.file_date.year
    on_this_day_now: (now().month == date(formula.file_date).month) && (now().day == date(formula.file_date).day)
    on_this_day_file_date: (formula.file_date.month == formula.this_date.month) && (formula.file_date.day == formula.this_date.day)
    properties:
    formula.file_date_year:
    displayName: Year
    views:
    - type: table
    name: Table
    name: On This Day
    filters:
    and:
    - formula.on_this_day_file_date == true
    order:
    - formula.on_this_day
    - formula.file_date_year
    - collection
    - file.name
    - formula.file_date
    - file.mtime
    - status
    sort:
    - property: formula.on_this_day
    - property: formula.on_this_day_file_date
    direction: DESC
    - property: formula.file_date
    direction: ASC
    - property: formula.file_day
    direction: DESC
    - type: table
    name: Files (Last Week)
    filters:
    and:
    - formula.file_date >= today() - "7d"
    order:
    - formula.file_date
    - status
    - file.folder
    - file.name
    - file.size
    sort:
    - property: formula.file_date
    direction: DESC
    - property: file.size
    direction: ASC
    columnSize:
    formula.file_date: 287
    note.created: 227
    note.status: 111
    - type: table
    name: +
    filters:
    and:
    - file.folder == "+"
    order:
    - status
    - file.name
    - file.size
    sort:
    - property: file.size
    direction: ASC
  3. davidnunez created this gist Aug 19, 2025.
    25 changes: 25 additions & 0 deletions on_this_day.base
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,25 @@
    filters:
    and:
    - '!file.path.contains("Templates")'
    - formula.on_this_day
    formulas:
    title_day: file.name.replace(/^(?:.*?(\b\d{4}-\d{2}-\d{2}\b).*|.*)$/, "$1")
    file_date: if(formula.title_day, date(formula.title_day).format("YYYY-MM-DD"), if(created, date(created).format("YYYY-MM-DD"),date(file.ctime).format("YYYY-MM-DD")))
    file_year: date(formula.file_date).year
    file_month: date(formula.file_date).month
    file_day: date(formula.file_date).day
    on_this_day: (now().month == formula.file_month) && (now().day == formula.file_day) && (now().year != formula.file_year)
    views:
    - type: table
    name: Table
    order:
    - formula.on_this_day
    - file.name
    - formula.file_date
    sort:
    - property: formula.on_this_day
    direction: DESC
    - property: formula.file_date
    direction: ASC
    - property: formula.file_day
    direction: DESC