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! Go to Solution.
Try:
ISBLANK(
FILTER(
"this-table",
AND(
([this-column] = [_THISROW].[this-column]),
NOT([_ROWNUMBER] = [_THISROW].[_ROWNUMBER])
)
)
)
with appropriate replacements for this-table
and this-column
.
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?
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |