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 |
---|---|
33 | |
31 | |
30 | |
19 | |
18 |