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
Solved! Go 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.', ' ')
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.
Yes you can also make else statements. Try it out.
I tried it like this:
Formula Builder
But when i try to open the preview it just shows a blank screen.
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.
Thank you for your quick help. This worked. Now i don't have to use "rules" to hide if something other is selected.