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
- Scroll to the bottom of your database
- Click the "+ New" button
- A new row appears with empty cells
- Click any cell to start entering data
Method 2: Keyboard Shortcut
- Navigate to the last cell in the last row
- Press Enter
- A new row is created below
- Focus moves to the first cell of the new row
Method 3: Context Menu
- Right-click any row
- Select "Add row below" or "Add row above"
- New row appears in that position
Method 4: Duplicate Row
- Right-click a row you want to copy
- Select "Duplicate row"
- A copy appears below with all the same values
- Edit as needed
Tip: Duplicating is great for creating similar entries quickly!
Editing Cells
Basic Editing
- Single click on a cell to select it
- Double-click or press Enter to edit
- Type or select your content
- Press Enter to save and move down
- Press Tab to save and move right
- 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
- Hover over a row to reveal the drag handle (⋮⋮) on the left
- Click and hold the handle
- Drag up or down
- A blue line shows where the row will drop
- 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
- Right-click the row
- Select "Delete row"
- Confirm if prompted
Method 2: Keyboard
- Select the row (click checkbox)
- Press Delete or Backspace
- Confirm if prompted
Multiple Rows
- Select multiple rows using checkboxes
- Click "Delete" in the bulk action bar
- Confirm deletion
Warning: Deleted rows cannot be recovered! Make sure you want to delete before confirming.
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)
Editing in Row Details
- Click any property value to edit
- Changes save automatically
- Use Tab to move between properties
- 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
- Select one or more cells
- Press Ctrl/Cmd + C
- Navigate to destination
- Press Ctrl/Cmd + V
Supports:
- Single cells
- Multiple cells
- Entire rows
- Paste into Excel/Sheets and back
Pasting Data
From Excel/Sheets:
- Copy cells from spreadsheet
- Click first cell in database
- Press Ctrl/Cmd + V
- 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
- Use meaningful values - "Q1 2024 Report" not "Report 1"
- Keep data consistent - Same format for similar items
- Leverage properties - Use the right property type for each data type
- Regular cleanup - Delete old/unused rows
- 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
- Create first row with all details
- Duplicate the row
- Edit only the differences
- Repeat as needed
Use case: Adding multiple products with similar properties
Bulk Data Entry
- Prepare data in Excel/Sheets
- Copy all rows
- Paste into database
- Review and adjust as needed
Use case: Importing customer list, inventory items
Updating Multiple Rows
- Select rows to update
- Use bulk actions or
- Apply filters to show only rows to update
- 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
- Row Details - Deep dive into row details panel
- Collaboration - Comments and mentions