Skip to content
Sign up

Databases and views

Databases you can see as a table, a board or a gallery

Type /database and Folevi adds a collection to the page: rows that are pages, with properties like a status, a date, a price or a person. Show the same rows as a table, a kanban board, a gallery of cards or a month calendar, and let formulas work out the rest.

Start writingRead the docs

Every plan, including Free.

Rows are pages, with properties

Every row is a page. Open it and write in it like any other page. Properties hold its details, and each one has a type: text, number, checkbox, date, select, multi-select, URL, person, relation or formula. A relation links a row to other pages, picked with a search.

A collection holds up to 40 properties, 2,000 rows and 20 views.

Table, board, gallery and calendar

Every view shows the same rows in its own way, and a collection can have several views side by side.

  • Table: rows and columns, with a summary row for counts, sums, averages and more.
  • Board: a kanban board with a column for each option of a select property. Drag a card to another column to change it.
  • Gallery: a card for each row, with the row’s theme as its cover.
  • Calendar: rows on a month grid by a date property. Drag a row to another day to change its date.

Each view keeps its own filters (up to 20), sorting (up to 5 rules) and the properties it shows.

Formulas

A formula property works something out for every row from the row’s other properties, like Price * Qty or IF(Done, "Yes", "No"). You can also write prop("Price"). Formulas use the same functions as table formulas, among them IF, ROUND, SUM, CONCAT, TODAY and DAYS, and numbers can show as currency or a percentage. The editor suggests property names and functions as you type and previews the result on the first rows. With Foli AI on, describe what you want and it writes the formula.

Charts and export

A chart block can use a collection as its source, grouped by one of its properties and counted or summed, and it follows the collection as it changes. Export any view as CSV or Markdown, or copy it as a Markdown table. The export has what the view shows, with its filters and sorting.

Plans

Every plan, including Free.

Compare plans

In the docs

Blocks and slash commands

Questions

How do I add a database in Folevi?
Type /database on any line. To start with a different view, type /gallery, /kanban or /calendar instead. You can add more views later.
Which property types are there?
Text, number, checkbox, date, select, multi-select, URL, person, relation and formula.
Can I use formulas?
Yes. A formula property can name the row’s other properties, like Price * Qty, and use functions such as IF, ROUND, SUM, CONCAT, TODAY and DAYS. With Foli AI on, it can write a formula from a description.
Can I edit a database offline?
Yes, for collections you’ve opened before on that device. You can change values, add and delete rows and properties, and change views. The changes sync when you’re back online.
Can I bring in a database from Notion?
Folevi imports the ZIP from Notion’s Markdown and CSV export. Pages keep their nesting, and databases come in as tables.

All features

Start with one note.

The Free plan has no time limit. New accounts get Pro AI free for 7 days, with no card.

Start writingSee pricing