documentation /ingredient/formIngredients

Text block with query

IngredientformIngredients

Display reactive text to the user, using values from a SQL query

Ingredient Family: formIngredients

Outline Display: Display text from a query: run {{query}} and show {{getText}}.

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

Names introduced within this component’s knobs:

  • queryTab – result columns of query (referenceable as a virtual table)

Settings

Required

  • query : SQL query
    the query

    Scope: 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]).

  • getText : formula (returns formatted text; required, non-nullable)
    The text to display. Note that because the output is richtext, any math-like operators, such as IF, must be wrapped in $$…$$.
    Scope: all columns of $formFieldsTable (reference as [ColumnName], e.g., [Name], [Price]), all columns of queryTab (reference as [ColumnName], e.g., [Name], [Price])