Skip to main content
Nintex Community Menu Bar

Check for Duplicates before starting Workflow

  • April 14, 2020
  • 3 replies
  • 9 views

Forum|alt.badge.img+2

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

3 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • April 15, 2020
In your custom validation use the toLower() function to make everything lower case.

Forum|alt.badge.img+2
  • Author
  • April 15, 2020
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

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • April 15, 2020
Sorry I misread your scenario.