Enforcing Unique value on form submission

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:

CurrentValue.Not().Contains(List(thisRow.[Pitch Name]))

Hey James! Is this a snippet of a larger formula? Would you be able to share a screenshot of the full formula + the error message you’re seeing?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.