Set via formula

Set a field with a formula

Ingredient Family: setterIngredientsList

Outline Display: Use a formula to set {{columnName}} to {{formula}}

Local scope

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

  • $settables – The set of fields that are available to be set

Settings

Required

  • columnName : column of $settables (type filter: any type)
    The field we want to set

  • formula : formula (returns type of columnName)
    A formula that generates the new value of this field
    Scope: all columns of $settables (reference as [ColumnName], e.g., [Name], [Price])