when a user is trying to insert an item that already exist in the list - I want to know about it and an email will be send to me. so I want to write a caml query that will contain the value the user trying to insert in the list and will compare to other items in the list. the query:
<Where> <Eq> <FieldRef Name='Name' /> <Value Type='Text'>[The value the user insert in the list]</Value> </Eq>
but how can I insert to the value of what the user wrote?
is this possible? how? thank you!