The title of my question may not be worded quite as it should but.
I have an inventory app where some items I will be deleting as I go along marked as Depletedโฆ
I would like the main page [Log] to not show items that have been marked as โDepletedโ
I have put the following in the UX [Log] view under Display, Show If
SHOW_IF Status <> โDepletedโ
It shows below: (โSHOW_IF Statusโ) is not equal to (โDepletedโ)
The main Log page still shows item that have been depleted.
Is there a way I can have the main page not show these items?
I have another view where I can see all the items I have marked as Depleted.
TIA
Solved! Go to Solution.
Well, I found that rather than state what I did not want it to show, using
CONTAINS ([Status], โGoodโ)
Now only shows the items in the main view marked as Good.
For some reason I also had to change my Depleted slice to
CONTAINS ([Status], โDepletedโ)
to only show items that have been removed.
Thank you for your suggestion, I have it working as Iโd like now.
Placing it in the view definition affects whether the view itself is shown or not. I donโt think thatโs what you want.
Instead, you want to create a Slice and place in the Row Filter condition your expression.
Then change your view to use the Slice in its โFor this dataโ selection.
I put the same condition in a new slice โLogโ
SHOW_IF Status <> โDepletedโ
Directed the view to use the Log slice but it still shows the Depleted items in the main view.
Is this not the right condition to use?
Well, I found that rather than state what I did not want it to show, using
CONTAINS ([Status], โGoodโ)
Now only shows the items in the main view marked as Good.
For some reason I also had to change my Depleted slice to
CONTAINS ([Status], โDepletedโ)
to only show items that have been removed.
Thank you for your suggestion, I have it working as Iโd like now.
Sorry, I didnโt take your text literally as the full expression. What you wanted was:
[Status] <> "Depleted"
If there are leading or trailing spaces then it wonโt match properly so you would need to account for that by using a CONTAINS() or a TRIM() function. TRIM would look like this:
TRIM([Status]) <> "Depleted"
Thank you, I will remember that for future reference.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
18 |