valid if - Not able to edit and save the form

[jaichith]

Hi ,

I have used to valid if expression to avoid duplicates in the same column. which has created one more issue that it is allowing to create new entries but when the old entry form is edited and save button is hit, It does not allows to save it and displays valid if error . How to solve this ?

Valid if expression : NOT(IN([_THIS], SELECT(USER ROLE[USER ROLE],TRUE)))

[TeeSee1 · Accepted solution]

This is the valid if for [num_col] which is a simple number column in Table T3.

I have three rows with 2, 3, 4 in their respective [num_col] to start with.

cannot create a new row with 2 in [num_col]

With 1 (no duplicates) , it works.

new row created.

I can edit it and save it

Result.

Somehow you have different conditions than I have.