Appsheet Group Columns show/hide as per selected items

[Sajinjs07]

Hi Appsheet User,

This sample project is about grouping columns. When you select a group from a list, only approved columns will show in form. But problem i am facing here is if data is empty still column name shows in detail form. Does anyone knows how to fix it? Please advise steps to follow. Screenshot below for your reference.

 

 

 

[jaichith · Accepted solution]

I have deployed below expression in your app and it works as per your expectation. 

if(and(
isnotblank([_this]),
CONTAINS(LOOKUP([_THISROW].[option],Setting,name,setting),"Column2")
),
in(context("viewtype"), list("detail","form") ),
if( and(
isblank([_this]),
CONTAINS(LOOKUP([_THISROW].[option],Setting,name,setting),"Column2")
), in(context("viewtype"), list("form")), false )

)

[jaichith]

use this ISNOTBLANK() in column show condition. Show condition can seen column properties.

[Sajinjs07]

Thanks for your reply. I tried this expression. But problem is column8ab shows hiden when i try to view the form. 

 

 

[jaichith · Accepted solution]

I have deployed below expression in your app and it works as per your expectation. 

if(and(
isnotblank([_this]),
CONTAINS(LOOKUP([_THISROW].[option],Setting,name,setting),"Column2")
),
in(context("viewtype"), list("detail","form") ),
if( and(
isblank([_this]),
CONTAINS(LOOKUP([_THISROW].[option],Setting,name,setting),"Column2")
), in(context("viewtype"), list("form")), false )

)

[Sajinjs07]

Thanks Jaichith, you really understood my requirements and result works. 

[jaichith · Accepted solution]

Welcome !... 

[jaichith]

You have used AND , when 2 condition are satisfied or true. The column appears. Check for the values in column which has met the condition. Showif is very simple features. Maximum it won't fail. There may be problem with  expression or values in the column