- File name must be in
kkkk-'W'WW
format, for example 2022-W08
- Uncomment last line
dv.paragraph(mdv);
if you like to see the result inside a collapse ad-note
- You could copy the table and delete the dataview to maintain the work today table, and the links inside the table will update, but the table will remain for future review.
- To exclude a folder modifly
dailynotes
in:
let pages = dv.pages('-"dailynotes"')
// define function to create tabe
function create_mdtable(HeadRow_dv, TableFormat, Rows_dv){
let last_row = ""
let table = `| ${HeadRow_dv.map(cell => cell + " |").join("")}\n`;
table += TableFormat
for (let Row of Rows_dv) {
if (Row[0] != last_row) {
table += `| ${Row[0]} | [[${Row[1]}]] | \n`;
}
last_row = Row[0];
};
return table
}
const format = 'HH:mm:ss';
const week = "kkkk-'W'WW"
// Create table
const HeadRow = [ "Time", "Link"];
const TableFormat = "|:---:|:---|\n"
let day_md_table= "";
// Construct dataview group
let dv_week_group = dv.pages('-"dailynotes"')
.where(p => p.file.mtime.toFormat(week) == dv.current().file.name)
.sort(k => k.file.mtime)
.groupBy(p => p.file.mday);
for (let dv_day of dv_week_group) {
// construct table dataview
let ModTableRows = dv_day.rows
.map(p => [p.file.mtime.toFormat(format), p.file.name]);
// create md table
day_md_table += `
#### [[${dv_day.key.toISODate()} | ${dv_day.key.toFormat('DDDD')}]]
${create_mdtable(HeadRow, TableFormat, ModTableRows)}`;
};
// Visualization table
let mdv = `
\`\`\`\`ad-summary
title: Worked This Week
collapse: close
${day_md_table}
\`\`\`\`
`;
// Copy table
let md = `### Worked This Week
\> [!Summary]- Worked This Week`;
for (let line of day_md_table.split(/\r\n|\r|\n/) ){
md += `\n\> ${line}`
}
md += `\n`
// copy button
const copyToClipboard = str => {
const el = document.createElement('textarea');
el.value = str;
document.body.appendChild(el);
el.select();
document.execCommand('copy');
document.body.removeChild(el);
};
const copyButtonMaker = () => {
const btn = this.container.createEl('button', { "text": "Copy" });
btn.addEventListener('click', async (evt) => {
evt.preventDefault();
copyToClipboard(md);
});
return btn;
}
dv.paragraph(copyButtonMaker());
// Display preview
dv.paragraph(mdv)