Database properties

Database properties - hero
In this Article

Database properties add all kinds of context to your database items, like due dates, task owners, relevant URLs, last edited timestamps, and more. Use these properties to filter, sort, and search your data 🧩


Property

Description

Text

Add text that can be formatted. Great for summaries, notes, and descriptions!

Number

Accepts numbers. These can also be formatted as currency or progress bars. Useful for tracking counts, prices, or completion.

Select

Choose one option from a list of tags. Useful for categorization.

Status

Track this item’s progress using status tags categorized by To-do, In Progress, or Complete.

Multi-Select

Choose one or more options from a list of tags. Useful for tagging items across multiple categories.

Date

Accepts a date or a date range (time optional). Useful for deadlines, especially with calendar and timeline views.

Formula

Perform calculations based on other properties using Notion’s formula language. Learn more here and here →

Relation

Connect databases and mention database pages. Useful for connecting items across your workspace. Learn more here →

Rollup

View and aggregate information about properties from relation properties. Useful for summarizing interconnected data. Learn more here →

Person

Tag anyone in your Notion workspace. Useful for assigning tasks or referencing relevant team members.

File

Upload files and images for easy retrieval. Useful for storing documents and photos.

Checkbox

Use a checkbox to indicate whether a condition is true or false. Useful for lightweight task tracking.

URL

Accepts a link to a website and opens the link in a new tab when clicked.

Email

Accepts an email address and launches your mail client when clicked.

Phone

Accepts a phone number and prompts your device to call it when clicked.

Created time

Records the timestamp of an item's creation. Auto-generated and not editable.

Created by

Automatically records the person who created the item. Auto-generated and not editable.

Last edited time

Records the timestamp of an item's last edit. Auto-updated and not editable.

Last edited by

Records the person who edited the item last. Auto-updated and not editable.

Button

Automate specific actions with one click. Learn more here →

ID

Automatically creates a numerical ID for each item. IDs are unique and cannot be manually changed.

  • Notion AI can save you time by autofilling certain types of database properties! Learn more here →

  • You can apply a layout to all pages in a database so that all of your database properties can be organized how you want. Learn more here →

To manage the properties of a database, select ••• at its top right → Properties. From there, you can:

  • Add a new property: Select New property, then select a property type and give your property a name.

  • Hide a property: Select the eye icon next to a property you don’t want to show in your database.

  • Edit a property: Select ⋮⋮. You can rename your property, hide it from view, wrap or don’t wrap it in view, duplicate it, or delete it.

  • Rearrange properties: Drag ⋮⋮ to put your properties in a different order.

Any data put into a property is called a value. The way you edit values is different for each type of property. Here are just a few examples:

  • For Select and Multi-select properties, you'll be prompted to add tags by typing what you want and pressing enter after each. Colors are randomly assigned.

    • You can add as many unique tags to these menus as you want.

    • Edit tag names and colors, or delete them by clicking on the property field (i.e. the table cell), then ••• that appears to the right when you hover over any property.

    • Reorder tags by grabbing the ⋮⋮ icon to their left and dragging.

  • For Date properties, clicking to add data will bring up our date picker, where you can select the day relevant to the database item — maybe it's an event date or deadline.

    • Click Remind to set a reminder in this property that will notify you on the given date and time.

    • Switch on End date to define a range of dates in this property.

    • Switch on Include time to choose an exact time, not just a day.

    • Click Date format & timezone to modify these settings.

    • Click Clear to remove any value in the date property.

  • For Files & media properties, clicking on the field provided will prompt you to upload a file, or paste a link to embed a file.

    • You can also drag a file from your computer into the property to upload it.

    • You can add multiple files into any field at once.

    • Click on the ••• to the right of uploaded files to DeleteDownloadFull screen or View original.

    • Use the ⋮⋮ to the left of uploaded files to drag and re-order them.

  • In a Person property, you can tag other members or guests in your workspace.

    • Just type their names and press enter after each.

    • To delete anyone tagged, click on them, then click X next to their name.

  • Values automatically appear for these properties: Created timeCreated byLast edited timeLast edited By.

  • You can simply type or paste values for URLEmailPhone and Number properties, just like you would for a Text property.

  • Editing values for Relation and Rollup properties requires multiple steps.

You can leave comments in database properties, only when you’re in table view or when you have a database page open.

Note:

  • At this time, you can’t comment in name, formula, rollup, button, and unique ID properties.

  • Properties must already have a value assigned before someone can comment on them.

To comment on a property while in table view:

  1. Hover over a property for a database item.

  2. Select the 💬 that appears.

  3. Enter your comment.

Note: While you can comment on a checkbox property, you’ll have to open the database page to do so — there won’t be a way to do this from table view.

To comment on a property while in a database page:

  1. Hover over a property.

  2. Select the 💬 that appears, or select the ⋮⋮ to the left of the property → Comment.

  3. Enter your comment.

Once a comment has been made, you’ll see 💬 next to the property it’s attached to. You can select 💬 to see the comment and add to the conversation.


Give Feedback

Was this resource helpful?