Table

Add a typed grid of line items, scorecards, or checklist rows to one record.

A Table field stores a structured grid inside one record. Define up to 10 typed columns, then add up to 100 rows to each record.

A Table field rendered as an invoice-style grid with a Formula Amount column and a footer total

Use it for invoice items, interview rounds, work-order parts, or another small list that belongs to one record. Each column type controls the input that Blue shows.

Define Columns

When you create the field, add up to 10 columns. Give each column a name and type, then arrange the columns in the required order.

Blue matches saved cell values to a stable internal column ID. Renaming or reordering a column does not rewrite existing row data.

Column Types

Each column is one of the following types:

TypeWhat it holds
TextFree text, up to 2,000 characters per cell.
NumberA numeric value.
DateA calendar date, chosen from a date picker.
CheckboxA checked or unchecked value.
Select (single)One choice from a list of colored options you define.
Select (multi)Any number of choices from your list of options.
CurrencyA money amount in a currency you allow.
FormulaA value calculated from the other columns in the same row (read-only).

Formulas

A Formula column calculates its value from other columns in the same row. Reference a column by name in the expression. For example, multiply Quantity by Unit price to calculate Amount.

  • The result can be a Number or Currency value.
  • Formula cells are read-only and recalculate automatically as the other cells in the row change.
  • A formula can use another Formula column, such as a subtotal in a total calculation.

Column Totals

For a Number, Currency, or Formula column, enable Show column total (sum) in footer. Blue adds the values in that column. For Currency columns, Blue shows a separate total for each currency.

Use totals for values such as an invoice amount or budget total.

Row Numbers

A # column numbers each row in the editor and read-only view. The record’s activity log uses labels such as Row 1 and Row 2 so you can identify the changed row.

Unique Columns

You can require unique values in a Text, Number, Date, Currency, or Select (single) column. Each row in that record must then have a different value in the column.

Examples

  • Invoice or quote: Add Item, Quantity, Unit price, and a Formula Amount column. Show the Amount total in the footer.
  • Interview scorecard: Add one row per round with the interviewer, a colored rating, an advance checkbox, and a date.
  • Packing list: Add each item with its quantity and a checkbox for its packed state.
  • Budget breakdown: Add one row per cost and show the total for the record.
  • Measurements: Store a structured set of readings on one record.

Choose A Table Or Linked Records

Use a Table for a small, self-contained list that belongs to one record. Table rows stay within their parent record.

If you need to filter, group, or report on the rows across many records, store them in a separate workspace. Connect that workspace with Reference, Lookup, and Rollup fields.

Limits

  • Up to 10 columns and 100 rows per record.
  • Up to 2,000 characters per text cell.
  • Up to 1,000 characters in each Formula column expression.