table view with both combo box (selected options and 'empty or null option) in same view
On a table view I have a combo box that I want to filter the view to only a 2 out of say 6 combo options
trouble is that i also want to filter the same view to pick up any empty (null/not selected options) at the same time ie a job that we have yet to give a status to
Ninox at the moment is all or nothing ie selection OR empty which means i am having to run two separate table views
I have tried adding and pointing a formula at the combo to see if that will work but to no avail
Ninox said approx 1 year ago they realised that from a combo point of view the need to allow also selecting NULL but have yst not relased a fix/mod
Has anyone sorted a work around or know a fix ?
thanks
Mel
3 replies
-
Does this expression gives the wanted result?
if combobox !> 0 then "empty"
Steven
-
sorry steven no it does not - id odes something but not what expecting
The issue is Ninox don't let you select a few options from the combo and also empty at same time which is what i need to do
and because it is a combo box they don't let you type in a free filter epression
see below
I can add proofed + In Production
but I need Empty(null) + Proofed + In Production
-
One option if you want to stay in the same table, is to create another field and then sort by that field.
Create a formula field called SortStatus and set it to number(raw(Status)). Raw shows the number of the choice selected, then number converts the number it into a number. I guess you don't need to convert it into a number, but when I didn't I couldn't do <3 or things like that.
Then show that column in your table. Then your blanks now have a number and you can filter.
If this is something you want to see often, then another option is to use a dashboard, then you can create View layout elements to pull out the right data that you can see immediately.
Content aside
- 3 yrs agoLast active
- 3Replies
- 529Views