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!
It can be hidden with Show_if.
The ISBLANK expression can be used to check if value is blank.
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?
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.
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
???
I donโt think so.
Not possible.
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.
Thank you @Takuya_Miyai. This is very helpful.
Using slice can be an alternative.
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 ???
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])
This is the image to explain it better
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |