When managing contact list views you will need to utilize the filter tool which gives you a great amount of flexibility when filtering contact records. You may filter data by any built-in field or custom field. You can add any number of filter criterions. There is no limit.
After clicking 'Edit' on the List Filter section while creating, copying, or editing a list view, you will be presented with the filter tool.
The filter gives you a number of options depending on the type of field selected:
Regular Text Field
You can define a keyword term that is:
- equals (exactly matches) the field value
- does not equal the field value
- starts with a specific value
- ends with a specific value
- contained within the field value
- is not contained within the field value
or without a keyword:
- is empty (there is no value for the field)
- is not empty (there is a value for the field)
Special Text Field
There are some special fields which contain compound filters, which includes name and address.
In these cases, you can choose to ignore one aspect of the field (e.g. the title, first name, last name, and middle name) and only filter on one of more aspects of this compound field (e.g., where the suffix contains 'CPA' or nickname equals 'tiny')
When adding a Status filter you can choose to include those contacts currently assigned to a certain status or those contact current NOT assigned to a certain status. Since a contact can only have one status at a time, when selecting multiple statuses from the list, it will return contacts that have any one of the selected statuses. For example, if you were to set a match type of 'equals' and check both Active and Banned checkboxes as in the example above, the system would return all contacts who's status is either equal to Banned OR Active)
You may also set a filter to return all contacts whose status does not equal one or more status types. For example, if you set the match type to 'does not equal' it would only return contacts whose status was neither Banned nor Active.
You may choose those fields whose date value is on or after a specific date or a relative date. A specific date is where you define an exact year, month, and day. A relative date is a value relative to the current date. The options include:
- one year ago
- three months ago
- one month ago
- one week ago
- one week from today
- one month from today
- three months from today
- one year from today
- last year (calendar year)
- last quarter (calendar quarter)
- last month
- last week
- this year (calendar year)
- this quarter (calendar quarter)
- this month
- this week
You may also choose those records with a given date field whose date value is before a specific or relative date. For example, to return only those contacts whose status date is from the beginning of the month to today, you could define a filter where:
- The date is 'On or after this month' and 'Before today'
You can also set the Match Type to "Is Empty" to return all those records with no value in a particular Date Field.
The birth date field has a special filter where you simply filter by the contact's age in years from the current date. The 'Match Type' options are as follows:
- on or before
- on or after
- is empty
- is not empty
Then you set the 'Years Ago' value. So in the example above we are looking for those volunteers whose birthdays are on or before 18 years ago from today.
Along with filtering on built-in fields, you may also set filters on all custom fields you create and activate for your organization. These will have similar properties as listed above where you may filter on text, dates, numerical data, or data from a list field.
Applying the Filter
When you have completed setting the filter elements or selected the saved filter you want to add, click 'Add' button (). The filter element will now appear in the list above with a blue 'x' to the right. If at any time you want to remove a filter element, just click .
You may set an overall "Match Type" on a series of filter criterion, where you can decide to show records that match 'Match All' (the record would have to meet all filter criteria) or 'Match Any' (the record only has to meet one of the filter criteria). For instance if you were to have three filter elements:
- A contact's last name starts with 'A'
- The contact has an 'Active' status
- The status date is on or after last month and before tomorrow.
Setting the match type to 'Match All' would add all contacts whose last name starts with the letter 'A' AND has an 'Active' status AND the status date is within the last month.
Setting the match option to 'Match Any' would add all contacts whose last name starts with the letter 'A' OR has an 'Active' status OR the status date is within the last month.
Check either 'Match All' of 'Match Any' to set the overall filter match type.
Finally, click 'Save' to save the filter settings.