Transformation

Aggregate Array .json

Computes a single summary value from a list — sum, average, smallest, largest, or count.

When to use it: to reduce a list to one number — for example total the values list, or average a price field across a list of products.

Important behavior: count returns how many elements the list has. The other operations read numbers — from Numeric field on each object element, or from each element directly when Numeric field is empty — and skip anything that isn’t a number. If no numbers are found (for anything other than count), nothing happens. The result is written to Result field name.

Calculate Fields .json

Performs one arithmetic operation using one or two number fields (or a fixed number), and writes the result to a field.

When to use it: to derive a value — for example compute total = price × quantity, or add a fixed tax to a subtotal.

Important behavior: the first field must exist and be a number. The second operand comes from Second field name (which must exist and be a number) if you give one, otherwise from Constant value. Dividing or taking the remainder by zero produces “not a number”. The result is written to Result field name.

Concatenate Fields .json

Joins the values of up to four fields into one text field, separated by a chosen string.

When to use it: to build a combined value — for example join firstName and lastName into fullName with a space between them.

Important behavior: only fields that exist and have a non-empty value are included, in order (Field 1 → Field 4). If none qualify, nothing happens. The joined text is written to Result field name.

Convert Field Type .json

Changes a field’s value from one data type to another — text, whole number, decimal, or yes/no.

When to use it: to fix a value stored as the wrong type — for example turn the text "42" into the number 42 so later arithmetic works.

Important behavior: the field must already exist. If the value can’t be read as the requested type (for example "abc" as a number), it is left as text instead. For boolean, true/false — and 1/0 — are recognized. If Field name is empty, or no document is loaded (or it isn’t an object), nothing happens.

Filter Array .json

Keeps only the list elements that match a condition and drops the rest.

When to use it: to narrow a list — for example keep only the products whose category equals books, or only the numbers greater than 100.

Important behavior: the field’s list is replaced by the elements that pass. For a list of objects, Field name picks which field to test; object elements that lack it are dropped. greater-than / less-than compare numerically (values that aren’t numbers never pass); the text comparisons ignore case. If Array field name isn’t a list, nothing happens.

Flatten Array .json

Turns a list of lists into a single flat list.

When to use it: to merge nested lists — for example combine several per-order line-item lists into one flat list of items.

Important behavior: any element that is itself a list has its items pulled up one level; other elements are copied across as-is. The result is written to Result field name (which may be the same field to flatten it in place). If Array field name isn’t a list, nothing happens.

Format Text Field .json

Applies a text tidy-up to a string field — change case, trim spaces, or find-and-replace.

When to use it: to clean a value — for example uppercase a code, trim stray spaces from a name, or replace part of a string.

Important behavior: the field must exist and hold text; numbers, lists and objects are left alone. Find text / Replace with are only used by the replace transformation. If Field name is empty, or no document is loaded (or it isn’t an object), nothing happens.

Group Array By Field .json

Groups a list of objects into buckets keyed by the value of a chosen field.

When to use it: to organize a list by a category — for example group a list of orders by their status.

Important behavior: the result is an object whose keys are the distinct values of Group by field, each holding the list of matching elements. Elements that aren’t objects, or that lack the field, go under a _unknown group. The result is written to Result field name. If Array field name isn’t a list, nothing happens.

To go over the groups, save them with Save group key and put a Repeat for each on that name: each turn is one group, with @name for the group’s name and value for its list of records — so an inner loop over <group>.value walks the records of the group it is on.

Sort Array .json

Reorders the elements of a list — alphabetically, numerically, or by a field inside each element.

When to use it: to order a list — for example sort names A→Z, or sort a list of products by their price.

Important behavior: if every value is a number the list is sorted numerically; otherwise it is sorted alphabetically (ignoring case). For a list of objects, Sort by field chooses the field to compare. The field’s list is replaced with the sorted one. If Array field name isn’t a list, nothing happens.

Transform Array Elements .json

Applies a text transformation to every text element of a list — the list version of Format Text Field.

When to use it: to tidy every entry at once — for example uppercase every tag in a tags list, or trim spaces from each entry.

Important behavior: the transformation is applied to each text element in place; non-text elements (numbers, objects, lists) are left untouched. Find text / Replace with are only used by the replace transformation. If Array field name isn’t a list, nothing happens.