Filter out empty fields
I want to send a group email to all members of my club. I do not have all their emails so I would like to exclude records with an empty email field. I have found the expression ( = null or! ) which returns those fields that are empty but I want an expression that will filter and return the records that contain an email address.
in table view you can left-click on the column header of the email-column and then choose "Send Mail...". Ninox ignores empty fields.