Hi ... i would like to conditionally hide a column in a table if the value for that column in the first row is null. I can see that there is a control to put a formual in to conditionally hide/show but not sure what formula to write (i can't work out how to reference the row1 cell for that col.
In my case, the table is called table3 and the column is called sub4
i want to have a piece of simple logic that evaluates as TRUE or FALSE if the row1 value in the col called sub4 is null.
Any help appreciated
Hey Bricesm!
You should apply a transformer to your query and do this in Javascript, and only return data relevant to your table.
If you still need the original data for other purposes, you can always make a Transformer Query for this table specifically.