Values · Value
Join lists by a field
Match two lists of objects on a field and merge each pair: members with their scores.
list.join_by
In a flow
“Works out join lists by a field whenever a step wired to it needs the answer.”
[{id, name}] + [{id, score}] → [{id, name, score}]
What it does
Match two lists of objects on a field and merge each pair: members with their scores. It's a value node: no white pins, it works out its answer when a step wired to it needs it. It gives 2 values later steps can use. Find it under Values in the palette.
When to use it
Use it when a step needs a value worked out first: match two lists of objects on a field and merge each pair: members with their scores.
When not to
For a value that never changes, type it into the setting instead of wiring a node.
Typical wiring
Sockets: settings you can wire
- List List
-
The list to use, like the Parts from Split text.
What goes there: Type it in the side panel, or wire in a list. e.g. Hello there, and more like it
If it's empty: Optional. Left empty and unwired, the step runs without it.
Connects fromAI check the answersAlarms that are dueBest by a fieldChange list atCheck for a lineClear a leaderboardCollect messages until doneColour gradientand 176 more
- Other list List
-
Objects to look in.
What goes there: Type it in the side panel, or wire in a list. e.g. Hello there, and more like it
If it's empty: Optional. Left empty and unwired, the step runs without it.
Connects fromAI check the answersAlarms that are dueBest by a fieldChange list atCheck for a lineClear a leaderboardCollect messages until doneColour gradientand 176 more
- Field Text
-
The field both have, like id.
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, it uses id.
Connects fromA member's variablesAccept applicationAdd a Notion pageAdd a Trello cardAdd an emojiAdd to number in objectAdd up timesAdd working daysand 844 more
Values it gives
- Joined List
-
Each of the first list's objects with the matching fields added. e.g. [..]
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 87 more
- Matched Number
-
How many found a match. e.g. 2
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