哈喽,感谢你访问我们的帮助中心。目前我们的帮助中心还在建设中。我们将在不久的未来呈现帮助中心的内容。感谢你的理解,我们未来再见!

Table View Databases
在这篇文章中

表是经典的数据库视图,但 Notion 中的表不仅仅是行和列。每一行都打开自己的页面,并且可以包含你想要的任何属性🗄

跳转到常见问题

Here's how to to add a database in table view to Notion:

  1. Create a new page in your workspace.

  2. Under Get started with, click on Table.

If you want to create an inline table, type /Table view on any page and press enter.

Note: Expand inline databases to full page by clicking  at the top right. Hover over the top of your database to see its option menus. Click ••• to see the PropertiesFilter, and Sort options.

Add table view to a database

You can add a table to an existing database to view its data in that format. 

  1. Click + at the top left of your database.

  2. Select Table from the dropdown menu.

Note: You can also create simple tables if you want to display plain text visually without database functionalities (such as filters, sorts, and specific property values).

You can select multiple rows in order to edit their properties.

  1. Hover over any row and click the checkbox.

    • To select all, click the checkbox at the very top left of the database, next to the Title property.

  2. Select a property in the menu that just appeared to edit for all selected rows.

Rearrange columns & rows

Switch up how your table is ordered with drag-and-drop on desktop or browser.

  • For rows, hover, then click and hold the ⋮⋮ icon on the left to drag it up or down.

  • For columns, click and hold their headings to drag them left or right (like below).

    • Resize columns by hovering over their edges, and dragging right or left.

Tip: You can also rearrange your columns by clicking Properties at the top right, then using the ⋮⋮ icon next to the properties shown to drag them up or down.

Wrap cell content

If your cells contain a lot of content, you can have it appear on multiple lines.

  1. Click on the ••• icon at the top right of your table, click Layout toggle on Wrap all columns.

    • Or to wrap a single property, click at the top of a specific column and toggle on Wrap column.

Calculations

At the bottom of every column in your table, you can run calculations that will show you information about the data contained in that column.

Hover below the last row in your table, then click the word Calculate that appears under any column you want to learn more about:

  • You'll see a dropdown menu containing these calculation options:

    • Count all: Gives you the total number of rows in the column.

    • Count values: Counts the number of property values contained in the column. 

    • Count unique values: Counts the number of unique property values contained in the column, omitting duplicates. 

    • Count empty: Counts the number of rows that do not have a value in the column. 

    • Count not empty: Counts the number of rows where the column is filled. 

    • Percent empty: Gives you the percentage of rows that do not have the chosen property filled in. 

    • Percent not empty: Gives you the percentage of cards that do have the property filled in. 

    • Earliest date: If you have time-related properties in your table like Last edited or Created time, you can choose to show when the oldest row was edited or created.

    • Latest date: Shows when the newest row was last edited or created.

    • Date range: Shows you the time gap between the oldest and newest edit or creation time.

  • If you have a Number property in your table, you unlock several other calculation options:

    • Sum: Shows the sum of the numbers in the column.

    • Average: Shows the average of the numbers in the column.

    • Median: Shows the median of the numbers in the column.

    • Min: Shows the lowest number in the column.

    • Max: Shows the highest number in the column.

    • Range: Subtracts the lowest number from the highest.


常见问题

Is there a way to add background colors to specific cells? Or conditional formatting?

Not at the moment, unfortunately. It's a popular feature request though, so definitely on our radar! For the time being, you can use Select and Multi-select properties to add a pop of color to your table 🎨

Why can't I delete the Name property?

Our tables are a lot different than traditional spreadsheets, since each row represents a database entry that can be opened as its own page, or visualized in other database views. The Title property gives you access to database pages. That said, you can drag the column left or right to re-order it however you want!

Is there a way to skip the modal view, and always Open as Page by default?

Yes!

  1. Click the ••• at the top right of your database.

  2. Under Layout, click Open pages in and select Full page.

Does Notion have simple (non-database) tables?

How can I turn a full page database into an inline database?

  1. If it's not already, drag the database from your sidebar into another page. It will become sub-page

  2. Go to that page, click the ⋮⋮ button next to the database sub-page and select Turn into inline.

    • Click the ⋮⋮ button and select Turn into page to change it back.

仍有更多问题?给支持部门留言

给予反馈

这个资源有帮助吗?