Adding Basic Property Types

1. What Are Database Properties?

If a database is a filing cabinet and each entry is a folder, then properties are the labels on the outside of each folder. They are the columns in your database that hold specific, structured pieces of information about each item, such as a name, a date, a status, or a URL.

Using the correct property type is crucial. For example, if you put a date in a Text property, Notion just sees it as a word. But if you put it in a Date property (which we'll cover later), you can then view that item on a calendar, sort by due date, and set reminders.

Let's start by exploring the three most basic, yet essential, property types.

2. The Core Property Types

To see these properties in action, let's watch a few short, focused clips from the video "All Notion Databases Explained in Under 30 Minutes!" by Creative Cove. This will give you a clear visual of how to add and use each one.

Now, let's break down what you just saw and discuss the strategy behind using each one.

A. Text Property

The Text property is your go-to for free-form writing. It's flexible and can hold almost anything, from a short note to a long paragraph.

• Primary Use Cases:

  • Names/Titles: The default "Name" property is a special, required Text property.
  • Descriptions: Brief summaries or descriptions of an item.
  • Notes: Quick, unstructured thoughts or comments.

• Strategic Advice:
  The biggest beginner mistake is using the Text property for everything. If the data has a specific structure—like a date, a status, or a category—it should not be in a Text field. Using the correct property type from the start is key to building templates that are easy to filter and sort.

B. Number Property

The Number property is for any data you might want to count, measure, or perform calculations on.

• Primary Use Cases:

  • Quantities: Word count, number of ingredients, inventory count.
  • Financials: Price, budget, expenses.
  • Ratings or Scores: A rating out of 5 or 10.

• Key Features:

  • Formatting: As you saw in the video, you can format numbers as currency, percentages, or even display them as progress bars or rings—a great feature for visual dashboards.
  • Calculations: At the bottom of a number column in a table, you can automatically calculate the Sum, Average, Median, Min, Max, and more. This is incredibly useful for summary views.

C. Checkbox Property

The Checkbox property is the simplest of all: a binary true/false toggle.

• Primary Use Cases:

  • Task Completion: The classic "Done?" checkbox.
  • Tracking: "Published?", "Archived?", "Reviewed?".
  • Filtering: Use a checkbox to mark items you want to hide from your main view (e.g., an "Archive" checkbox).

• Strategic Advice:
  A checkbox is perfect for any question with a simple "yes" or "no" answer. Its simplicity is its strength, providing a clear visual indicator of status.

For a deeper dive into the strategic thinking behind choosing properties, this article is an excellent resource.

✍️ Exercise: Add Properties to Your Content Hub

It's time to apply this to the "Master Content Hub" you created in the last lesson. This will be the foundational structure for the content creation template you'll eventually design.

1. Navigate to your "Master Content Hub" database.
2. Rename the "Name" property. By default, Notion gives you a primary property called "Name" and a "Tags" property.
   • Click on the "Name" column header, and rename it to "Content Idea". This is where you'll put the title of a blog post or video.
3. Delete the default "Tags" property. We'll be adding our own structured properties.
   • Click on the "Tags" column header, select "Delete property", and confirm.
4. Add a Text property.
   • Click the + icon at the far right of the table.
   • Name the property "Brief Description".
   • Set the Type to Text.
5. Add a Number property.
   • Click the + icon again.
   • Name the property "Target Word Count".
   • Set the Type to Number.
6. Add a Checkbox property.
   • Click the + icon one more time.
   • Name the property "Idea Approved".
   • Set the Type to Checkbox.

Your database should now have three new columns, ready to structure your content ideas! Feel free to add a few example entries to see how it works.

Lesson Summary and Next Steps

Fantastic work! You've moved beyond creating empty databases and have now taken the first, most critical step in structuring your data. By choosing the right property for the right job, you're building a solid foundation for the powerful systems you want to create.

Key Takeaways:

• Properties are the columns in a database that hold structured information.
• The Text property is for flexible, free-form notes and descriptions.
• The Number property is for any data you need to count, measure, or calculate.
• The Checkbox property provides a simple "yes/no" or "done/not done" toggle.
• Choosing the correct property type from the start is essential for creating clean, functional, and sellable templates.

You now know how to capture basic information. In our next lesson, we will explore properties that are designed for organization and categorization: Select and Multi-select. These will allow you to tag, group, and filter your database entries, bringing your project managers and content calendars to life.