I have a list with a column (choices via dropdown menu, 4 choices (Please Select a value/Permanent/Consultant/Contractor)
Created a form, inserted the column and also a panel.
What I would like do is once Permanent has been selected from the dropdown menu it shows the panel.
Created a rule and tried the following rules but none of them are working (also check the community but still not able to make this work)
NameOfTheChoiceColumn != "Permanent", hide checkbox selected
NameOfTheChoiceColumn != 'Permanent', hide checkbox selected
Anyone any idea what I am doing wrong....
Thanks in advance!
Solved! Go to Solution.
It works for me. I have a Dropdown with Numbers 1 to 5. If I select 4, a Panel should be hidden. The rule code is:
-> Hide checked
[DropDownField] is the named Control inserted via the formula generator. It will not work if you write the name of the Control by yourself.
Try to put a calculated value field to your form, with Formula = [NameOfTheChoiceColumn]
You will see what your dropdown really save as value.
If you dropdown is filled by a list lookup, the value should be somehing like "3;#Permanent" instead of just "Permanent".
in the formatting rule, are you sure you're using the Named Control and not the Item Property one? The Named Control has the current value of the form field, the Item Property has the value the field had when the form has been loaded.
Another tip : look at your other rules...if one is badly written, you won't have any error message, but the other rules will not behave correctly.
Ex : if you have a rule with wrong syntax like Test!="Option 2 (forgottent quote at the end)