Forum Discussion
SharePoint Form Conditional Formatting
Hi bryanfrumkin220 I have checked your case, and it looks like there is no information about the additional field of the lookup column in the form context. Maybe you can compare a value of the default lookup column property?
Maybe you can compare an value of the default lookup column property?
Hi Michael, the content from the lookup column is coming from this column $Code_x003a__x0020_Name
I am just looking to hide this column when $Code_x003a__x0020_Name is null; moreover, when $RealtyGroupInformation is null
The column $Code_x003a__x0020_Name is a Calculated column, by the way.
What formula do you think i could use for my case?
I also compared it against a value and it still isn't working properly
=if(substring([$Code_x003a__x0020_Name], indexOf([$Code_x003a__x0020_Name], ';#') + 2, 1000) == 'All: BHHS - Alliance', 'true', 'false')
I had the lookup value as All: BHHS - Alliance from Code:Name, and it is still not displaying
bryanfrumkin220 Ok, I get it. I tested a case similar to yours, and it looks like the multi-valued lookup field is not working. The value used in the formula should be $RealtyGroupInformation, but as you already know, when the lookup is multi-valued, there is no possibility to save the formula. In the console, I can see a message stating that the field type is not supported.
When I change the lookup setting to be a single valued, then the code works
=if(substring([$RealityGroupResources],indexOf([$RealityGroupResources],';#')+2,1000) == 'All', 'true', 'false')I need it to be multi-valued, for this use case.
Also, when I use the internal name of the lookup code that I am referencing, it allows me to save the formula in the conditional formatting pane=if(substring([$Code_x003a__x0020_Name], indexOf([$Code_x003a__x0020_Name], ';#') + 2, 1000) == 'All: BHHS - Alliance', 'true', 'false')But, yes you're right, it won't allow me to save the formula when I am referencing the lookup columns name.