Filter out empty fields
I

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.

Thanks

Dave

Ninox Profile

!=null

 

Nick

I

Thanks Nick

T

in table view you can left-click on the column header of the email-column and then choose "Send Mail...". Ninox ignores empty fields.

Unbenannt

Reply