Formula fields stay 0 in Sub-table Inline Edit but work in normal form and popup edit

English Forum Issue Report
1

* Describe the bug

Formula fields inside a one-to-many relation (Purchase Bill Lines) displayed as Sub-table Inline Edit always return 0.

The same formulas work correctly:

  • In a normal form
  • In popup edit mode for the subtable row

So the issue appears only in inline editing mode of subtable.

* Environment

  • NocoBase version:** v2.0.25
  • Database type and version:** PostgreSQL 16
  • OS:** Windows
  • Deployment Methods:** Docker
  • Docker image version:** nocobase/nocobase:latest-full
  • NodeJS version:** N/A (Docker)

* How To Reproduce

  1. Create a collection (e.g. Purchase Bill Lines)

  2. Add fields:

    • Quantity (number)
    • UnitCost (number)
    • Tax (number)

  3. Add formula fields:

    • Subtotal = Quantity * UnitCost
    • TaxAmount = Quantity * UnitCost * (Tax / 100)
    • Total = Quantity * UnitCost * (1 + Tax / 100)

  4. Create another collection (Purchase Bills)

  5. Add one-to-many relation to lines

  6. Display lines as Sub-table (Inline Edit) inside the form

  7. Add a new record and enter values

Result:

  • Formula fields stay 0

Additional check:

  • Change subtable to popup edit → formulas work correctly
  • Use normal form → formulas work correctly

Expected behavior

Formula fields should calculate correctly in Sub-table Inline Edit, same as in normal forms and popup edit mode.

Screenshots

(attach your screenshots showing inline = 0 and popup = correct)

Logs

No errors in logs.

2

Hello, this is a known defect. I’ll fix it.