0

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.

Thanks

Dave

3 replies

null
    • Nick
    • 6 yrs ago
    • Reported - view

    !=null

     

    Nick

    • info.6
    • 6 yrs ago
    • Reported - view

    Thanks Nick

    • Tacho
    • 6 yrs ago
    • Reported - view

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

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 2692Views