documentation /ingredient/rowActionsIngredients

Load column from formula

IngredientrowActionsIngredients

A formula to add a new value to the row, which will be accessible to subsequent RowAction ingredients

Ingredient Family: rowActionsIngredients

Outline Display: Add a new column called {{newColumn}} (of type {{newColumnType}}) defined by {{formula}} to the data we’re processing.

Local scope

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

  • $table – The table to act on

Settings

Required

  • newColumnType : type name
    The type of the new column

  • formula : formula (returns type chosen and saved as newColumnType)
    The formula that will provide a value for the new column we’re adding; [Username] is the user running the action
    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 $table (reference as [ColumnName], e.g., [Name], [Price])

  • newColumn : new column (type: type chosen and saved as newColumnType)
    The name of the new variable, must not shadow other names