Hi,
Previously my Hide Column if True formula works in views for displaying on the web. Now that the server is at 6.03 it always hides the column. I am using it to produce XML over the web and hiding non-essential elements of data. The formula is simple @If(PCSurname=“”).
Help?
Subject: Hide Column if True formula in Views
why not just create a view for the XML. It would make the view easier to maintain in the long run.
Subject: RE: Hide Column if True formula in Views
I have but There are some XML tags that need to be hidden if there is no value. For example, … would need to be hidden if addressType=“”. If I add a hidewhen formula for that column and the other columns of address it always hides the values even if addressType=“Residential”.
Help!
Subject: RE: Hide Column if True formula in Views
From the Domino Designer help:…because the formula evaluates when the view first displays, a hide-when formula that matches a certain condition will fail if the condition is met subsequent to opening the view.
Specifically, then, a hide column formula cannot be based on the data in the document. The column will be hidden for all documents, or for no documents; not hidden on one row and visible on another row.
If your view is generating XML, and you want to generate no XML in that column, then you could incorporate the test into the column formula, e.g.
@If(addressType = “”; “”; “<Address addressType="” + addressType + “">”)
BTW I assume that you’re using @ReplaceSubstring in other columns to deal with the issue of quotes and other special characters in your data?