Create a Notion Style Life OS Dashboard in Google Sheets
HTML-код
- Опубликовано: 19 июл 2024
- If you're a productivity junkie, like me, you've probably heard of or used Notion. But you've probably also run into some of Notion's limitations. In this video, I show you how to build a basic Notion-style life tracker dashboard using Google Sheets and App Script.
Get the code here: gist.github.com/palumbo/197e2...
Chapters
0:00 Dashboard Overview
2:22 Setting up a new Sheet
2:38 Adding a custom menu
4:18 Getting quotes using IMPORTHTML
6:22 Building random quote generator
11:39 Adding a habit tracker
13:56 Adding journal entries
15:17 Creating date and month variables
17:00 Getting the last row of a section
19:15 Preventing duplicate journal entries
27:31 Adding task tracking
30:54 Splitting Project, Tasks, and Due Dates
36:17 Using QUERY to group project tasks - Наука
I love the sheet and I appreciate all the work. But I get the error: "TypeError: Cannot read properties of undefined (reading 'range') onEdit @ Code.gs:81" This happens both when I type the code myself and when I copy/paste from your linked code. Can you see the problem?