Notion Databases - Full Course for Beginners

Introduction to Notion Databases

• Notion databases serve as a primary feature for creating functional tools within a workspace, such as task managers, note-taking systems, contact trackers, sales dashboards, and game trackers 0s.
• The course utilizes a project-based approach, focusing on the construction of a Simple Task Manager to demonstrate the features and facets of Notion databases 32s.
• A more advanced, free template titled "Ultimate Tasks" is available for users seeking features like recurring tasks, subtasks, and projects with progress bars 1m5s.
• Additional reference templates, including a simple contact tracker and a simple book tracker, are provided to facilitate learning through experimentation 1m35s.

Database Structure and Properties

• A database is defined as a collection of records, where each individual record functions as a separate Notion page 2m6s.
• Each record within a database can be opened as a page, allowing for the embedding of various content types, such as headers, quotes, or additional databases, to an unlimited depth 2m25s.
• Databases utilize properties to store structured information on a per-record basis, with these properties defined at the database level rather than the individual page level 2m50s.
• The "Name" property serves as the key property for a database, while other property types include multi-select options for tagging and checkboxes for binary status tracking 3m5s.
• When a new record is created in a database, it contains properties that exist across every record in that database, even if those properties are currently empty for a specific entry 0s.

Databases Versus Spreadsheets

• Databases in Notion are distinct from spreadsheets; while spreadsheets rely on rows and columns where individual cells have specific XY coordinates that can be targeted by formulas, databases consist of property values attached to individual records 25s.
• Because database records are not individual cells, they cannot be targeted for math in the same way as spreadsheet cells 1m5s.
• Databases offer advantages over spreadsheets by allowing users to view, filter, sort, and group information in various formats, such as table or board views 1m20s.

Creating and Linking Databases

• There are multiple methods to create a database in Notion, starting with typing "/database" to choose between an inline database, which displays on the current page, or a full-page database, which creates a linked page 2m6s.
• Users can convert an inline database into a full-page database, or vice versa, by using the block menu options 2m35s.
• Beyond the "/database" command, users can initiate a database by typing specific layout commands, such as "/table," "/board," or "/calendar," to select a specific view type immediately 3m5s.
• When initiating a database using a slash command, users are presented with the choice to create a new database or a linked database 0s.
• A linked database functions as a new database block that references an existing source database, allowing users to display the same information while applying unique filter and sort criteria 12s.
• Creating a new page via a slash command provides the option to generate a new database or a linked database, which defaults to a full-width page layout 42s.

Managing Database Views

• Database views allow users to display the same master database information through different filters, sorting criteria, and layouts 1m5s.
• Multiple contextual views can be created from a single master database, such as separating notes into categories like an inbox, favorites, or recent entries 1m25s.
• Views are managed via a tabbed bar located at the top of the database 2m35s.
• If the screen width is insufficient to display all tabs, additional views are accessible through a dropdown menu 2m45s.
• The view options menu, accessed via a three-dot icon, allows users to modify the layout of a specific view and toggle the visibility of the database title 2m55s.

View Configuration and Administration

• Database columns can be configured to wrap text, which increases the size of the cells 0s.
• The view options menu provides access to property management, including the ability to show or hide properties and modify their specific settings 3s.
• Users can utilize a filter menu, a sort menu, grouping options, and a load limit feature to manage large amounts of database information 13s.
• The load limit feature allows users to set a specific number of pages to load initially, requiring a "load more" button to view additional entries 18s.
• The view options menu also contains administrative functions such as locking the database, copying a link to the view, duplicating the view, or deleting it 26s.

Adding Rows and Managing Properties

• There are three primary methods for adding new rows to a database: clicking the "new" button to add a row directly in the table, clicking the "new" button to open a page for entry, or using the plus syntax from elsewhere in the Notion workspace 35s.
• Using the plus syntax allows users to create a new database entry from a different location, such as a meeting notes page, by typing the name of the task and selecting the database where it should be stored 56s.
• Properties can be managed by deleting existing ones, such as the default tags property, or by adding new ones using the plus button 1m25s.
• Notion offers various property types, including basic options like number, select, multi-select, date, person, files and media, checkboxes, URLs, emails, and phone numbers 1m38s.
• Advanced property types available in Notion include formulas, relations, and rollups 1m55s.
• A checkbox property can be used to track completed tasks, while a date property allows for the assignment of due dates 2m0s.
• Users can adjust the width of property columns in the table view and rearrange their positions, such as moving a checkbox property to the left side of the table 2m6s.
• An assignee property can be created using the select property type 2m20s.

Task Management and Layout Types

• Notion databases allow for the addition of specific properties to tasks, such as assignees and due dates, which can then be marked as complete 0s.
• Assignees can be designated for specific tasks, such as assigning the "lizard antidote" to Dr. Connors and "taking grocery boxes to the feast" to Peter 15s.
• Databases offer flexibility through six different layout types, including table, board, timeline, calendar, list, and gallery views 45s.
• A board view functions similarly to a Kanban or Trello-style layout, allowing tasks to be grouped by specific properties like the assignee 1m5s.
• Gallery views are useful for displaying header images or file attachments prominently 1m30s.

Sorting and Sharing Database Views

• While different views display the same underlying information, their utility is enhanced by applying sort and filter criteria to provide context-specific data 1m45s.
• Sorting can be applied to database views by selecting a property, such as a due date, and choosing between ascending or descending order 2m0s.
• Multiple sort criteria can be applied to a single view, with the database prioritizing the order of the selected criteria 2m25s.
• When a database is shared, users have the option to "save for everyone" when applying sort or filter criteria, which makes the changes permanent for all collaborators 3m0s.
• If the "save for everyone" option is not selected, changes to sort or filter criteria remain visible only to the individual user on their current device 3m15s.
• Sorting criteria can be applied to database views to organize tasks, such as setting due dates to ascending order for upcoming tasks or descending order for completed tasks 0s.

Filtering and Forcing Functions

• Properties that are hidden by default in board views, such as due dates or completion checkboxes, can be made visible by accessing the view options menu and selecting the desired properties under the properties tab 25s.
• Filters are used to restrict the rows displayed in a view to those that match specific criteria, such as tasks due within a certain timeframe or tasks that are marked as completed 55s.
• Simple filters allow users to isolate data based on a single property, such as filtering for tasks where the "done" checkbox is checked 1m15s.
• Advanced filters enable the creation of complex rules by combining multiple conditions, such as requiring that a task is both incomplete and due within the next seven days 2m6s.
• Date-based filters offer various configuration options, including the ability to set parameters like "is on or before" relative to a specific timeframe, such as one week from the current date 2m25s.
• When a new row is added to a filtered view, Notion automatically applies the filter criteria to that row, a process referred to as a forcing function 3m15s.
• Forcing functions ensure that new entries automatically inherit properties required by the view's filter, such as assigning a due date exactly seven days in the future if the view is filtered to show tasks due within the next week 3m35s.

Advanced Forcing Functions

• Notion allows for the creation of "forcing functions" by utilizing writable properties, which are properties that can be manually edited or set, such as text or number fields 0s.
• Writable properties exclude files, media, formulas, rollups, created time, and last edited time properties 7s.
• Forcing functions can be implemented by setting specific filter criteria on a database view, such as requiring a status property to be non-empty 35s.
• When a new row is created in a database view with a filter requiring a non-empty status, Notion can automatically assign a default status to that row, ensuring it immediately appears in the correct filtered view 55s.

Database Relations

• Database relations provide a method to link records to one another, either within the same database or across different databases 2m6s.
• Within a single database, relations can be used to establish hierarchies, such as connecting a parent task to multiple subtasks 2m25s.
• Across different databases, relations allow for the connection of related items, such as linking individual tasks to a larger project 3m5s.
• Relations enable users to view contextual data by applying filter and sorting criteria based on the established connections between records 3m45s.
• A relation can be established between two databases, such as a "Projects" database and a "My Tasks" database, by selecting the relation property type within the database settings 0s.
• When creating a relation, users have the option to link a database to itself or to a different database 25s.
• Users can choose whether to display the relation property on both databases; enabling this feature allows for more effective filtering and sorting across linked items 42s.
• Once a relation is established, users can select specific tasks to link to a project or assign a project to a specific task directly through the relation property fields 1m15s.

Grouping and Subgrouping Data

• Adding a status property with a select type allows for tracking project progress, such as "to do," "doing," and "done" 1m35s.
• Setting an "is not empty" filter on a select or multi-select property causes new rows to automatically adopt the top-listed option as a default 1m45s.
• Databases can be grouped by any property type, allowing users to organize rows by categories like projects or assignees 2m45s.
• Grouping settings can be adjusted within the view options menu to change how data is displayed, such as switching from an assignee-based view to a project-based view 3m5s.
• Board views in Notion offer a unique subgrouping feature, which allows for the creation of "swim lanes" by selecting a second property to organize the data 3m35s.
• Notion databases allow for grouping by both rows and columns, enabling users to organize project groups and split them by assignees 0s.

Database Templates

• Database templates are pages within a database that contain default content, which can include text, headings, or even additional databases 35s.
• Because every row in a Notion database is also a page, templates can be used to automatically populate new rows with pre-defined content 45s.
• Templates are created by clicking the blue arrow next to the "New" button in a database, where users can define content such as headings or specific formatting 1m5s.
• Once a template is created, it can be applied to existing rows that lack content or used to initialize brand-new rows with the default structure 1m25s.
• Complex templates, such as those used for YouTube production, can include comprehensive structures like task managers, research notes, and scripting areas to streamline repetitive workflows 1m55s.

Linked Databases and Self-Referential Filters

• A linked database allows users to display and interact with an existing database in a new location, such as within a project template 2m35s.
• To create a linked database, users type "/table" and select an existing database rather than creating a new one, choosing to either copy an existing view or start with a new empty view 3m5s.
• Linked databases provide an identical view to the source database and include a link that allows users to navigate back to the original source 3m35s.
• Users can navigate back to previous views using the Alt+bracket or Command+bracket keyboard shortcuts 0s.
• A self-referential filter is a specific type of filter applied to a linked database within a template that automatically updates to reference the specific page where the template is deployed 5s.
• To create a self-referential filter, one adds an advanced filter to a linked database, setting the project relation to contain the project template 18s.
• When a new project is created from a template containing a self-referential filter, the filter automatically updates to reference that specific project page rather than the template itself 35s.
• Removing grouping and maintaining specific sorting criteria, such as by due date, helps clean up the view of a linked database within a project page 55s.
• Tasks added directly through a project page that utilizes a self-referential filter are automatically associated with that project via the relation property 1m25s.

Rollups and Formulas

• Rollups and formulas are advanced property types in Notion databases that allow for more complex data management and analysis 1m55s.
• A rollup property allows a database to access and display property data from rows in a related database 2m15s.
• To track unfinished tasks, a rollup property can be created in a projects database by selecting the tasks relation and choosing the "done" property 2m35s.
• By default, a rollup set to "show original" displays the raw data—such as a list of checkboxes—from the related items 2m55s.
• Rollup configurations can be adjusted to display the count of unchecked items rather than the original value, providing a count of unfinished tasks for specific projects 0s.
• The calculate tab at the bottom of a table view allows for various aggregate functions, such as sum, average, or median, to be applied to the data 35s.
• Formulas are identified as a complex and powerful property type in Notion that can be used to customize how data is displayed 1m5s.
• A formula property can be created to transform a numeric rollup value into a more descriptive text string, such as changing a number to include the phrase "tasks left" 1m25s.
• The prop command is used to reference existing properties within a formula, while the format function converts numeric outputs into string values so they can be combined with text 1m45s.
• Conditional logic, specifically an if statement, can be integrated into a formula to dynamically adjust text based on the numeric value, such as switching between "task" and "tasks" depending on whether the count is greater than one 2m35s.
• Notion formulas can be used to perform complex tasks that the platform cannot execute natively, such as those implemented in the Ultimate Task template. 0s

Database Permissions and Locking

• Database permissions can be adjusted to restrict access, specifically by changing a user's permission level to "can edit content," which prevents them from modifying the database's structure or views. 42s
• Locking a database through the three-dot menu prevents the modification or deletion of properties, though users can still edit the content within those properties, such as changing due dates or checking off tasks. 1m15s
• Locked databases can be unlocked at any time to allow for edits and then re-locked to maintain restrictions. 1m45s
• Linked database views can be locked individually, which prevents permanent changes to filter or sort criteria. 2m6s
• When a database view is locked, users can apply temporary filters that do not save for everyone, but they cannot alter the underlying filter criteria until the view is unlocked. 2m20s

Building Dashboards

• The Simple Task Manager created in previous lessons can be integrated into a personal dashboard template using linked databases. 2m45s
• To display the task manager on a dashboard, a user can utilize the plus button located within the tasks area of the dashboard template. 3m15s
• A list view can be utilized to create a mobile-friendly interface by selecting an existing database, such as "My Tasks," as the source 0s.
• Databases can be customized through the application of unique filters, sorting, and grouping criteria to suit specific user preferences 5s.
• A filter can be applied to a "done" checkbox to display only unchecked items, and sorting can be configured by due date in ascending order to create a compact dashboard view 12s.
• Notion dashboards can be designed to consolidate various elements, including tasks, notes, and web links, into a single accessible location 26s.

Course Resources and Support

• A table of contents is available in the video description to assist users in reviewing specific sections of the database lesson 38s.
• Companion resources for the course, including written and video lessons, are hosted at thomasjfrank.com/fundamentals 53s.
• Users have the option to sign up for a Notion Tips newsletter to receive updates on new tutorials and free templates, though access to resources is possible without subscribing 1m3s.
• Three sample templates—a book tracker, a simple contact tracker, and a simple task tracker—are provided to help users practice database functionality 1m22s.
• An advanced task management system called Ultimate Tasks is available, which includes features such as subtasks, recurring tasks, and project management tools with progress bars 1m32s.
• Questions regarding Notion can be directed to the comments section or via Twitter at @tomfrankly 1m45s.