Working with Lists

Lists Overview

Lists are groups of records that share common characteristics. ClearVantage lets you easily create lists to find the record or group of records you need.

Information contained in ClearVantage is almost always accessed first through a list of records. For example, you may wish to work with a list of individuals who live in a specific state or zip code, or an organization list that joined as members after a certain date. A list may also contain a single record, such as a specific individual. Lists are usually created by searching all records with a certain criterion.

Once a list is created, you can perform many actions to the entire list, several records from the list or a single record. For example, from an individual list you can access an individual's notebook, add individuals to a committee, export the list, or create action items.

You can create a list in ClearVantage with the Quick Find search tool or by creating a query. You can save the search terms used to create the list and have a list that is always updated with the newest information.

Creating Lists by Searching

Note

All "Quick Find" searches use AND between the criteria. For example, if you type "Smith" as the last name and "VA" as the state, ClearVantage will create a list of individuals who are named "Smith" AND who live in Virginia. Only one field is required, however, the more criteria you specify, the narrower your search.

Quick Find

Quick Find is an easy way to locate either a specific record (such as an individual or organization) or a group of records. The Quick Find tool allows users to search a single search criterion or multiple criteria simultaneously.

1. Click on the "Quick Find" button from either an organization or individual list.

   

2. Enter the criteria by which you would like to search in the "Quick Find" search window.

   

3. Click the "Search" button. The Quick Find tool will close and the list will populate.

The Quick Find tool keeps the last criteria used to search. To reset the search form click the "Reset" button at the bottom on the window.

Search For - Individual

At the top of the individual list, there are "Search For" and "Search By" fields. Use these to search by one criterion such as "Last Name" or "Organization".

1. Type the text or code you are looking for in the "Search For" field.

2. Select the appropriate search field from the "Search By" dropdown:

   • Name Find: Searches the last name and first initial of the record.

   • Last, First: Searches the last name and first name of the record.

   • Last Name: Searches the last name of the record.

   • First Name: Searches the first name of the record.

   • Email: Searches the primary email address of the record.

   • Alt. Email: Searches the alternate email address of the record.

   • Member ID: Searches the Individual ID of the record.

   • Organization: Searches the “Organization” field in the individual record.

   • Web ID: Searches the web ID of the record.

3. Click "Go" and the list will populate with the search results.

Example

To search for "Ann Smith" using "NAMEFIND" the search text would be: smitha. To search for "Ann Smith" using "Last, First" the search text should be: smith, ann

Search For - Organization

At the top of the individual list, there are "Search For" and "Search By" fields. Use these to search by one criterion such as "Org Name" or "Org ID".

1. Type the word or code you are looking for in the Search For field.

2. Select the appropriate search field from the Search By dropdown:

   • Org Name: Searches the full Organization Name of the record.

   • Org ID: Searches the Organization ID field in the organization record.

3. Click "Go" and the list will populate with the search results.

Tips for Searching

• Always try searching by different fields (i.e., zip code, email, etc.) if you cannot find the customer you are looking for.

• The percent sign (%) can be used as a wildcard in quick lists. For example, typing WER% finds records for WERE or WERHEIM.

• Lists can be sorted by any of the fields displaying in list results by clicking on the column header or using the arrow to select the sorting direction.

  

Activities Panel

The "Activities" panel is located on the right side of the list results and provides a list of activities that can be performed on each record or the whole list. These activities vary depending on the list or notebook being worked on. Please review the guides for the specific list or notebook for more information.

Activities – Individual List

1. Work With: Select an individual to “Work With”. Once you are working with an individual you can purchase products for them, register them for events, accept their donations, etc.

   

2. Login As User: Login to individual’s member portal. This button needs to be configured for your organization.

   

3. Register: Register the selected individual from the list for an event.

   

4. Purchase: Purchase a product for the selected individual.

   

5. Action: Create action item for the selected individual.

   

6. Meet: Schedule a meeting with the selected individual.

   

7. Email: Send an email to the selected individual.

   

8. Bucket: Add selected individual or the entire individual list to the Activity Bucket.

   

9. Send Email Blast: Send a mass email to all individuals included in the current list.

   

10. Add Individual: Add a new individual to your ClearVantage database.

    

11. Add Contact: Add a quick contact to your ClearVantage database.

    

12. Merge Duplicates: Merge duplicate individuals. For more information on merging duplicate records, go to the ClearVantage Administration User Guide.

    

13. Export: Export the current list of individuals to an excel file.

    

14. Reports: Access reports that populate with information from the current list.

    

Activities – Organization List

1. Work With: Select an organization to “Work With”. Once you are working with an organization you can purchase products for them, register them for events, accept their donations, etc.

   

2. Purchase: Purchase a product for the selected organization.

   

3. Action: Create action item for the selected organization.

   

4. Meet: Schedule a meeting with the selected organization.

   

5. Email: Email the organization’s primary contact.

   

6. Add Organization: Add a new organization to your ClearVantage database.

   

7. Send Email Blast: Send a mass email to all the primary contacts associated to the list of organizations.

   

8. Ind List: Single Org: Click into an organization row to highlight it grey and select this button to open a list of individuals attached to the organization.

   

9. Ind List: Listed Orgs: Open a list of individuals attached to all organizations from the list.

   

10. Merge Duplicates: Merge duplicate organizations. For more information on merging duplicate records, go to the ClearVantage Administration User Guide.

    

11. Export: Export the current list of organizations to an excel file.

    

12. Reports: Access reports that populate with information from the current list.

    

List Editor

All primary lists utilize the list editor interface for list configuration. The list editor allows users to rename, resize, reorder, hide, or lock list columns. Additionally, list activity buttons can also be renamed, reordered, and hidden. Users may elect to save their list configurations just for their own user account, or if they are a role administrator, they may save them for their entire user role.

Note

Role administrators can configure lists for other user roles. Go to the Customizing Layouts user guide for more information.

Ordering Columns

To change the order of columns:

1. Open a list of records. The order of the fields for that type of list are the same regardless of the specific records on the list.

2. Click on the gear icon at the top right-hand corner of the list to open the list editor.

   

3. Under Active Columns, drag and drop the column header in the desired position that you want it to appear in the list. For example, if you want Street Address to appear in the beginning of the list, drag and drop the Street Address field to the top of the list.

   

4. Once you have the columns in the desired order, click the "Save" button at the bottom right-hand corner. Click "Save configuration for user only". If you are a role administrator, you have another option to save to your current user role.

   

Relabel and Resize Columns

To Relabel and Resize Columns:

1. Open a list of records.

2. Click on the gear icon at the top right-hand corner of the list to open the list editor.

   

3. Click on the down arrow to the right of the column header you would like to rename and/or resize.

   

4. You can change the title of the column header in the title field, and you can change the width of the column in the width field. Select Update Column to save changes.

   

5. Once you have updated the desired columns, click the "Save" button at the bottom right-hand corner. Click "Save configuration for user only". If you are a role administrator, you have another option to save to your current user role.

   

Adding and Removing Columns

In ClearVantage Online, you can decide which columns you want to expose in an individual or organization list.

1. Open a list of records.

2. Click on the gear icon at the top right-hand corner of the list to open the list editor.

   

3. If you want to remove a column from appearing in a list, drag the column from the Active Columns section to the Hidden Columns section.

   

4. If you want to add a column to a list, drag the column from the Hidden Columns section to the Active Columns section.

5. Once you have updated the list, click the "Save" button at the bottom right-hand corner. Click "Save configuration for user only". If you are a role administrator, you have another option to save to your current user role.

   

Relabel, Reorder and Hide Activity Buttons

In CV Online, you can decide which "Activity" buttons you want to expose under the "Activities" panel in a list.

To update Activity Buttons:

1. Open a list of records.

2. Click on the gear at the top right-hand corner of the list to open the list editor.

   

3. Find the "Activity Buttons" section in the list editor.

   

4. To relabel an activity button, click on the arrow next to the button you wish to relabel. Enter a new title and click "Update Activity Button".

   

5. To remove an activity button from the "Activities" panel, drag the button from the "Active Activity Buttons" section to the "Hidden Activity Buttons" section.

   

6. If you want to add an activity button, drag the button from the "Hidden Activity Buttons" section to the "Active Activity Buttons" section.

7. Once you have updated the activity buttons, click the "Save" button at the bottom right-hand corner of the window. Click "Save configuration for user only". If you are a role administrator, you will have another option to save to your current user role.

Saved Lists

After generating a list, you can save it. This allows you to locate and open the list without having to re-enter the search criteria. Lists are dynamic, the search criteria remain the same, but the results may differ if the records have changed since you last ran the predefined list.

Saving a List

To save a list:

1. Click on the "Save List" button at the top of the list.

   

2. A window will show with a form to save the list.

   

3. Check the "Subscribe All Users" if you would like all users to be able to see the list. If you want to share the list with only certain users, select their usercd in the "Subscribers" field. If neither are selected, the list will only be visible to you.

4. Click "Save" to create the saved list.

Manage Saved Lists

Saved lists can be managed using the Saved Lists Manager. To access it, click the "Manage Lists" button at the top of the list and the "Saved Lists Manager" window will show.

By default, the list will show the lists you own. To view lists that other users have shared with you, click on the "All Lists" radio button at the top of the list. To find a specific list, you can search for the list by using the "Search" field at the top of the list. You can search by list name, description, or list owner.

Note

Administrators can manage saved lists that are subscribed to all users.

Edit a Saved List

To edit a saved list:

1. Click on the icon in the "Actions" column of the list you wish to edit.

2. A window will show with the list's details.

   

3. Update the list name, description, company, or subscribers and click "Save".

Delete a Saved List

To delete a saved list:

1. Click on the icon in the "Actions" column of the list you wish to edit.

2. A window will show for confirmation.

1. Select "Delete" to delete the record.

Loading a Saved List

To access the list you saved, click on the "Saved Lists" dropdown, next to the "Save List" button, and select the saved list you wish to load. You can also type the name of the saved list and select it when it shows as one of the options.

You can also load a list from the "Saved Lists Manager" window. Open the Saved List Manager, select the list you would like to load and click "Load" at the bottom of the window. The selected saved list will load and populate the opened list.

Exporting Lists

You can quickly and easily export an organization or individual list to an excel document.

To export a list:

1. Create a list of individuals, organizations, or events.

2. Click "Export" under the "Activities" panel on the right of list.

   

3. Select the fields you wish to export. By default, all fields in the table will be selected. To select a subset of fields to be exported, use one of the following methods:

   

   1. Uncheck the fields that you do not want to export by clicking on the check mark to the left of the field name.

   2. Click on the "Select None" button to select only the fields you want to export.

   3. To include "More UDF" profile fields in the export data when exporting from the individual, organization, or event list, click "Show More UDF Fields" on the lower left of the export interface to view the available "More UDF" fields and add them to your export.

      

4. Click the "Export" button in the bottom-right corner of the export screen.

5. Find and open the export file. The list will open in Excel and you can manipulate the columns as needed.