cancel
Showing results for 
Search instead for 
Did you mean: 
stepg
Nintex Newbie

If parselookup with "like" operator

Jump to solution

Hi,

i got a form from a colleague which is on vacancy.

This form includes a formula like this:

If(parseLookup(uiSession2A) == "Lesson1" || parseLookup(uiSession2A) == "Lesson2"
|| parseLookup(uiSession2A) == "Lesson3",
"Please make sure to select two different Sessions for Session I and II, should this already be the case, please ignore this message.", "")

I have about 20 lessons (and the name is not lesson but a real title). Now i want to achieve a parseLookup like:

If(parseLookup(uiSession2A) like(or match or something) "Lesson*", 
"Please make sure to select two different Sessions for Session I and II, should this already be the case, please ignore this message.", "")

Is this possible?

Thanks in advance

Stephan

0 Kudos
Reply
6 Replies
lakshminarayana
Nintex Newbie

Re: If parselookup with "like" operator

Jump to solution

You can write like these

1. If(contains(parseLookup(uiSession2A),'Lesson'),'Please make sure to select two different Sessions for Session I and II, should this already be the case, please ignore         this message.', ' ')

2. If(startsWith(parseLookup(uiSession2A),'Lesson'),'Please make sure to select two different Sessions for Session I and II, should this already be the case, please ignore     this message.', ' ')

0 Kudos
Reply
stepg
Nintex Newbie

Re: If parselookup with "like" operator

Jump to solution

Great. Thanks for your help.

Can i also make else statements?

If 

else

or 

if

if

else?

Gets a bit complicated but i would rather only use 1 calculated value instead of 3.

0 Kudos
Reply
lakshminarayana
Nintex Newbie

Re: If parselookup with "like" operator

Jump to solution

Yes you can also make else statements. Try it out.

0 Kudos
Reply
stepg
Nintex Newbie

Re: If parselookup with "like" operator

Jump to solution

I tried it like this:

Formula Builder

If(parseLookup(uiSession2C) == "I'm the trainer of one of those sessions","", "Please make sure to select two different Sessions for Session IV and V, should this already be the case, please ignore this message.")
Else If(parseLookup(uiSession2C) == "Taskforce", "A participation is only possible, if you received an invitation by E-Mail. Should this be the case, please select the same Session for Session IV, otherwise your participation won´t be possible.", "")

But when i try to open the preview it just shows a blank screen.

0 Kudos
Reply
lakshminarayana
Nintex Newbie

Re: If parselookup with "like" operator

Jump to solution

If(startsWith(parseLookup(uiSession2),'Lesson'),'text1', If(startsWith(parseLookup(uiSession2C),'Session'),'text2'),' ')

Replace 'Lessson' and 'Session' with your matches and also replace 'text1', 'text2' with your text information.

Reply
Highlighted
stepg
Nintex Newbie

Re: If parselookup with "like" operator

Jump to solution

Thank you for your quick help. This worked. Now i don't have to use "rules" to hide if something other is selected.

0 Kudos
Reply