Hillnote Logo

Database

Collections, Hillnote's databases, are organised folders where every row is its own page and the columns are that page's properties. Open any row to write notes inside it. On disk, a collection is a folder with one Markdown file per row, and each file's YAML header holds that row's values, so other apps and AI agents can read it too. A collection can show its rows in several ways, called views.

A row of the Roadmap collection open as its own page, with its properties (Status, Owner, Priority, Start, Due and Effort) above the notes.

Collections suit up to a few thousand rows. For big tables of plain data, use a sheet (see Sheets for big tables below).

Creating a collection

To create a collection, click + (Create new) in the sidebar. Under Organised Folders, choose New collection, or open Templates and pick one: TaskList, Calendar, Blog or Map. Type a name and click Create. Manage Columns opens so you can set up your columns straight away.

The sidebar's Create new panel, with New collection and the Templates list (TaskList, Calendar, Blog, Map) under Organised Folders.

A blank collection starts with Title and Tags, and its dialog is called New Table. The templates come ready for their job:

TemplateStarts with
TaskListStatus, Priority and Due Date; opens as a board
Calendarstart and end dates, Category and Recurring; opens as a calendar
BlogAuthor, Status, Tags and Cover Image; adds board and gallery views
MapLocation and Category; opens as a map

Columns

Once you create a collection, the next step is defining the columns you'd like to track across your rows. Click the gear (Manage columns) in the toolbar. This opens Manage Columns, where you can add, edit, reorder or delete columns. Use the arrows next to a column's name to move it, or click Add Column to add a new one.

Manage Columns adding a column, with the Type list open on Text, Number, Select, Multi-select, Date, Date & Time, Checkbox, URL, Email, Person and Status.

Every column has 3 values.
Name: what the column is called
Type: the kind of value it holds
Default Value: an optional value filled in on every new row

Types of columns

There are 15 types of columns.

  1. Text
  2. Number
  3. Select: choices with colours
  4. Multi-select: choices with colours
  5. Date
  6. Date & Time
  7. Checkbox
  8. URL
  9. Email
  10. Person
  11. Status (only 1 allowed per collection)
  12. Recurring (only 1 allowed, and only once the collection has a Status column)
  13. Location: a place, coordinates or a maps link
  14. Image: a cover for gallery and board cards
  15. Formula: worked out from other columns, or by AI

Special column settings

Some column types have extra settings to help manage how they are tracked.

Status
As you add status options, you can give each one a state: Normal, Done or Archive.

  1. Normal: treated like every other choice.
  2. Done: rows with this status count as completed and show struck through. This helps in tracking end dates, reminders, etc.
  3. Archive: rows here get less emphasis. On a board, archive columns fold into a stack you can expand.
Pasted image

Date
Date columns can be given the Start Date or End Date role, with the calendar button next to them in Manage Columns. Calendars and gantt timelines use these roles. Each role can go on only one column per collection.

Pasted image

Recurring
If a collection has a Status column, you can also add a Recurring column. It sets up tasks that repeat, like a weekly review, and it's set per row. Click a task's cell in that column, then Set recurring.... Pick a Frequency and how often it repeats, then choose what to Reset status to. Next reset shows when it happens, and you can change it. On or after that date, finished tasks go back to that status and get their next date.

A Studio chores collection with a Recurring column: Weekly trail review shows Weekly, and its editor is open with Frequency set to Weekly, Repeat every 1 week, Reset status to To Do and a Next reset date.

Formula columns

Choose Formula as the column type, then pick a mode:

  • Formula: a calculation such as {Price} * {Qty}, with column names in braces. Use + - * /, & to join text, comparisons such as = and <>, and functions such as SUM, ROUND, IF, CONCAT, TODAY and DAYS. Show as and Decimals format the result.
  • AI formula: describe the calculation in words, then click Generate formula.
  • AI answer: a prompt run once per row, like Summarize {Notes} in one sentence. Answers are saved and can be edited. Turn on Fill new rows automatically, or hover a cell and click refresh (Regenerate with AI) to run it again.

Formula results update live and aren't saved in the files. In a collection they can't be filtered or sorted. In a sheet you can filter them (see Sheets for big tables below).

Once a collection has an AI answer column, an AI columns button appears next to the gear in the toolbar. Its Fill empty cells in … item fills every empty cell of that column in one go. For more ways to use AI with your rows, see AI while you write.

A Formula column's editor: the Formula, AI formula and AI answer modes, {Price} * {Qty} with the column chips to insert, a preview of 140.00, and Show as Number with 2 Decimals.

Views

Views allow you to see and organise the same rows differently. Each view keeps its own filters, sort and hidden columns. To add one, click + next to the view tabs, pick a type (Table, Board, Gallery, Calendar, Chart, Gantt, Dashboard, Map or Custom), name it and click Create View. Drag the tabs to reorder them. Every view except the first has a ⋯ menu with Edit View (its name, type and grouping) and Delete View.

The + menu next to the view tabs, listing Table, Board, Gallery, Calendar, Chart, Gantt, Dashboard, Map and Custom.

Clicking a card, event, bar or pin opens that row side by side. On board and gallery cards, ⋮ ▸ Open opens the row's page instead. Every view is live: when another app or an agent edits the files, the view updates by itself. Hillnote currently supports the following types of views.

Table view

A grid of your rows. Click a cell to edit it, click a header to sort (click it again to reverse the order), and drag a column's edge to resize it. Long tables show 200 rows per page.

Boards

A board (kanban) sorts cards into columns by a Select, Multi-select or Status column. Drag a card to another column to change its value, or click New item in a column to add a row with that value set. Row Group By (Optional) in Edit View adds swimlanes. Cards show checklist progress and comment counts.

Cards without a value sit in a No Value column. In the desktop app, a card's ⋮ menu also has Delegate to agent, to hand the card to an agent, and Schedule move…, to move it to another column at a set time. See Agents in your workspace and Automations.

The Roadmap board grouped by Status, with the Weather alerts card being dragged out of Planned and the In progress column highlighted as the drop target.

Calendar views

A calendar puts rows on their dates, using the column with the Start Date role, or else the first date column. Today and the arrows move through time, and Month, Week and Day change the range (Day needs a Date & Time column). Drag an event to move it, or its edge to change its length. Click a day, or drag across days, to add a row with those dates. Recurring rows repeat, and the colour button colours events by a column.

A month calendar for November 2026 with roadmap rows spanning from their start to their due dates, coloured by owner.

A gallery shows rows as cards. With an Image column, the Cover menu sets the cover's shape: Square, Landscape, Portrait or No cover.

Gantt

A gantt view draws each row as a bar from its Start Date to its End Date column. Drag a bar to reschedule it, or an edge to resize it. A row with one date shows as a milestone. Drag the dot at a bar's end onto another bar to link them. View options turns on Progress fill, Dependencies and Group by, and Day, Week and Month zoom the timeline.

You set the two roles in Manage Columns (see Date under Special column settings above). A row with no dates gets an empty lane: drag across it to schedule the row. To add a row, drag in the bottom lane or click New row. To unlink two bars, click the arrow between them, then × (Remove dependency). Progress fill comes from the row's status, or from the checklist in its page.

A Gantt view of the roadmap with bars from start to due date, progress fills, a Launch day milestone and two dependency arrows.

Map

A map pins rows from a column of places: city names, addresses, "lat, lng" coordinates or Google Maps links. Choose the Location column, a Map style (Colorful, Minimal, Detailed or No labels) and Color pins by. A chip counts the rows pinned and not found; hover it for tips. Click Drop pin, then click the map to add a row at that spot (Esc cancels), and Fit zooms to show every pin. Looking up place names needs the desktop app, and a map shows up to 5,000 rows.

A Map view of the Trail guide with pins coloured by Difficulty, a legend, and the chip reading 7 pinned and 1 not found.

Charts and dashboards

A chart view draws a bar, horizontal bar, line, area, pie, donut or scatter chart. Set Group by:, an optional Split by: and a Value:, such as a row count or the sum or average of a number column. When you group by a date, Bucket: groups it by Day, Week, Month, Quarter or Year. Options sets sorting, the top groups and stacked or grouped bars. A chart counts up to 200 rows, one page of results.

A dashboard is a grid of Chart, Stat, Upcoming dates and Recent documents widgets. Click Add widget or Add starter widgets, and drag a widget's header to move it. Hover a widget to Resize, Edit widget, Duplicate widget or Delete widget. Each widget can have its own filters and reads up to 10,000 rows.

A Dashboard view with a Total rows stat, a Status breakdown bar chart, an Upcoming: Start list and a Priority mix donut chart.

Custom views

A Custom view shows your rows in an HTML tool of your choice: a card deck, flashcards, a leaderboard, anything. Click + next to your views and choose Custom. Then pick one of Your tools, start from Templates (such as Card deck, Chart or Flashcards), or describe what you want in Build with AI and AI builds it for the collection's columns.

The view's filters, search and sort apply to the tool too, and edits the tool makes (moving a card, changing a status) save straight back to your rows. If a tool asks for other data, click Allow or Deny: tools only reach the data you allow. Change tool, Edit with AI and Reload tool are there later. You can also start from Tool Forge: Link data picks the collection or sheet a new tool is built for. Custom views need the desktop app. More on making tools is in Tools.

A Custom view named Cards showing the roadmap rows as cards from the Card deck template, with Grid and Deck modes and the tool's actions in its header.

Filters in views

Click Filter, then pick a column, a condition and a value, such as Status is any of In progress or Due is before Today. The conditions depend on the column's type:

  • text: contains, is, is empty and more
  • numbers: >, ≥, < and ≤
  • dates: is before and is after, with shortcuts such as Today, Tomorrow and In a week
  • choices: is any of and is none of
  • checkboxes: Checked or Unchecked

Add more with the dashed Filter chip, and Clear all removes them. Hide picks the columns the view shows, and the search icon finds rows by text.

The first view's filters are temporary: click Save as View to keep them as a new view. Other views save their filters automatically.

The filter bar with two chips, Status is any of Planned, In progress and Due is before Nov 30, 2026, with the Due chip open on its date shortcuts, and Hide, Clear all and Save as View beside them.

Adding a row

Click the New Row button in the top right of the collection (New in other views) to open Add New Row. Fill in the fields, or write a sentence under Describe, like "go for a run at 6am every day", and press ⌘↵ (Ctrl+Enter on Windows) or click Review. AI fills in the fields for you to check, trying a free on-device engine first. Then click Add Row and you are done!

The Add New Row dialog after Review, with Title, Status, Owner, Priority, Start and Due filled in from a sentence and Add Row ready.

You can also click any table cell to edit it, or hover a title and click View to open the row side by side, or the arrow beside it to open the row's page. On a row's page the columns show as properties, and a property you add there becomes a column. To delete rows, select them and delete them together.

Sheets for big tables

A sheet keeps all its rows in one CSV file with a fast local index, so it stays quick however large it grows. Its rows are plain data, with no page each, and the whole sheet syncs as one file. Use a sheet for big tables, exports, logs or anything from a spreadsheet, and a collection for up to a few thousand rows that each need notes. You can switch later (see Switching between a sheet and a collection below).

The Trail sightings sheet with its Table tab counting 5000 rows above the Date, Trail, Park, Species and Count columns.

Creating or importing a sheet

To make one, click + (Create new) in the sidebar, then Sheet (CSV) under Datasets. Type a name and click Create, or click Start from a CSV file…. You can also drop a .csv or .tsv file onto the window. Imports take CSV, TSV and Excel (.xlsx, .xls) files up to 100 MB.

Hillnote guesses each column's type from the data, and each Excel worksheet that has data becomes its own sheet. Import Files, in the menu under the workspace name, brings spreadsheets in as sheet unless you switch them to as markdown (see Files panel and importing).

The New Sheet (CSV) dialog with the name Gear inventory, a Start from a CSV file… button and Create.

Adding rows from another file

In an open sheet, click Import CSV and choose a file. Then choose where each of its columns goes: an existing column, ➕ Create new column, or Skip.

Turn on Update existing rows when row ids match to update the rows the sheet already has instead of adding them again, for example from a copy of its data.csv that you edited elsewhere. Left off, every row is added as a new one.

The Import CSV dialog mapping each column of June sightings.csv: three to existing columns, Ranger to Create new column and Notes to Skip, with Update existing rows when row ids match turned on.

Editing, sorting and filtering

Sheets work like collection tables:

  • Click a cell to edit it. New Row opens Add New Row, which can fill the fields from a sentence (see Adding a row above).
  • Filter adds the same filter chips as collections, and in a sheet you can filter formula columns too.
  • Sort orders the rows by a column, and Clear sort resets it.
  • The search icon finds rows by text.
  • Select rows to delete them. This can't be undone.

Manage columns offers the collection column types plus Document Links, which link a row to pages in your workspace with @. Formula columns work here too.

The Trail sightings sheet filtered to Species contains sheep, 424 rows, sorted by Count from high to low.

Views on a sheet

Sheets offer the same filters and views as collections. To add a view, hover the view tabs, click + and pick a type in New View. Deleting a view never deletes rows, and Custom views need the desktop app. Calendar, gantt and map views show the first 5,000 rows, so add filters to narrow down a bigger sheet.

The + menu beside a sheet's view tabs, listing Table, Board, Gallery, Calendar, Chart, Gantt, Dashboard, Map and Custom.

Editing data.csv outside Hillnote

A sheet's rows live in data.csv in the sheet's folder, so you can open it in a spreadsheet app or let an agent edit it, and Hillnote merges the changes row by row. When it does, the sheet shows Merged changes from data.csv.

If a row changed in both places, the file's version wins and a banner offers Review. In Review Conflicts, choose:

  • Use mine to take back your edit
  • Restore my row if the file deleted a row you'd edited
  • Delete it again if you'd deleted a row the file kept

To reload the file by hand, click Reload from data.csv in the toolbar.

A sheet showing the banner Merged changes from data.csv — 1 updated after the file was edited outside Hillnote.

Some quick tips

Embedding a collection within a document

You can embed a collection in a page (Pages) by typing @ or [[, picking the collection and clicking Insert Database. This adds an interactive embed within the document, with its view tabs and rows. Its ⋯ (Show controls) bar adds search, filters and sorting and, for AI answer columns, AI columns ▸ Fill empty cells in ….

The Roadmap collection embedded in a page under an In flight heading, with its view tabs and rows inside the document.

Switching between a sheet and a collection

A collection's ⋮ menu in the sidebar has Convert to Sheet, and a sheet's has Convert to Database. Notes inside row pages aren't carried over to a sheet, and the old files stay as backups.

Converting a sheet turns each row into a page, and its data.csv stays as a backup. So to make a collection from a CSV file, create a sheet from the file first (see Creating or importing a sheet above), then convert it.

Using triggers to start workflows from your collection

Triggers can act when a row is added, when its status changes or when a field changes. Click the workspace name at the top of the sidebar, then Triggers, and click New trigger. A trigger can start an agent CLI on your computer, send the event to a plugin, or fire a Hillnote routine on the server. More in Automations.