I have a very simple form where the user puts in his/her initials. Let's say "BC".
The process behind only allows that every initial must be single use. So it's not allowed that User #2 also inputs "BC".
I'd like to do a autmatic check about this. Problem is that "BC" and "bc" oder "Bc" or "bC" are NOT equal! Which means that Case sensivity means also that it's different.
I tried to make a custom validation using lookup which works good, but this formula won't take case sensivity into account.
Any other ideas how to check this before sending the formular?
Thx and Best,