Using Basemind

Databases & tables

A database is an application inside a workspace that contains one or more tables. Each table has fields (columns), rows and views.

Creating a database

  1. Sidebar → + New → Database.
  2. Enter a name and click Add database.

Right-click (or use the ⋯ menu of) a database in the sidebar to rename, duplicate, move to trash, export, or take a snapshot (a restorable copy of the whole database).

Creating tables

Under a database click + Create table and choose:

  • Start with a new table – an empty table with a primary field.
  • Import a file – CSV, TSV, XLSX, JSON or XML. You can choose the separator and encoding, whether the first row is a header, and preview the result before importing.

You can also paste data: select a cell in an empty table and paste rows copied from a spreadsheet. New rows are created automatically.

Rows

Action How
Add a row Click the empty row at the bottom of the grid, or + in Kanban/Gallery.
Edit a cell Select it and start typing, or press <kbd>Enter</kbd>.
Expand a row Click the expand icon, or press <kbd>Space</kbd> on a selected row.
Copy / paste Select a range and use <kbd>Ctrl/Cmd+C</kbd> and <kbd>Ctrl/Cmd+V</kbd>. Pasting beyond the last row creates rows.
Delete Right-click → Delete row, or select several rows and press <kbd>Delete</kbd>.
Undo / redo <kbd>Ctrl/Cmd+Z</kbd> and <kbd>Ctrl/Cmd+Shift+Z</kbd>.

The expanded row also shows comments and the row history (who changed what, and when).

Relations between tables

Use a Link to table field to connect rows, for example each Deal to a Company. Basemind creates the related field in the other table automatically. Then use Lookup, Rollup or Count fields to pull values across the relation. See Fields & formulas.

Import and export

  • Import into an existing table: table ⋯ → Import file and map the columns to existing fields.
  • Export: table or view ⋯ → Export to CSV, Excel or JSON. Exporting a view respects its filters, sorts and hidden fields.
  • Export workspace: workspace ⋯ → Export data creates a zip file that can be imported on another Basemind server.

Templates

/template/<slug> pages show ready-made databases and applications. Click Use template to install one in a workspace.

Tips

  • Keep one table per real-world “thing” (Customers, Orders, Products) and connect them with link fields rather than repeating data.
  • The primary field (first column) is what linked rows display. Make it a meaningful name or a formula such as concat(field('First'), ' ', field('Last')).