Bases - View notes created and modified on the day

base-recentNotes.base

filters:
  and:
    - file.ext == "md"
formulas:
  createdDate: created_at
  modifiedDate: modified_at
  finishedDate: done_date
  testFormula: if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD")
  Name: if(title, link(file, title), file)
  Type: |-
    if(
    date(if(formula.createdDate, formula.createdDate, file.ctime)).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD"), "🌱 NEW", 

    if(
    date(if(formula.modifiedDate, formula.modifiedDate, file.mtime)).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD"), "📝 MODIFIED", "OTHERS"

    )
    )

    + if(file.inFolder("WebClip"), " 🗃️ ", "")

    + if(formula.finishedDate, 
    if (
    date(formula.finishedDate).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD"), " ✅ DONE", ""
    ), ""
    )
  statusGroup: |+
    if(
    date(if(formula.createdDate, formula.createdDate, file.ctime)).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD"), "Today Created", 

    if (
    date(formula.finishedDate).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD"), "Today Finished",

    if(
    date(if(formula.modifiedDate, formula.modifiedDate, file.mtime)).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD"), "Today Modified", "OTHERS"

    )
    )
    )

views:
  - type: table
    name: All of Today
    filters:
      and:
        - and:
            - '!file.inFolder("PeriodicNote")'
            - '!file.inFolder("_global")'
        - or:
            - date(if(formula.modifiedDate, formula.modifiedDate, file.mtime)).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD")
            - date(if(formula.createdDate, formula.createdDate, file.ctime)).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD")
            - formula.finishedDate && date(formula.finishedDate).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD")
    groupBy: formula.statusGroup
    order:
      - formula.Name
      - formula.Type
    sort:
      - property: formula.Type
        direction: ASC
    columnSize:
      formula.Name: 361
  - type: table
    name: Recently Finished
    filters:
      and:
        - formula.finishedDate >= today() - "7 day"
    order:
      - file.name
      - formula.finishedDate
    sort:
      - property: formula.finishedDate
        direction: DESC
    columnSize:
      file.name: 663
  - type: table
    name: Recently Modified
    filters:
      and:
        - formula.createdDate >= today() - "7 day" || formula.modifiedDate >= today() - "3 day"
    sort:
      - property: file.name
        direction: ASC
  - type: table
    name: Modified Today
    filters:
      and:
        - date(if(formula.modifiedDate, formula.modifiedDate, file.mtime)).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD")
        - '!file.inFolder("PeriodicNote")'
        - date(if(formula.createdDate, formula.createdDate, file.ctime)).format("YYYYMMDD") != if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD")
    order:
      - formula.Name
    columnSize:
      file.name: 438
  - type: table
    name: Created Today
    filters:
      and:
        - date(if(formula.createdDate, formula.createdDate, file.ctime)).format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD")
        - '!file.inFolder("PeriodicNote")'
    order:
      - formula.Name
      - formula.createdDate
      - formula.modifiedDate
    columnSize:
      formula.Name: 575
      formula.createdDate: 134
  - type: table
    name: Finished Today
    filters:
      and:
        - formula.finishedDate && formula.finishedDate.format("YYYYMMDD") == if(/^\d{4}-\d{2}-\d{2}/.matches(this.file.name), date(this.file.name), today()).format("YYYYMMDD")
        - '!file.inFolder("PeriodicNote")'
    order:
      - formula.Name
    columnSize:
      formula.Name: 701

Moy-bases-as-list-en.css

/* Bases list style and element hiding */
/* Original idea and most code from: https://discord.com/channels/686053708261228577/716028884885307432/1405933574149898402 */
/* Moy made some adjustments */

.workspace-split.mod-sidedock.mod-right-split .workspace-tabs:not(.mod-top) .bases-view,
.bases-ordered-list,
.bases-embed[alt~="ordered-list"] {

    .query-toolbar-item:not(.mod-views) { display: none; }

    /* Hide bottom shadow */
    .bases-tbody { box-shadow: none; }

    .bases-view[data-view-type="table"] {--bases-embed-border-width: 0; overflow-x: hidden;}

    /* Hide title bar */
    .bases-thead {
        display: none;
        /* font-size: 0.8em; */
    }

    /* Bottom spacing (mainly for grouping) */
    .bases-table {
        padding-top: 4px;
        border-bottom: 1px dashed var(--background-secondary);
        padding-bottom: 8px;
    }

    /* Counter serial number function */
    .bases-tr { counter-increment: di-bases-pure-list-counter; }

    /* Table grid */
    .bases-tr, .bases-td { box-shadow: none; }

    /* .bases-table-cell { font-size: var(--font-text-size); } */


    /* Hide underline—only for links in the first column 🤔 */
    .bases-td:first-of-type a { 
        text-decoration: none; 

        &:hover {
            text-decoration: underline;
        }

        /* Line break */
        text-overflow: ellipsis;
        overflow: hidden;
        white-space: nowrap;
    }

    /* Add serial number in front */
    .bases-td:first-of-type .bases-table-cell::before {
        content: counter(di-bases-pure-list-counter) ". ";
        color: var(--list-marker-color);
        padding-right: 1ch;
        padding-left: 1ch;
    }

    .bases-embed {
        .edit-block-button,
        .bases-header {
            display: none !important;
        }
    }

    /* ! Card */
    /* Hide card property name */
    .bases-cards-label {
        display: none;
    }
    .bases-cards-property.mod-title {
        a.internal-link {
            color: var(--text-normal) !important;
            font-weight: normal;
        }

        &:hover {
            text-decoration: underline !important;
        }
    }
}