How to omit empty records in a formula field
Ninox Profile

Choice fields allow you to use "(not empty)" to omit empty groups on a table. Is there a way to achieve the same thing in a formula field?  I'm using some formula fields as the main sorting device on some views. Depending on values in other fields, it displays "Go for it" O

Ninox Profile

Oops, pressed the enter button!  To continue: the formula field displays "Go for it" or nothing, and when I use it to group records, the top group on the table contains all the records that have nothing returned in the formula field. Would be nice to be able to exclude them from view completely. 

Ninox Profile

= null

 

Nick

Ninox Profile

Well I have the null in the formula ...

if 'MAG STAGE' = 3 or ('WEB STAGE' = 3 or ('APP STAGE' = 3 or ('BEV STAGE' = 5 or ('MAG STAGE' = 5 or ('WEB STAGE' = 5 or ('APP STAGE' = 5 or ('BEV STAGE' = 6 or ('M WRITER' = 2 or ('W WRITER' = 3 or ('A WRITER' = 3 or 'B WRITER' = 5)))))))))) then
text("Go for it")
else
null
end

... but the field still throws up an empty group at the top.

Ninox Profile

In grouped column header type:

!= null

Screen Shot 2018-10-03 at 18.37.30

 

 

Nick

Ninox Profile

Ah, brilliant! Works like a dream. Thanks!

Reply