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?
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
Hi Aleksi,
Sadly, this link is invalid as Google+ is no longer available.
โGoogle+ is no longer available for the consumer (personal) and brand accountsโ
https://plus.google.com/114351284024459899049/posts/7eb2gCsnb27
Thank you.
Hi @Kanha_PM_Office Check out this Thread
Thank you Lynn!
HA! Proof that I am definitely A.D.D : I had done +1 on the initial postโฆ Thanks Aleksi!
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |