🧮

Tally

vault.tallyThe VaultVault

Adds things up across a table: how many rows, the total of a column, its average, lowest or highest. Filter it to tally just one team, one server or one kind of thing. Great for "coins in circulation" or "how many warnings has this person had".

When to use this

→How many rows doesn't need a column — the others do
→Averages are rounded to 2 decimal places
→No rows? Count and Total give 0; the others give nothing

On the canvas

This is what Tally looks like when you place it on your flow. Each field below is something you configure in the inspector panel.

🧮

Tally

vault.tally

Vault

tablerequired

Pick a table…

select…

column

e.g. coins

filterColumn

Every row

filterOp

select…

filterValue

e.g. {{input.user.id}}

asrequired

tally

Config fields

Field	Type	Req	What it does
`table` Pick a table…	text	yes	Table 🗄️
`op`	select	—	Work out ✏️
`column` e.g. coins	text	—	Of column
`filterColumn` Every row	text	—	Only rows where… 🔍
`filterOp`	select	—	Is…
`filterValue` e.g. {{input.user.id}}	text	—	This value
`as` tally	text	yes	Save it as ✨

Output ports

outputThe answer is your spark

📐

In TypeScript, this would be…

Not something you need to write — just a look at what Kitcord does for you.

TypeScript

const { v } = await db.get(
  "SELECT COUNT(*) AS v FROM warnings WHERE user_id = ?", // or SUM / AVG / MIN / MAX
  [memberId],
);
// {{tally}} = v

Related pieces

More Vault pieces

📖Read from Vault ✏️Write to Vault 🗑️Delete from Vault 🔐All-or-Nothing ✋Call it Off ➕Bump a Number 🔎Get One Row 🏆Top List 🥇Find Rank 🎲Random Row 🔁Update Matching ⏳Cooldown

← All Pieces