Computed field

Set a field to a fixed value that can depend on previous fields

Ingredient Family: formIngredients

Outline Display: A formula for defining {{columnName}} as {{formula}}.

Local scope

The parent slot binds these (look up the slot in the parent to see how):

$parentTable – The table (if any) that this form is based on
$formFieldsTable – A table of form fields that is built up through the sequence of form ingredients

columnName : column of $parentTable or new (type filter: any type)
The column to set
Set ty only when columnName names a new column (not in $parentTable).
formula : formula (returns type of columnName)
The formula that generates a value for the chosen column
Scope: current time as [CURRENTTIMESTAMP], current username as [Username] (only where the handler authenticates: a logged-in page, or the calling user of an MCP tool, including inside its pipeline), all columns of $formFieldsTable (reference as [ColumnName], e.g., [Name], [Price])

default : constant value (type: type of columnName)
A default value for the column if the formula refers to itself
dynamic : constant value (type: bool; required, non-nullable)
Choose True if we should we apply this formula dynamically, updating as the form changes. Choose False if we should apply this formula only on commit.