Guide › Recipes

Auto-increment

Change a Numbers column by a fixed amount each time a status changes: counters, stock, scores, attempts.

The auto-increment recipe changes a Numbers column by a fixed amount each time a status changes.

Set it up

  1. Add the recipe When status changes to something, auto-increment/decrement Number column.
  2. Choose the status and the label, the Numbers column, the operation and the number.

The operations are addition, subtraction, multiplication, division, remainder and power. For example, add 1 every time the status becomes “Sent” counts how many times an item was sent.

The Numbers column can also be a Mirror column: the number then changes in the connected item, so you can keep a counter on another board.

Auto-increment needs the Pro plan or higher.

Formula or auto-increment?

Auto-increment changes the current value by a fixed step. When the new value depends on other columns, use a formula instead, which can also read and write the same column: {item's Stock} - {item's Quantity}.

Still stuck? Open a ticket or try the formula debugger.