LogoLogo
  • AppFlowy
    • ⭐Start here
      • Welcome to AppFlowy Docs
      • How to get help
      • Install AppFlowy
    • 🛠️Installation
      • 🖥️System Requirements
      • 💿Installation methods
        • Mac / Windows / Linux Packages
          • Installing on Linux
            • Installing & Setting up Flutter on Linux from Source
        • Docker
    • 🌱Community
      • 🤙Get in contact
      • 📔AppFlowy Mentorship Program
        • Program Guidance
        • Proposal Template
        • Pull Request Template
        • Mentorship 2023
          • Mentee Projects
            • Calendar View for AppFlowy Database
            • Custom Themes
            • Shortcuts and Customized Hotkeys for AppFlowy
            • Table
            • ⭐Favorites
            • Code Block
            • Outlines
            • Importers
            • AI Writers
            • Templates
          • Project Ideas
      • ✍️Write for AppFlowy
        • 📃Drafts
          • [Draft] Use Case: Software Engineer
          • [Draft] Use Case: High School Students
          • [Draft] How to add a new property to appflowy database
      • 🍂Hacktoberfest
    • 🛣️Roadmap
    • 🌋Product
      • 💽Data Storage
      • 🎨Customize and Style Content
      • ⏮️Duplicate, Delete, and Restore
      • 💎Databases
        • 🔢Database Properties
        • 🗃️Manage Properties
      • Ⓜ️Markdown
      • ⌨️Shortcuts
      • 🪄AppFlowy AI
      • 🦙AppFlowy Local AI - Ollama
      • 🎨Themes
      • ☁️AppFlowy Cloud
      • 🧩AppFlowy Plugins
        • Table-view Databases
        • Kanban Board
        • Calendar
        • Auto Generator
        • Smart Edit
        • Code Blocks
        • Math Equations
        • Cover
        • Emoji
  • Documentation
    • 💎Software Contributions
      • 🟢Get started
      • 💀Architecture
        • Frontend
          • Tauri
            • 🗺️CodeMap
          • Web
            • 🌟Design Philosophy
          • Flutter
            • 🗺️Project Structure: CodeMap
            • 🧮Grid
            • ⚙️Setting
          • Inter-Process Communication
          • User
            • User Data
            • Events & Notifications
          • Folder
            • Events & Notifications
          • Document
          • Database View
            • Events & Notifications
            • Grid
            • Calendar
            • Kanban Board
        • Backend
          • Initialize
          • Events
          • Delta(WIP)
          • Profiling
          • Database
        • Domain Driven Design
        • Proposals
      • 🏗️Conventions
        • 🔤Naming Conventions
        • ⌨️Code Conventions
          • 🐦Flutter
        • 🐙Git Conventions
      • 💛Submitting Code
        • 🏦Setting Up Your Repositories
        • ⤴️Submitting your first Pull Request
      • 🤟Coding Standards and Practices
        • 👽Rust Backend
    • 🚀AppFlowy
      • 👾How to contribute to AppFlowy
      • 🏗️Building from Source
        • 🌳Flutter Setup
          • 🐧Building on Linux
          • 🍎Building on macOS
          • 🪟Building on Windows
        • 🌐Web Setup
        • 📡Tauri Setup
      • ☁️Debugging with AppFlowy Cloud
      • 🔁Debugging in VS Code
      • ☎️Translate AppFlowy
      • ❓Troubleshooting
      • 👮‍♀️Licenses
    • 🏍️AppFlowy Editor
      • ⌨️How to Implement Markdown Syntax To Style Text In AppFlowy Editor
      • 🧩How to Create a Plugin for AppFlowy Editor
      • 👮‍♀️Licenses
    • ☁️AppFlowy Cloud
      • 🌈Architecture
      • ☀️Deployment
  • Guides
    • Sync Desktop and Mobile
    • Self-Hosting AppFlowy
      • ☁️Self-hosting AppFlowy with AppFlowy Cloud
      • 🆓Self-hosting AppFlowy for free Using Supabase
    • Import From Notion
  • Blog Highlights
    • 🔮Demystifying AppFlowy Editor's Codebase
  • Handbook
    • Core values
Powered by GitBook
On this page
  • Create a database in table view
  • Rows
  • Add Rows
  • Row Options
  • Customize your table
  • Edit table properties
  • Filter
  • Sort
  • Linked View of Database

Was this helpful?

Edit on GitHub
  1. AppFlowy
  2. Product
  3. AppFlowy Plugins

Table-view Databases

PreviousAppFlowy PluginsNextKanban Board

Last updated 1 year ago

Was this helpful?

A table-view database is also called a Grid. It looks like a classic table but can do more than just rows and columns.

Create a database in table view

There are two ways:

  1. Click on the + icon next to a page, then select "Grid"

  2. Create one inside a page. Type / to open up the menu. Select Create a new Grid

Rows

Every row in a database is a page. You can open a row as a page to edit properties or enter values.

  • Hover over a row and click the Open as a Page button

  • You will see all the properties organized at the top.

    • Click on the property name to edit it or its type.

    • Click in the property field to edit its content.

  • You can also add a new property to your database by clicking + New property.

  • You can perform Delete and Duplicate on the current row.

    • Delete: delete this row

    • Duplicate: duplicate this row

Add Rows

  • Click the + that appears on hover next to any row. This creates a new row below it.

  • Click + New at the bottom of your table to add a new row right there.

Row Options

Click the :: icon that appears on hover to the left of each row to bring up this menu of options:

  • Delete: Deletes the row from your list.

Customize your table

Edit table properties

Add a property

  • Click the + all the way to the right of your last column.

  • Open row as a page and then click +New Property

Filter

View only the rows that fit certain criteria.

  • Click Filter at the top right of your table.

  • Choose which property you want to filter by from the dropdown.

  • Choose the condition you want to use, i.e. is, is not, etc.

  • Define the value of the property you want to see, i.e. a specific tag or contains certain words.

  • You can add multiple filters.

  • Click Filter again to hide or show filters

  • Remove a filter by clicking on the filter and then the : menu

Sort

When you sort your data by any property in Ascending or Descending order, all the data from that row will travel together automatically.

  • Click Sort at the top right of your table.

  • Choose the property you want to sort by, then choose Ascending or Descending. You'll see your table rearrange in real time.

  • You can add multiple sorts to a table, with sorting criteria taking precedence based on their order in the list.

  • Remove sorts by clicking the X icon in the Sort menu next to them.

Linked View of Database

You can add an existing view of database to a page. Type / to open the slash menu.

Select Referenced Grid` to link an existing table-view database.

Property value changes you made to the linked view will sync back to the original database.

Learn more about how to .

Learn more about how to .

🌋
🧩
manage properties
manage properties