* 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