* Describe the bug
I have a collection with two fields (TeamRef and UserRef), and I set save mode on submit button “Insert if not exists” and checked out two fields (TeamRef and UserRef) to control and prevent to save that on db.
* Environment
- Database type and version: PostgreSQL 17.2
- Deployment Methods: Docker
- Docker image version:nocobase/nocobase:latest
* How To Reproduce
Expected behavior
when we have one record with same data, must prevent to save new records on db.
Screenshots
Logs
What is the type of the field please?
How is it set in the page save mode?
Please take a screenshot to see
Both (TeamRef and UserRef) data types is bigint. And both fields interface is many to one.
I hope the screenshot is clear.
Both (TeamRef and UserRef) data types is bigint. And both fields interface is many to one.
I hope the screenshot is clear.
Sorry, the form edit relationship field, save mode to set a foreign key is not currently supported, the issue has been logged
Sorry, the problem can’t be solved quickly, but here’s a temporary solution: use the “Assign field values” function of the submit button to assign foreign key fields to relational fields in the form.
Unfortunately, I didn’t understand well how I can prevent duplicate records using this function. I would be grateful if you could guide me further.
