MRSware Sales and Commissions
  • MRSware
    • About
  • Sales & Commissions
    • Sales Reps
    • Manufacturers
  • CRM
  • Blog
  • Pricing
  • Support
    • Training >
      • Training Classes - MRSweb
      • Training Classes - MRSware >
        • Lesson 1 - MRSware Home Page
        • Lesson 2 - CRM - Companies/Contacts
        • Lesson 3 - CRM - Calendar
        • Lesson 4 - CRM - Journals
        • Lesson 5 - CRM - Tasks
        • Lesson 6 - CRM - Projects
        • Lesson 7 - MREPS - Customers
    • Documentation
    • Integrations
    • Admins
    • Live Service Status
  • Login
  • Free Trial

4 Ways to Filter your Lists, by Example

10/2/2015

1 Comment

 
There are several handy ways to filter the listings in MRSware to show just the information you are interested in at the moment.  

​Here is a little summary of the options in the form of a usage example for each:
1) The Search Menu: Prospects in a particular City (or State)
The main menu's Search selection allows for searching any of the listings in the system.  Select Companies from the Search menu to get a list of Companies matching your search criteria.  In this example, select Type as "Prospect" and enter "Burlington" as the City (and/or "VT" and the State).

2) The Search Table Box: Customers for a Sales Rep
The Search box is found at the top-right corner of each listing.  Entering a search string in the box will filter the listing to show rows where that string appears in any of the columns that are visible.  Go to the Customer listing, in the Search box type "Janet" and hit enter.

3) Filter by Selection Context Menu: Journals for a User
Right-clicking on a cell in the listing will present the context menu options.  In this case we are going to click through to the Filter menu, where we see several options to filter the list by what you clicked on (By Selection), remove from the list everything that matches what you clicked on (Excluding Selection), or remove the highlighted row (Excluding Rows).  In the Journal listing, right-click on the name of a User and select Filter -> By Selection.

4) Filter Expressions: Customers with Sales Last Year > $2000
There is also an advanced pattern matching feature as part of the filters.  This is accessed by right-clicking on the column header and selecting Filter.  Here you will have the ability to type a string to filter by (similar to the Search box, but limiting the search to the column clicked on); as well as the Advanced button, which allows for complex pattern matching using regular expressions (regex).  Go to the Customers listing and right-click on the YTD (2014) column header.  Enter [2-9][0-9][0-9][0-9]* into the simple expression text box (not the Advanced area).

The [2-9] means any of the numbers 2-9, then we have 3 more digits that can be 0-9, and then followed by the star that means any following digits.  This pattern guarantees that we have at least 4 digits starting with at least a 2 as the first, i.e. 2000+.

The Advanced Filter dialog is a very powerful expression builder, capable of doing most anything you might think of, such as "give me all the customers that buy from any of the following combination of lines" (OR matching) and "give me a customers that bought from $500-$2000 in the previous quarter" (AND matching).  The main take away from this article is to know that the ability is there, and ask for help when trying to narrow down your list to accomplish a goal.
1 Comment
Louis
12/22/2018 12:53:53 pm

Building off the last example, I would like to pull up shorter lists for a particular category. This is something you would do for bulk mailings: start with Last Names a-e, then send to f-j, etc. This separates the emails into groups, and allows you to go through the inevitable out of office replies and rejections in smaller groups.

I go to the "Search" menu and select "Contacts". In the Last Name field, enter [a-e], check the Category and other criteria I want, and click Ok. The result is all Contacts starting with a, b, c, d, or e, and also matching the Category I selected. Repeat for other letter ranges.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    Documentation

    ​You will find technical documentation, MRSware instructions, release notes, and general content to help MRSware users through their day on this page.

    Please use the Categories below to find documentation for each area in MRSware.

    ​You may also use the Search field above to look for specific topics. To get a more precise list of articles for a particular menu option, for example, use quotation marks around the text in the Search box, e.g. "bulk assign sales rep".

    Categories

    All
    1
    Android
    Appointments
    Auto-Complete
    Batch Edit/Bulk Update
    Categories
    Contacts
    Customers
    Data Analysis
    Duplicate Removal
    Education Module
    Email
    Email/Spam
    Email Templates
    File Share
    Google
    Hidden
    IMAP
    Installation
    Journals
    Master List
    Microsoft Office
    Mobile
    (MREPS)
    MRSweb
    New MRSware Users
    Outlook
    Payments
    Projects
    Reports/data Analysis
    RSS Reader
    Sales Force Automation (SFA)
    Search / Filter / Sort
    Sync
    Tables / Listings
    Troubleshooting
    Types
    User Manuals
    Video

    Archives

    November 2022
    September 2022
    June 2022
    March 2022
    February 2022
    January 2022
    December 2021
    May 2021
    October 2020
    September 2020
    July 2020
    June 2020
    May 2020
    September 2019
    April 2019
    September 2018
    January 2018
    August 2017
    February 2017
    January 2017
    December 2016
    September 2016
    July 2016
    June 2016
    May 2016
    February 2016
    January 2016
    December 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    July 2014
    June 2014
    February 2014
    October 2013
    September 2013
    July 2013
    May 2013
    April 2013
    March 2013
    February 2013
    November 2012
    September 2012
    July 2012
    June 2012
    May 2012
    April 2012
    December 2011
    November 2011
    October 2011
    September 2011
    August 2011
    May 2011
    April 2011
    March 2011
    December 2010
    September 2010
    July 2010
    May 2010
    April 2010
    February 2010
    January 2010
    December 2009
    November 2009
    October 2009
    July 2009
    June 2009
    May 2009
    April 2009
    March 2009
    February 2009
    January 2009
    October 2008
    September 2008
    August 2008
    July 2008
    June 2008
    May 2008
    April 2007
    September 2006
    August 2006
    July 2006
    June 2006
    May 2006

    RSS Feed

Home | Sales and Commissions | CRM | Blog |​ Pricing | Training | Support | Log In | Free Trial 
sales@MRSware.com     (866)795-8386 x1
Copyright (c) 2002-2023 EYOND, Inc
.
MRSware is an EYOND, Inc. Integrated Solution
made in Austin, TX  USA