Skip to content
On this page
Community cover

Tables

Tables are a great way of providing visually structured information without the need for a full database functionality.

Capacities' tables are designed to seamlessly blend into your notes, but with the added flexibility of becoming full objects if you need.

Tables as part of your notes

Creating a table

Similar to other blocks, tables can be created by typing + table or / table.

You will get a basic table created for you with 2 columns and 3 rows.

From here, feel free to change the dimensions. You can click and drag the + buttons that appear to the right of your columns, or underneath your rows.

If you want to adjust both columns and rows at the same time, you can click and drag the + in the bottom right corner of your table.

You can also click and drag columns and rows to reorder them too.

Create and edit table

You can create header columns or rows if that suits your use-case. You do this by clicking on the "option menu" button. This gives you a colored-in background and bold text, to differentiate the header row/columns from the cells beneath them.

Before and after header

Pasting in markdown tables

If you have a standard-style markdown table from a different tool, you will be able to paste this into Capacities and it will transform into the Capacities-style tables.

You can use the arrow keys to navigate through cells in your table.

You can Shift + Click to highlight cells and you can edit the selection from there, such as bulk adding bold or italic formatting to your cells.

Alternatively you can use Shift and your arrows to edit the size of the selection.

You can use Backspace to clear content from cell and Cmd + Backspace (Mac) or Ctrl + Backspace (Windows) to delete whole rows and columns.

Shortcuts

There are also some built in shortcuts:

  • Shift + Enter to add a line break within the same cell
  • Cmd + Enter on Mac or Ctrl + Enter on Windows to create a new row
  • Cmd + Shift + Enter on Mac or Ctrl + Shift + Enter on Windows to create a new column
  • If you have selected a row or a column, use Option on Mac or Alt on Windows with your arrows to move the rows or columns to another position.

The block shortcuts used in text editing also work in tables.

Using your table

Formatting text

The content of your cells works like text blocks you use elsewhere.

You will recognize the menu that pops up when you highlight your text: here you can apply text formatting, link to external content, or link to objects.

Text formatting in table

Formatting the cells

To style the background of your cells, highlight them with Shift + arrows, navigate to the action panel and choose your style from there.

The action panel lets you

  • align your text
  • color the cells
  • bulk add text styles (such as bold or italic)
  • assign number formatting

If you decide you no longer want a style you previously applied, you can open the option menu and click 'clear cell styles'.

Reordering cells

You might want to manually reorder cells, you can do that by clicking and dragging.

Or you might want to sort cells in ascending/descending order. You can do this by clicking on the column menu and choosing the right option for you.

reorder

Linking

Tables are designed to give you another useful view when working with your notes. To make this most effective, it's important that you can link to other objects from your cells.

You can do this with the usual @ or [[]] shortcuts.

Link tables

Turning into objects

Capacities Pro

You might have some tables that are particularly important or useful for use in multiple objects. For these cases, you can turn your table blocks into table objects.

All your table objects will be found in the built-in table object type. Here you can review all the tables you've saved, give them titles, tags, or organize them into collections. Tables can blend in seamlessly with the existing organizational patterns you might have set up.

You can of course embed this table in your other objects.

To turn a table into an object, open the option menu and click 'turn into object'.

turn table into object

Table objects also have a blocks property, meaning you can add notes to the table specifically.

tables with notes

Export

As tables are blocks just like any other, they will appear when you export objects too.

If you just want to export the table, you can export it as CSV from the table option menu:

Export table

If you want to a video introduction to tables, check out this video:

Formulas

Capacities Pro

Take your tables to the next level by adding formulas to your cells or columns.

Tables support a range of formulas such as:

  • sum
  • product
  • average
  • median
  • finding the minimum/maximum values
  • count values
  • rounding values to nearest integer
  • generating a random number

and more...

You can find all supported formulas in the table below.

To begin a formula, go to a cell and type =.

Choose the formula you want to use, and the cells to which to apply it.

Tables with formulas

Column B uses =FLOOR(SUM(B2:B7)) to round down the sum of the total cost of subscriptions if they were all active.

Column D uses =COUNT(D2:D7) to count how many records are between D2 and D7.

Need to create a running total? 🧐

Create a new column for your formula in this case. Read more here.

Formulas and Number Formatting

Number formatting works here too.

For example, you can add the relevant currency into a single cell, a column, or a row by selecting your chosen cells and choosing the relevant format from the formatting menu.

Number formatting with formulas


Supported formulas:

FormulaDescription
ABSGet absolute value
AVGCalculate average of values
CEILRound up to nearest integer
COUNTCount number of values
EMathematical constant Euler's number
FLOORRound down to nearest integer
LOGCalculate logarithm
MAXFind maximum value
MEDIANFind median value
MINFind minimum value
PHIMathematical constant Golden ratio
PIMathematical constant Pi
PRODUCTCalculate product of values
RANDGenerate a random number
ROUNDRound to nearest integer
SIGNGet sign of value
SQRTCalculate square root
SUMCalculate sum of values
TAUMathematical constant Tau

A quick tip introduction to formulas is coming soon!



🤔  Do you find this explanation unclear or feel like something is missing in the docs?

With your help we can make the docs better for everyone. So just let us know, and we’ll improve it ASAP!

📨  Did reading the docs make you think of any product improvements?

Please let us know if you have an idea for a feature, think that something is missing or see a conceptual inconsistency that could be fixed. Just post it on our feedback board and discuss it with us and other users!

Built with ❤️ and ☕️ in 🇪🇺.