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
- Sidebar → + New → Database.
- 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')).