A row is a line item in a database that you can record many different types of data onto. Each row in a database can represent whatever you want. See the examples below.
Example 1 — Each Row is a Task
In this example, we are using a database to manage tasks. Each row in the database is a task and we've added a few fields to keep track of the task type, priority, and status of each task.
Example 2 — Each Row is a Book
In this example, we're using a database to keep track of books that we've read or that we want to read. Each row in this database represents a book and we've created several fields where we can record the authors name, the “read” status of each book, our rating of the work, as well as a page field where we can record our notes on the book.
Creating a Row
You can add a new row to a database by clicking on the “Add row” button at the bottom of the database grid.
Pro tip: When a cell in the database is selected, you can create a new row by pressing Shift
Enter
. This will create a new row directly under the selected cell.
Rearranging Rows in a Database
To rearrange a row in a database, do the following:
Hover over the row you want to move.
On the left edge of the row, click and drag the six-dot menu/handle icon.
Drop the row in the location that you want to place it in.
Deleting a Row
To delete a row, do the following:
Hover over the row you want to delete.
Click on the six-dot menu icon that appears just left of the row.
Then select “Delete row” from the menu that appears.
Note: If you delete a row in a database that has a page resource in it, deleting the row will not delete the page. You'll still have access to that page in your account, but the row and any other data in it will be deleted.