I want to hide column if value equals blank

Sol_Eskenazi · 05-29-2021 06:51 AM

Hi everyone -

I am a new user, and I would like to understand how I can hide a column when the value = blank. Step-by-step guidance would be highly appreciated.

Thank you!

takuya_miyai

Hi @Sol_Eskenazi

It can be hidden with Show_if.
The ISBLANK expression can be used to check if value is blank.

takuya_miyai

@Sol_Eskenazi

I just noticed that by default, AppSheet does not show column if the value is blank.
In other word, does it look the way you want it to by default?

Sol_Eskenazi

@Takuya_Miyai

Thank you for your response! Please see below for what is happening (columns Deposit and Service Fee). I would appreciate any additional guidance on how I can hide the values.

user6

@Takuya_Miyai

I’d like to receive an answer

Did you find a way to do it …

That it does not display a column that is empty of data

???

takuya_miyai

@user6

I don’t think so.

Steve

Not possible.

takuya_miyai

@Sol_Eskenazi

In Table View Type, columns cannot be hidden by Value status.
This is because if there is even one Value in the column, it has to be displayed.

If you really need to do this, you may be able to create two Slices and use them differently depending on the status of the column.
However, this would be a tricky implementation and is not recommended.

Sol_Eskenazi

Thank you @Takuya_Miyai. This is very helpful.

Pointer

Using slice can be an alternative.

user6

There is no way to say
When there is no data in the column the column will not be displayed at all
(Hide automatically)

There is no such way ???

JLC_Online

Hi, I solved creating an Slice of the table that i want filter and using the field: Row filter condition= ISNOTBLANK([the element that you are evaluating that contains the blank value])

JLC_Online

This is the image to explain it better