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
- Add the recipe When status changes to something, auto-increment/decrement Number column.
- 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}.