Kronwied
Scholar

Check for Duplicates before starting Workflow

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

0 Kudos
Reply
3 Replies
SimonMuntz
Nintex How-To Center Expert
Nintex How-To Center Expert

Re: Check for Duplicates before starting Workflow

In your custom validation use the toLower() function to make everything lower case.
0 Kudos
Reply
Kronwied
Scholar

Re: Check for Duplicates before starting Workflow

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
0 Kudos
Reply
SimonMuntz
Nintex How-To Center Expert
Nintex How-To Center Expert

Re: Check for Duplicates before starting Workflow

Sorry I misread your scenario.
0 Kudos
Reply