List Manager Tutorial

These two column types are read-only, computed values — nothing is entered by the visitor; the value is worked out from the other columns each time the list is shown.

Calculated Query

Write a small SQL expression that returns one value, referring to the current row’s columns — e.g. qty * unit_price, or a sub-select that counts related rows in another table.

Calculated PHP

Write a PHP snippet that receives the row as $row and returns the value — e.g. return $row['first_name'] . ' ' . $row['last_name'];. Use it for formatting, conditional labels or anything SQL cannot express.

Both can be marked Exportable and shown in any layout with ##column##; neither is stored, so they always reflect the latest data.

One of the column types on the Fields / Columns screen. The type sets how the column is shown in the list and how it is edited in the add/edit form. See them all together in the Field Types Showcase.