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

(Samantha Lim) #1

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) #2

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

(Aleksi Alkio) #3

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