Rank: Member  Groups: Registered
Posts: 24 Location: Perth, WA, Australia
|
I want to exclude all records from a filter where a particular field is blank. ie/eg Email field is blank, so filter condition Email Equals Zero. However, when I enter this condition it only seems to work on the the numerical value ie 0 and I still get all the records with the blank field included. How do I exclude such records? |
|
|
|
|
|
|
Rank: Administration  Groups: Registered, Developer, Administrators Posts: 254 Location: Atlanta, GA
|
Right now the only way to do this is to sort by that field and the empty column will show up on the top. We will get this fixed very soon (possibly the next version) Thanks |
|
|
|
|
|
|
Rank: Member  Groups: Registered, Developer Posts: 29
|
Thanks for your proposal to filter fields that are empty. From this release 8.2.1, filtering on empty fields is included. Please try Is Empty or Is Not Empty on fields of type Text. Thanks |
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The OfficeClip Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
