Hey — it's Rames
Went hiking this weekend. Still in Parque Natural los Alcornocales — it's so huge it's going to take more than a few weekends to visit it all. Beautiful sceneries, as always.
Also added a few animals to our collection — we've seen strange insects, deer (one of them lost its antler), beautiful eagles, and adorable donkeys.
3 Tips
1/ Arrange your Notion sidebar
Your sidebar is now "yours." You can rearrange sections (by drag & drop) to display your favorite/most used sections at the very top! Enjoy 😋
2/ AI suggested Notion properties
Notion now suggests AI properties based on your database content. I'm not fully convinced by Notion's AI yet, but this is a step in the right direction.
3/ Sync Notion parent-task dates with sub-task dates
If you're using Notion's sub-items feature, you might find the lack of cohesion between parent-items and sub-items somewhat frustrating. For instance, wouldn't it be convenient if the parent task's "date" property could automatically update based on the dates of its sub-tasks?
I attempted to solve this problem using formulas. Here's what I devised for the date example:
/* Differenciate parent-tasks from sub-tasks (+sub-tasks with empty due dates) */
if(or(empty(prop("Parent-task"))==false,empty((map(prop("Sub-tasks"),current.prop("Due"))).format().replaceAll(",",""))==true),prop("Due"),
/* Create the parent task range */
dateRange(map(
/* Get sub-tasks */
prop("Sub-tasks"),
/* Get sub-tasks due dates */
current.prop("Due").dateStart())
/* Sort dates in ascending order */
.sort()
/* Get the most recent date */
.first()
/* Get its start date */
.dateStart(),
/* Repeat for end date */
map(prop("Sub-tasks"), current.prop("Due").dateEnd()).sort().last().dateEnd())
)
This formula essentially generates a new date range for the parent tasks, using the earliest start date and the latest end date from all of its sub-tasks.
If you want to apply this formula to your own task manager, remember to name your properties as follows:
- Parent task (relation) → "Parent-task"
- Sub task (relation) → "Sub-tasks"
- Date (date) → "Due"
2 Resources
1/ Ziki’s automated reports
Just stumbled on this wonderful system for generating BOW (beginning of week) and EOW (end of week) reports based on your Notion tasks database. It's entirely constructed within Notion, utilizing formulas and database automations. Truly impressive.
Awesome build, Ziki 👏
2/ Josh’s guide to company Notion
Here's another quality thread from Josh Redd about building your company's operating system in Notion.