I am trying to add a filter into a Card View that allows me to filter out or select items in a specific column that are blank. The system was able to generate the filter, but in “For This Data”, I have to choose one. I want to be able to choose that in a filter on the screen.
When I use the built-in filter, if I leave it blank, it shows all the results. If I type blank, it gives no results. Would there be a way to have a drop-down for options to choose from? I am not a programmer by any means and have been trying to figure out most of this through a lot of trial and error. Any insight would be helpful and great!
Thanks, @Syamsudin. The article didn’t answer my question, but I found a temporary solution by choosing the selected slice, which only gives me one option. I was looking to filter between the two of them or to choose something different via a filter like the one attached.
The only issue with this is I am looking for rows of data where a specific column is blank (which the slice delivers), but the only way to split between the two is to go into the developer portal and make the change on the backend.
You could add a button that opens the same view (Inventory Card?) using the LINKTOFILTEREDVIEW() function. For the filter expression, use the same expression you’re currently using for the slice.
It seems like I don’t have many other choices. I don’t really want to add a button that duplicates the Inventory Card, but just showing filtered data. It seems a bit of a redundant button. But it could be a work around.
Are you using the dashboard view type? If so, it usually doesn’t appear. The filter (triangle) only appears if you expand it (desktop). However, if you’re using a cellphone, rotate your cellphone to horizontal, then expand it, and the filter (triangle) will appear. If it’s checked in the Show and Search sections, there may be certain criteria for the data to be visible only to recommended users.
I think adding a column with Yes or No fixed this. The column itself is redundant (Sold - yes or No), but it makes the filter work without getting an error when searching for the blank cells. That’s what I was trying to do initially.
