📄 05 Tables & Repeating Lines

Tables & Repeating Lines

Create fixed grids and data-driven tables for order, invoice, purchase and stock lines.

7. Static tables

Use a static Table when the grid structure is fixed and does not repeat for every one2many row.

  • Set row and column counts.
  • Select an active row or column and adjust its exact size.
  • Use uniform row height when every row should match.
  • Mark a header row, make it bold and set a header background.
  • Control outside and inside border widths, border colour, padding, default alignment, vertical alignment, font and font colour.
  • Type fixed cell text directly.
  • Drop a field onto a cell to bind it. Drop another field to replace the binding.
  • Use Clear field to return a bound cell to editable text.

8. Line-item and one2many tables

One2many tables create a row for every related business line. They are intended for order lines, invoice lines, stock operations and similar datasets. Long tables are split across pages, and headers repeat when a new page is created.

The line-table inspector controls geometry, headers, rules and every displayed column.

Table-level controls

  • Width, row height, header height and maximum preview rows.
  • Header font size, bold state and background.
  • Line colour and thickness.
  • Line style: Grid, Horizontal rows, Outer + horizontal, Header line only or No lines.

Line columns

  • Choose Select field and browse fields on the line model.
  • Use the eye control to disable or enable a column without deleting its setup.
  • Use the delete control to remove a column.
  • Set label, width, padding, alignment, vertical alignment and formatting per column.
  • Image columns can scale the image inside a fixed column with Image size (%).
  • Barcode columns have their own barcode type and cropping controls.
  • Attribute filters can select attribute-specific product information.
  • Sales descriptions can use compact modes and a relative text-size setting.

Computed line columns

Computed columns evaluate once for each line. Use line for the current line and record for the parent document.

line.product_uom_qty * (line.product_id.weight or 0)
line.quantity * (line.product_id.weight or 0)
line.product_id.weight or 0

For calculated weights, set the format to Number and use a decimal override when production precision must be fixed.

Model-specific repeating tables

Line tables are available for Sales Orders, Invoices, Purchase Orders and Stock Pickings. Stock Picking reports can use Stock Move Lines or Operation Lines with product image, SKU, product, quantity, unit, lot and source/destination fields. Sales and Invoice product columns can show the selected product field, a smaller description second line, or description-only output.

Computed line columns

A computed column receives line for the repeating record and record for the parent. Example: line.quantity * (line.product_id.weight or 0). Preview and PDF use the same server-side calculation path.

Column-level controls

  • Field or custom expression, optional product-attribute filter and barcode type.
  • Width percentage, padding, image size percentage and visibility toggle.
  • Font family, weight, size, letter spacing, uppercase, line height and text colour.
  • Grid, horizontal, outer-plus-horizontal, header-only or no-line border mode.

Control reference

The screenshot below shows the repeating-line table inspector controls only.