How to prevent duplicate entries? I have set...

(Christian Farley) #1

How to prevent duplicate entries?

I have setup a valid_if clause to prevent duplicate entries as follows: =NOT(IN([_THIS],SELECT(Users[User Mail],TRUE)))

This works great. Except that if I come back to this row later for further edits and then Save, the rule kicks in and blocks the save.

Any hints?

(Aleksi Alkio) #2

https://plus.google.com/114351284024459899049/posts/7eb2gCsnb27 plus.google.com - TIP OF THE WEEK - Validation Many of you have asked how to add a validation … TIP OF THE WEEK - Validation Many of you have asked how to add a validation … plus.google.com

(Christian Farley) #3

HA! Proof that I am definitely A.D.D : I had done +1 on the initial post… Thanks Aleksi!