How do I ensure that when people are adding d...

[Samantha_Lim]

How do I ensure that when people are adding data to my list of unique values, an entry is rejected if it is not unique?

Tried the following to a fail:

=[_THIS].[Barcode]<>UNIQUEID()

For some reason appsheet sees my column name [_THIS] as “Barcode”

[Aleksi_Alkio]

You could use an IN expression… like NOT(IN([_THIS],TableName[ColumnName]))

[Aleksi_Alkio]

You could use an IN expression… like NOT(IN([_THIS],TableName[ColumnName]))