+9
Hi
Ok I want to reveal a panel when I use select "Head Office" in a list Look up.
List Look Up works fine.
This doesn't seem to work. However, when I drag a Choice Drop down on to my canvas and change the above validation rule...then I can toggle hide/show of the same panel.
Is this something to do with my environment or is this more general?
Daniel
Best answer by tbeduneau
View original
+7
Try to add a Calculated Value field, with value = Your lookup control value
You should see that, when selecting "Head Office", the real value is something like "2;#Head Office".
This explains why your test fails : with lookup columns, what you see is not really what you get.
+9
Thomas
I like this approach, unfortunately:
Locations
Location Approvers
Daniel
+6
Hey Daniel,
Thomas wants you to put a Calculated value control on your Nintex form and then configure that control in the way that it shows the value of the Lookup control. When you now select "Head Office" you'll notice that the value isn't "Head Office", instead there's the ID of the element, a semicolon and a hashtag before "Head Office".
If you use the following condition for example, it'll work.
Best regards,
Jan
+9
@thomas @Jan
Thanks very much.... I have had to get up to speed with Nintex on Office 365 very quickly for this demo hence, my confusion as to what calc field you were both talking about 
. I can now see what is in my calc field.
"1; #Head Office" .
I think I can use this "debug" technique elsewhere in the form as I need to extract a name from a drop down and populate a list item people field
Thanks again.
Daniel
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.