Check for Duplicates before starting Workflow

[Kronwied]

Hi everybody,

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,

Max

[SimonMuntz]

In your custom validation use the toLower() function to make everything lower case.

[Kronwied]

Hi,

I don't understand how this will help me?

If I already have "bc" and "Bc" in my list. It's not allowed to add those again. But it's allowed to add "BC" and "bC"

Could you please clarify?

Thx and Best,
Max

[SimonMuntz]

Sorry I misread your scenario.