Hide read-only column hidden when cell value is null

Question

So I have an interface where in a read-only grid the user can select a specific "event" which then shows another read only grid with that particular events information. I would like a way to hid a column in the break down when the value is null but show when there is a number in the value. 
 For example, in the picture, hide "Energy", "Air Gas", etc

Thank you

Mike Schmitt · Accepted Answer

The reason I didn't suggest that is it looks as if they're checking specifically against a single space character (" ") versus blank. I suppose the view they're referencing for this record type could be set up so that it intentionally populates a single space instead of blank or null under specific conditions, though I guess maybe I should've asked about that assumption.

Mike Schmitt · Answer

Gotcha. For the show/hide columns, you can probably just have the "showWhen" of the individual a!gridColumn() calls check whether that property of the data row is blank? This might depend on where you're storing the data that's used in the row, but this should be possible I'd think.

Mike Schmitt · Answer

I believe you'll need to load the query results into a local variable first. Here when you're doing your "showWhen" check, I don't believe it's actually looking at the resulting data value (much less for a specific row, which in your case will always be row 1). After the data is in the local variable, you'd hardcode your "showWhen" to check that row, i.e. showWhen: local!rowQueryResult[1].energy <> " "

Hide read-only column hidden when cell value is null

Top Replies