This has worked in the past, but today when I tried to hide views unless they were needed, it suddenly can’t find the column, even though the column name has shown up in the sample formula’s. I tried ISNOTBLANK([Product]), but can’t
Look at the yellow bar at the top.
You can’t consider any value from any column on this expression.
There are ways to make an expression that doesn’t require any database info, like Context().
You could use expressions that get the columns from anywhere like Table[Column] but I doubt you would need that.
In other words, what you are trying to do is not possible
1 Like
It is possible 
but he has to think and restate his rule to himself clearly in plain language.
1 Like
I know, but I doubt he actually needs that.
You could have something like:
IN(0<>0, Table[Yes/No])
On places where rows are not available but it’s kinda niche case
I’m not sure I understand this expression. What I meant is that he could make use of a specific value of “Product” in a certain row, but the expression has to tell which one.
I have a program that has a list of Transfer Requests. Each Business branch location (9 of them) can have up to four Transfer requests per week. I would like to hide the Transfer requests that have not been filled out. I have used this code on another program in the past which hid the menu items that were blank. However, I cannot get it to work with this program.
If you want to hide the row, it’s quite easy. There are Slices for that.
Slices: The Essentials | AppSheet Help Center
Slice Row Filter Conditions | AppSheet Help Center
What you are trying to do on the OP is hide the View but there are going to be a lot of rows and each one can have different situations (some of them with black columns) but you can’t compromise the whole view just for some rows. That’s why those expressions are not evaluated in the context of a row.
As we talked with @Joseph_Seddik , there are ways to do that, but I doubt you need it
1 Like
Thanks for your response. It’s not that I have to have it, I was just wanting to make the menu less cluttered with items that did not need to be shown, until they did needed to be shown.
1 Like
When do you need them to be shown?
If someone fills out the Transfer Request, even if it is only one item, then it should show up in the menu.
You could make it using a Slice and a show if with
ISNOTBLANK(SLICE[ID])
1 Like
Thank you very much, that does indeed work. I’m fairly new to programming and have learned quite a bit about Appsheet as I have messed around with it. I am also currently trying to learn Java and will probably get into C++.