Zen and The Art of Searching for What is not There.

We recently added the ability to search for blank values in the Query search. In response to several requests, you can now choose 'Is Blank' in the operators for select fields. The example below finds contacts with no First Name.

You can also search for non blank values. For example, if you wanted to find contacts with email addresses you could search for 'contains' @. There is not a way to do this for First Name or Last Name or Company.   Now to find all contacts with any value in select fields, you can select the operator 'Is Not Blank'. The example below finds contacts with any First Name that is not blank (null or null string, '').

When using the Is Blank/Is Not Blank operators, you should leave the string blank. (There is a red x over the first name string above.) This lets the query know that you are searching for blank values.

This will add more power and flexibility  to the Address Two query tool.

Happy Searching.

Google Docs Size Limits and Workaround

Google Docs has long been our preferred method for storing files related to AddressTwo accounts.  But, you might find that on occasion, the file-size limitations of the Google API prevent you from storing large files (over 10mb) on an Account in AddressTwo.  Fortunately, there is a simple workaround.

First of all, since the file-size limit is only imposed on 3rd party applications like AddressTwo, this means that you can indeed still upload the file directly to Google Docs.  To do this, go to docs.google.com and log in.  You can place the file wherever you choose, but AddressTwo defaults to placing uploaded files in the "AddressTwo_Projects" folder. 

Once uploaded, wherever you upload it, you can then link this file back to the desired AddressTwo account using the "link existing file" link.