I would like to enforce a text column uniqueness in a table as part of the form validation.
For the sake of this example I will call the column “Name” and the table “Docs”.
I have a form field that is modifying a “Docs.Name” column.
Everything I have tried where required me referencing “Docs.Name” keeps resulting in a “circular reference” error. Is there another way?
Example of a validation that doesn’t work: