Elementium Sign in
Contents

Data tables · Step

Find rows

The rows of a table whose value is, contains, or is more or less than something.

Basic plan table.find

In a flow

“When a button is clicked, find rows.”

/team red → Find rows in profiles where team is red → Format each.

What it does

The rows of a table whose value is, contains, or is more or less than something. It's a step: it runs when the white wire reaches it, then the flow carries on from its Then pin. It gives 3 values later steps can use. Find it under Data tables in the palette.

When to use it

Use it to keep rows of data, like a spreadsheet: the rows of a table whose value is, contains, or is more or less than something.

When not to

If nothing should change in Discord, a value node or a check is lighter.

Typical wiring

Sockets: settings you can wire

Match Text

What to compare with, like red. Variables allowed.

What goes there: Type it in the side panel, or wire in text. e.g. Hello there

If it's empty: Optional. Left empty and unwired, the step runs without it.

Connects fromA member's variablesAccept applicationAdd a Notion pageAdd a Trello cardAdd an emojiAdd to number in objectAdd up timesAdd working daysand 844 more

Most rows Number

The most to give back.

What goes there: Type it in the side panel, or wire in a number. e.g. 42

If it's empty: Optional. Left empty and unwired, it uses 25.

Connects fromA member's variablesAccept applicationActive membersAddAdd a forum tagAdd a labelAdd a row to a Google SheetAdd a staff noteand 500 more

Values it gives

Rows List

The rows, each an object with its key as _key. e.g. [{"_key": "123…", "level": 3}]

If it's empty: Empty when the step didn't make one (it stopped early or was skipped); steps reading it get nothing.

Connects toAdd onboarding questionAdd to listAdd up timesAutoMod: add or remove allowed wordsAutoMod: add or remove wordsAutoMod: block wordsBar chartBest by a fieldand 88 more

Keys List

Their keys. e.g. ["123…"]

If it's empty: Empty when the step didn't make one (it stopped early or was skipped); steps reading it get nothing.

Connects toAdd onboarding questionAdd to listAdd up timesAutoMod: add or remove allowed wordsAutoMod: add or remove wordsAutoMod: block wordsBar chartBest by a fieldand 88 more

How many Number

How many matched (of up to 2000 rows). e.g. 4

If it's empty: Empty when the step didn't make one (it stopped early or was skipped); steps reading it get nothing.

Connects toAccount ageActive membersAddAdd answer to formAdd soundboard soundAdd timeAdd to a counterAdd to a leaderboardand 718 more

Often next

Related in Data tables

Wires and sockets · Data values · Plans