Show a certain value for every day of the week, i.e. a summary of the day, or what nice happened the day

Show a meta data value for every day of the week¶

Basic¶

Usage in weekly note

If you want to use this query in your weekly note and your weekly is named like gggg-[W]ww, i.e. 2022-W4, replace fake.name with file.name

LIST summary
FROM "10 Example Data/dailys"
WHERE string(file.day.year) = split(this.fake.name, "-W")[0] AND string(file.day.weekyear) = split(this.fake.name, "-W")[1]
SORT file.name

Alternative usage

Instead of a summary of the day you could note down something nice that happened that day and remind yourself that the week was quite nice in retrospective!

Variants¶

Print weekdays instead of file names¶

LIST WITHOUT ID "**" + dateformat(file.day, "cccc") + "**: " + summary
FROM "10 Example Data/dailys"
WHERE string(file.day.year) = split(this.fake.name, "-W")[0] AND string(file.day.weekyear) = split(this.fake.name, "-W")[1]
SORT file.name

Print weekdays instead of file names but still link to daily¶

LIST WITHOUT ID "**" + link(file.path,  dateformat(file.day, "cccc")) + "**: " + summary
FROM "10 Example Data/dailys"
WHERE string(day.year) = split(this.fake.name, "-W")[0] AND string(day.weekyear) = split(this.fake.name, "-W")[1]
SORT file.name

Print multiple values per day¶

LIST WITHOUT ID "**" + dateformat(file.day, "cccc") + "**: " + join(note, " | ")
FROM "10 Example Data/dailys"
WHERE string(file.day.year) = split(this.fake.name2, "-W")[0] AND string(file.day.weekyear) = split(this.fake.name2, "-W")[1]
SORT file.name

Print multiple values per day as table¶

TABLE WITHOUT ID "**" + dateformat(file.day, "cccc") + "**" AS "Day" , note
FROM "10 Example Data/dailys"
WHERE string(file.day.year) = split(this.fake.name2, "-W")[0] AND string(file.day.weekyear) = split(this.fake.name2, "-W")[1]
SORT file.name

Print multiple values per day as table in unified look¶

TABLE WITHOUT ID "**" + dateformat(file.day, "cccc") + "**" AS "Day" , choice(typeof(note) = "array", note, array(note)) AS "Notes"
FROM "10 Example Data/dailys"
WHERE string(file.day.year) = split(this.fake.name2, "-W")[0] AND string(file.day.weekyear) = split(this.fake.name2, "-W")[1]
SORT file.name