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
HA! Proof that I am definitely A.D.D : I had done +1 on the initial post… Thanks Aleksi!
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
[Valid if expression](https://community.appsheet.com/t/valid-if-expression/13548) Questions
I am using a Valid If expression to flag up a duplicate entry which works great. NOT(IN([PONumber], SELECT(Customer Orders[PONumber], [CustName]=[_THISROW].[CustName]))) The problem I have is if I go back and need to edit the row, the duplicate warning flags up and prevents me from saving any changes. What am I missing?
Thank you Lynn!