Collection Sync From Database coverting formulae field to float

English Forum Issue Report
1

* Describe the bug

Under Collection if there is a formula field and you click “Sync from Database” button under Collection Name >> Configure Fields, it changes the formula field to Field Type = float and Field Interface = integer. After this, any new record created in the collection comes with blank value for such formula field. I had to manually edit the field type and interface in postgres table (via backend) and then edit the field once again to refresh to make it work.

* Environment

  • NocoBase version: 2.0.38
  • Database type and version: PostgreSQL 18
  • OS: Linux
  • Deployment Methods: Docker
  • Docker image version: nocobase/nocobase:2.0.38-full
  • NodeJS version: v24.15.0

* How To Reproduce

  • Create formula field in a Collection
  • Click “Sync from Database” button from Collection Name >> Configure Field page
  • The formula field changes to Field Type = float (from formula) and Field Interface = integer (from Formula)

Expected behavior

There should be no affect on the formula field

Screenshots

Logs

2

Thank you for reporting the issue. Please wait while we fix it.

4

The bug has been fixed. Please upgrade to the latest version and check if the problem is resolved.Back up your database before upgrading.

5

Thanks for the update
I’ve tried running it, but the formula for the Boolean field type isn’t displaying as it should