Hi ! I have a table with 2 columns that mus...

(Benoit Gramond) #1

Hi !

I have a table with 2 columns that must be unique.

The instagram name must be unique so I put the formula:

=NOT(IN([_THIS], app_bloggeuses[insta_name]))

It works perfectly, the only problem is that is when I want to edtit, I can not save.

I tried to in Editable_if:

=[_THIS]=""

It does the same.

How could I solve this?

(Aleksi Alkio) #2

Please check this article help.appsheet.com - List Expressions and Aggregates and the section called “Preventing Duplicate Field Values”. List Expressions and Aggregates help.appsheet.com

(Benoit Gramond) #3

@Aleksi_Alkio thanks a lot!