Solved: Controlling unique values, not a key - Page 2

raketa · 02-09-2021 10:43 AM

There is a table with the key “uniqueid (” UUID “)”.
This table has two text columns (not a key), the contents of which must be unique within this table.
What is the best way to do the uniqueness check at save time?

Steve

Try:

ISBLANK(
  FILTER(
    "this-table",
    AND(
      ([this-column] = [_THISROW].[this-column]),
      NOT([_ROWNUMBER] = [_THISROW].[_ROWNUMBER])
    )
  )
)

with appropriate replacements for this-table and this-column.

View solution in original post