Discussion posts and replies are publicly visible
hi jarrods229 ,
I should not display particular row in my grid column if the value is empty/ null . I tried giving this value but still the empty cell is displayed , Please suggest.
a!gridColumn( label: text(date(year(today()), 1, 1), "mmm yyyy"), value:if(a!isNotNullOrEmpty(fv!row.TeamMemberValue),rule!myrule_DisplayCell( CellValue: fv!row.TeamMemberValue ),""), showwhen: if( and(a!isNotNullOrEmpty(fv!row.TeamMemberValue),contains(local!Month,"1")),true,false), ),
Hey Priyanka -
There are a couple different issues with your response here...
Per your question: you're asking about the "showWhen" parameter on the a!gridColumn() component. For a column, you can't use fv!row data to show/hide the column, because for any given column, it'll always be shown/hidden regardless of individual row data. In fact, the fv!row data is not even accessible from the showWhen parameter, for this reason.
In a grid, you can't have some rows "show" a certain column and other rows "hide" it - that wouldn't really even be a grid at that point. The best you can do is show an empty value in that column for that row (which you already seem to be doing), or decide to hide the entire column based on some external factor that you use on-form logic to calculate in advance.
© 2023 Appian. All rights reserved.