Skip to content
Let’s consider a first database db1 with Task and due_date > This is your classical task table.Then, you will need to create a second database db2 - Full Daily Calendar with 365 lines, with the dates from 1st January to 31th December. You can do it manually, but preferably using and formulas 😉 (Would probably write an article about that, but you can find easy examples in the )
Then, in daily database db2, add a column with the following :
One week, with a single view
Like any other animals in the jungle, Timon and Pumba do have very busy years, months and also weeks. Then, on Monday morning, that would be great to see their tasks for the current week quickly, with something like this :
Week view, easily !
Additional tips : I suggest you create a column weekday and use Weekday(thisRow.Date) and conditionnal formating to easily show week ends 👍
db1.Filter(due_date=thisRow.Date).Task.BulletedList
It will create a list of all your task in a give week, for all the year ! If you work on multiple year, you just need to create additionnal filtering criteria !
Finally, you just need to display a view of db2 in your dashboard, filtering the data with the following formula IsoWeekNumber(thisRow.Date)=IsoWeekNumber(Today()) to display only the current week 😉, and displaying it as you wish : table, card, etc...
Hope you enjoy this little trick ! Please visit to leave any comment, suggestion, or see my twitter feed !
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.