Controlling unique values, not a key

raketa
Participant V

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?

Solved Solved
0 3 381
1 ACCEPTED SOLUTION

Steve
Participant V

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

3 REPLIES 3

Steve
Participant V

Try:

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

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

Steve, thanks!
I’ve tried various options with select () + [uuid] <> [_ THISROW]. [Uuid], but I didn’t get it.
What are the fundamental differences between select () and filter ()? By returning unique values? Those. when I use select () do not duplicate values return?

Top Labels in this Space