A single Bitable contains multiple tables, and each table can have multiple views.
In a Bitable, you can link data across tables through Formula, Relation fields and LOOKUP fields.
In a single table, different views are generated based on the same source of data. Actions and data changes in any view are synchronized to all views of that table.
II. Bitables, grids, and views
What is Bitable?
A Bitable is a database that looks like a table. The data in a Bitable must strictly follow the data format requirements for each column (clomun is called field in Bitable). The first column， primary column is the index to recognize every row (row is called record in Bitable).
The figure below shows how to create a Bitable for task management in Docs. In this Bitable, all employees can manage team tasks.
What are tables?
A table is like a sheet that stores data in a database. You can think of the relationship between tables and its Bitable as similar to that between individual sheets and the spreadsheet they belong to.
In a Bitable, tables are arranged vertically on the left. Click + New table to create a new one.
In the figure below, the Bitable has four tables: Task breakdown, Team OKR Tasks, LOOKUP, and Table 4.
What are views?
Views allow you to see the data in a table from a specific perspective. Each table can be displayed in four view types. This is equivalent to displaying the grid as a sheet, notecard, Gantt Chart, or gallery photos.
Creating a new view for a table is equivalent to adding a new display style. Editing data in any view (such as add, change, delete content) will affect the data displayed in all other views. To achieve the effect of creating multiple sheets in a spreadsheet, you have to create multiple tables.
Note: The concept of views is not applicable to Spreadsheets. A grid view can be considered as a pivot table in a sheet.
In the figure below, the task breakdown table has four views:
- •Progress gantt chart (Gantt view)
- •Progress kanban (Kanban view)
Views provide a better experience when multiple users collaborate on the same table. You can create a view to filter and group the data therein, so you can easily see the content relevant to you.
Note: Filtering, grouping, or changing the order of data in one view does not affect the display of data in other views. However, editing or deleting the data in cells will affect the data displayed in other views.
When you create a Bitable, tables are displayed in grid view by default, which makes it easier to add and set different types of field.
The grid view displays data in the style of a sheet. This view is generally used to create or adjust the table structure. It allows you to quickly add and move fields and input data efficiently.
In kanban view, each row in grid view becomes a card. The cards are arranged in multiple columns based on specified conditions, allowing you to intuitively view and manage the data in each column.
In gantt view, the content in the first column and the start and end dates of each record are displayed based on the date fields in table. You can drag and drop the time bar to modify time periods. This view is useful for tracking project progress and milestones.
In gallery view, the attachments uploaded in each row are the primary content. Each record is shown as a single gallery card. This view allows you to view visual content as in a media gallery.
How can I quickly distinguish between tables and views?
The simplest method to distinguish between grids and views is to view their icons on the left.
- •Table (Task breakdown in the figure below): Names are in bold with a small triangle icon on the left. Click table's name to expand or collapse views.
- •View (Task list, Progress gantt chart, Progress kanban, Tasks in the figure below): Names are not in bold and the icons on the left indicate the view types.
How many grids can I create in a single Bitable?
How many records (rows) can a single grid contain?
How many fields (column) can a single grid contain?
How many views can I create for a single grid?