🎲
Random Row
vault.randomThe VaultVaultPulls one row out of a table at random — a random quote, a random winner, a random card from a deck. Filter it to pick only from some rows. Its columns become sparks: {{pick.text}}.
When to use this
- →Want a random item from a list you typed in? That's Random Pick
On the canvas
This is what Random Row looks like when you place it on your flow. Each field below is something you configure in the inspector panel.
🎲Vault
Random Row
vault.randomtablerequired
Pick a table…
filterColumn
Every row
filterOp
select…
filterValue
e.g. {{input.user.id}}
asrequired
pick
found
empty
Config fields
| Field | Type | Req | What it does |
|---|---|---|---|
tablePick a table… | text | yes | Table 🗄️ |
filterColumnEvery row | text | — | Only rows where… 🔍 |
filterOp | select | — | Is… |
filterValuee.g. {{input.user.id}} | text | — | This value |
aspick | text | yes | Save it as ✨ |
Output ports
foundA row was picked
emptyThere was nothing to pick from
📐
In TypeScript, this would be…
Not something you need to write — just a look at what Kitcord does for you.
TypeScript
const pick = await db.get("SELECT * FROM quotes ORDER BY RANDOM() LIMIT 1");
// {{pick.text}} — Picked ✓, or Empty ∅Related pieces
More Vault pieces