Working with Rows

Rows are individual records in your database. Each row represents one item, entry, or record with values for each property (column).

Adding Rows

Method 1: Footer Button

1. Scroll to the bottom of your database
2. Click the "+ New" button
3. A new row appears with empty cells
4. Click any cell to start entering data

Method 2: Keyboard Shortcut

1. Navigate to the last cell in the last row
2. Press Enter
3. A new row is created below
4. Focus moves to the first cell of the new row

Method 3: Context Menu

1. Right-click any row
2. Select "Add row below" or "Add row above"
3. New row appears in that position

Method 4: Duplicate Row

1. Right-click a row you want to copy
2. Select "Duplicate row"
3. A copy appears below with all the same values
4. Edit as needed

Tip: Duplicating is great for creating similar entries quickly!

Editing Cells

Basic Editing

1. Single click on a cell to select it
2. Double-click or press Enter to edit
3. Type or select your content
4. Press Enter to save and move down
5. Press Tab to save and move right
6. Press Escape to cancel changes

Cell-Specific Editing

Text cells:

• Type freely
• Use formatting shortcuts (Ctrl+B for bold, etc.)
• Press Enter to add line breaks (if wrap is enabled)

Number cells:

• Type numbers directly
• Decimal point supported
• Negative numbers with minus sign

Select/Multi-select cells:

• Click to open dropdown
• Type to search options
• Click option to select
• For multi-select, click multiple options
• Press Enter or click away to close

Date cells:

• Click to open date picker
• Navigate months with arrows
• Click a date to select
• Optionally add time
• Can set date ranges

Checkbox cells:

• Click to toggle on/off
• Keyboard: Space bar to toggle

Person cells:

• Click to open team member list
• Type to search
• Click to assign
• Can assign multiple people

File cells:

• Click "Upload" button
• Select file from computer
• Or drag and drop files
• Multiple files supported

URL/Email/Phone cells:

• Type the value
• System validates format
• Click to open/call (when saved)

Selecting Rows

Single Row

Click the checkbox on the left side of any row.

Multiple Rows

Method 1: Click Multiple

• Hold Ctrl/Cmd and click additional checkboxes

Method 2: Range Selection

• Click first row's checkbox
• Hold Shift and click last row's checkbox
• All rows in between are selected

Method 3: Select All

• Click the checkbox in the header row
• All visible rows are selected

Bulk Actions

When rows are selected, a bulk action bar appears:

• Delete: Remove all selected rows
• Duplicate: Copy all selected rows
• Export: Export selected rows to CSV
• Clear selection: Deselect all

Reordering Rows

Drag and Drop

1. Hover over a row to reveal the drag handle (⋮⋮) on the left
2. Click and hold the handle
3. Drag up or down
4. A blue line shows where the row will drop
5. Release to complete the move

Note: Reordering only works when no sort is applied. Clear sorts first.

Keyboard Shortcuts

• Ctrl/Cmd + Shift + ↑: Move row up
• Ctrl/Cmd + Shift + ↓: Move row down

Deleting Rows

Single Row

Method 1: Context Menu

1. Right-click the row
2. Select "Delete row"

Method 2: Keyboard

1. Select the row (click checkbox)
2. Press Delete or Backspace

Multiple Rows

1. Select multiple rows using checkboxes
2. Click "Delete" in the bulk action bar

Hard delete

Row deletion in databases is immediate and permanent. There is no trash, no undo dialog, and no restore — once a row is deleted it's gone, including its property history and any uploaded files. Press Cmd/Ctrl + Z immediately if you delete by mistake; if you've navigated away or refreshed, the row is unrecoverable.

Row Details Panel

Click any row to open the Row Details panel on the right side.

What's in Row Details

Property Values:

• All properties displayed vertically
• Easier to edit complex values
• More space for long text

Comments:

• Add comments about this row
• Mention team members with @
• Track discussions and decisions

Activity:

• See who created the row and when
• See who last edited and when
• View change history

Actions:

• Duplicate row
• Delete row
• Open in full page (if available)

History Tab:

• Switch to the History tab in the header to view a full audit trail
• See who changed which property, when, and what the old/new values were
• Filter by specific property
• Revert changes with one click
• See Property History for details

Editing in Row Details

1. Click any property value to edit
2. Changes save automatically
3. Use Tab to move between properties
4. Click outside or press Escape to close

Keyboard Navigation

Moving Between Cells

Key	Action
Arrow keys	Move up/down/left/right
Tab	Move to next cell (right)
Shift + Tab	Move to previous cell (left)
Enter	Edit cell or move down
Escape	Cancel edit, deselect

Editing Shortcuts

Key	Action
Enter	Start editing selected cell
Delete/Backspace	Clear cell content
Ctrl/Cmd + C	Copy cell
Ctrl/Cmd + V	Paste into cell
Ctrl/Cmd + Z	Undo
Ctrl/Cmd + Shift + Z	Redo

Copy and Paste

Copying Cells

1. Select one or more cells
2. Press Ctrl/Cmd + C
3. Navigate to destination
4. Press Ctrl/Cmd + V

Supports:

• Single cells
• Multiple cells
• Entire rows
• Paste into Excel/Sheets and back

Pasting Data

From Excel/Sheets:

1. Copy cells from spreadsheet
2. Click first cell in database
3. Press Ctrl/Cmd + V
4. Data fills in matching the structure

Tips:

• Column order matters
• Property types must match
• Extra columns are ignored

Best Practices

Data Entry

✅ Do:

• Use consistent formatting
• Fill in required properties
• Use select options instead of free text when possible
• Add descriptions in text fields
• Assign owners/people for accountability

❌ Don't:

• Leave important fields empty
• Use inconsistent naming
• Put multiple values in single-select fields
• Forget to save (it's automatic, but check for errors)

Organization

1. Use meaningful values - "Q1 2024 Report" not "Report 1"
2. Keep data consistent - Same format for similar items
3. Leverage properties - Use the right property type for each data type
4. Regular cleanup - Delete old/unused rows
5. Use views - Create filtered views instead of deleting data

Performance

• Large databases (1000+ rows): Use filters to show subsets
• Many properties: Hide unused columns
• Complex formulas: Limit to necessary calculations
• File attachments: Keep file sizes reasonable

Common Workflows

Adding Multiple Similar Rows

1. Create first row with all details
2. Duplicate the row
3. Edit only the differences
4. Repeat as needed

Use case: Adding multiple products with similar properties

Bulk Data Entry

1. Prepare data in Excel/Sheets
2. Copy all rows
3. Paste into database
4. Review and adjust as needed

Use case: Importing customer list, inventory items

Updating Multiple Rows

1. Select rows to update
2. Use bulk actions or
3. Apply filters to show only rows to update
4. Edit each row individually

Use case: Marking tasks complete, updating prices

Troubleshooting

Can't edit a cell?

Possible causes:

• Property is read-only (Created Time, Formula, etc.)
• You don't have edit permissions
• Database is locked

Solution: Check property type and permissions

Changes not saving?

Check:

• Internet connection
• Look for "Saving..." indicator
• Check for error messages

Solution: Refresh page if needed; changes should sync

Can't reorder rows?

Cause: A sort is applied

Solution: Clear all sorts from the Sort menu

Row disappeared?

Possible causes:

• Filter is hiding it
• Someone deleted it
• Moved to different view

Solution: Clear filters, check "All" view, check activity log

Paste not working?

Check:

• Data format matches property types
• You're pasting into correct starting cell
• You have edit permissions

Solution: Paste into Excel first to verify format

Related

• Property Types - Understanding column types
• Views & Filters - Filtering and organizing rows
• Property History - Track and audit property changes
• Row Details - Deep dive into row details panel
• Collaboration - Comments and mentions