Formula
Overview
The Formula component calculates values automatically based on other columns in the same record or data from other features. The result is read-only — users cannot edit formula fields directly.
Writing formulas
Formula types
| Type | Description | Example |
|---|---|---|
| SUM | Add values from selected columns | Price + Tax + Shipping |
| SUBTRACT | Subtract column values | Budget - Spent |
| MULTIPLY | Multiply column values | Quantity × Unit Price |
| DIVIDE | Divide column values | Total / Count |
| CONCATENATE | Combine text from columns with a separator | "FirstName LastName" |
| SUMIF | Sum values from a feature with conditions | Sum order totals where status = "paid" |
| COUNTIF | Count records in a feature matching conditions | Count tasks where status = "complete" |
| XLOOKUP | Look up a value from another feature | Find a client's email by their ID |
| EXPRESSION | Free-form dynamic expression | Complex calculations with custom logic |
| ARITHMETIC EXPRESSION | Visual builder with parentheses and operators | (Price × Quantity) - Discount |
Cross-feature formulas
SUMIF, COUNTIF, and XLOOKUP can reference data in other features:
- SUMIF — Select a source feature, the column to sum, and define filter conditions (e.g., sum all invoice amounts where
clientIdmatches the current record's ID). - COUNTIF — Same as SUMIF but counts matching records instead of summing values.
- XLOOKUP — Specify a source feature, a lookup column (to match against), and a return column (the value to retrieve).
CONCATENATE options
| Setting | Description |
|---|---|
| Campos para Concatenar | Checkbox list of the other columns on the feature. Check a column to include it in the result. |
| Ordem dos campos | Once two or more columns are selected, reorder them with the up/down arrows — this is the order they appear in the concatenated text. |
| Máx. (per field) | Optional character limit for that field's contribution. Leave empty for no limit. When the field's value is longer than the limit, it is cut to that length and suffixed with …. |
| Separador de Texto | Text inserted between each field's value. Defaults to ", " if left empty. |
The limit is applied per field, not to the final concatenated string — each column is truncated independently before being joined with the separator.
For a linked_select field, the limit applies to the resolved label (the display value shown for the link), not to the underlying row ID.
Truncation happens on the calculated value that gets stored: table, search, and export all see the cut text, with … appended. The source column itself is never modified.
Display options
| Setting | Description |
|---|---|
| Render as component | Display the formula result as another component type (e.g., render as a Select badge or Linked Select link) |
| Render component config | Configuration for the display component |
Formula history
OutDo keeps the last 3 formula configurations as history, allowing you to roll back to a previous formula if needed.
In all views, formula fields display their calculated result as read-only text (or as the configured render component).