Skip to Content
OrbixDocs
Databases & canvas

Properties, Relations & Formulas

Add custom columns to your databases, connect related tables two ways, roll up progress automatically, and calculate live values with formulas.

Properties are the columns of your database. They give every item structured details like a due date, owner, status, or price that you can filter, group, and chart.

Click + at the right end of a table (or inside any open item) to add, rename, hide, or change a property anytime.

Common property types

  • Status, Select & Multi-select: Track workflow stages (To-do, In progress, Complete) or organize items with color-coded tags.
  • Numbers & currencies: Format numbers as plain counts, currencies ($, €, £, ₹), or percentages (with an optional progress bar inside the cell).
  • Dates & people: Assign teammates, set single deadlines or start-to-end date spans, and track automatic Created and Last edited times.
  • Text, checkboxes, files & contact info: Add notes, checkboxes, uploaded images and files (which can also appear as Gallery and Board card covers), URLs, emails, and phone numbers.

Connecting two databases (Relation)

Use a Relation property when items in one database belong to items in another, like connecting Tasks to Projects, Invoices to Clients, or Bugs to Releases:

  1. Add a new property and choose Relation.
  2. Pick the database you want to connect to (you can even pick the same database to track things like Blocked by).
  3. Turn on Two-way relation so the link appears in both places automatically. Connecting Redesign homepage to Spring Launch adds it under Spring Launch too, and updating either side updates both.

Summarizing connected items (Rollup)

Once two databases are connected with a Relation, a Rollup column pulls summary numbers from those linked items automatically:

  • Track completion: Show a live % complete bar on each Project calculated from the status or checkboxes of all its linked Tasks.
  • Count items: Count how many open bugs, attendees, or deliverables are attached to a row (Count all, Count unique, Count empty, Count not empty).
  • Total or average numbers: Calculate Sum, Average, Min, Max, or Range across linked budgets, hours, or scores.

Formulas

A Formula column calculates a value from other fields on the same row. Reference any column with prop("Column Name"), use everyday math (+, -, *, /) and comparisons (==, !=, >, <, and, or, not), or combine built-in functions:

# Score tasks by Impact divided by Effort
if(prop("Effort") > 0, round(prop("Impact") * 10 / prop("Effort")), 0)

# Calculate profit margin percentage
if(prop("Revenue") > 0, round((prop("Revenue") - prop("Cost")) / prop("Revenue") * 100), 0)

# Build a clean summary label
concat("[", upper(prop("Status")), "] ", prop("Title"))

Available formula functions

What you want to doFunctions
Conditions & blank checksif(condition, whenTrue, whenFalse), empty(value)
Numbersround(n), floor(n), ceil(n), abs(n), sqrt(n), pow(base, exp), min(...), max(...)
Textconcat(...), upper(text), lower(text), len(text), contains(text, search), replace(text, find, newText), slice(text, start, end)
Dates & conversionstoday(), now(), tonumber(value), tostring(value), format(value)

Showing database totals inside a regular note

Want to display a live number from a database right inside a memo or project brief? Type /formula on any page to insert a live Formula Card that updates automatically whenever your database changes.

On this page