topic Re: Show/ Hide complete column with 'Null' or 'no Values' in straight Table in App Development

Show/ Hide complete column with 'Null' or 'no Values' in straight Table

santho_ak — Sat, 16 Nov 2024 17:37:41 GMT

Show/ Hide complete column with 'Null' or 'no Values' in straight Table.

Actual :

I am able to hide the 'Salary' column using the condition Count(Salary)>0 or Sum(Salary)>0. (Not sure if it is right but it works)

Que 1: However, I need to hide 'Request Type' column whenever there is no data/ null.

Que 2: Hide 'Request Category' column whenever it is Null (Empty space and '-' as well)

Required:

Anil_Babu_Samineni — Mon, 11 Jan 2021 20:08:54 GMT

Check these

Que 1: However, I need to hide 'Request Type' column whenever there is no data/ null.

- Check "Supress When value is null" is one option

- May be write calculated condition : If(Len([Request Type])>0, [Request Type])

Que 2: Hide 'Request Category' column whenever it is Null (Empty space and '-' as well)

- Enable Calculate condition for Coulmn.If like... If(IsNull([Request Category]), 0,1)

santho_ak — Mon, 11 Jan 2021 20:56:47 GMT

Thanks @Anil_Babu_Samineni . For Que 2, its not working.

Anil_Babu_Samineni — Tue, 12 Jan 2021 08:14:01 GMT

My case it is working, check once