<aside> ↙️ Hi, Hello! My name is Sarah - the writer behind redgregory.com.
</aside>
<aside> ⚡ Subscribe to the newsletter if you haven't already
</aside>
Get started automating your timetable with this formula. This approach to scheduling is great for making appointments with team members, tracking daily tasks in the morning, and more. If you're familiar with Notion formulas, this can act as a great jumping off point to customize your own table.
<aside> 🔥 How does the formula work?
Condition 1: if tags say time (in 1 hour interval), do task at that time today False Condition: if not, do task at 5pm
</aside>
if(prop("Time") == "12am", dateSubtract(dateSubtract(now(), hour(dateSubtract(now(), 1, "days")), "hours"), minute(now()), "minutes"), if(contains(prop("Time"), "am"), dateSubtract(dateAdd(now(), toNumber(prop("Time")) - hour(now()), "hours"), minute(now()), "minutes"), if(contains(prop("Time"), "pm"), dateSubtract(dateAdd(now(), toNumber(prop("Time")) + 12 - hour(now()), "hours"), minute(now()), "minutes"), dateSubtract(dateAdd(now(), 17 - hour(now()), "hours"), minute(now()), "minutes"))))
Copy the template → ****Auto Select → Timetable
A database with a select property called “Time,” and each select will be formatted “#am/pm.” You also need a formula property to plug in the code provided in the template.
!OR ... just duplicate the template
When you're done your tasks for the day, clear your database by clicking on the first column cell and dragging down to delete all entries.
https://s3-us-west-2.amazonaws.com/secure.notion-static.com/8bd83e89-4ddf-4998-bfc7-65c8f902126d/Screen_Recording_2021-01-12_at_10.31.21_AM.mov
https://whimsical.com/NJbv33VBgED35fSfNnxQdJ