Summary

For some time now, Dynamics 365 CRM users have been able to add columns and amend views in a user-friendly way. Microsoft have continued to add functionality to this feature, and it has now replaced the old way of creating and managing personal views.

This blog will show you how to:

• Add columns
• Edit filters
• Save these changes as a personal view
• Organise this personal view

Adding Columns

There are two buttons available for you on a view, in the top right-hand corner – Edit columns and Edit filters. Let’s firstly explore what the function of the Edit columns button is.

Clicking on Edit columns will allow you to reorganise the order of columns, by dragging them up and down, or removing the column – use the ellipsis menu (3 dots) on each column to do this.

If you want to add columns, you are given the choice of selecting columns in the main table of the view, or columns from related data. This is presented on 2 tabs, Account and Related.

Simply select the columns you want to add, click Close and then Apply.

Changing the Filter Criteria

Now let’s explore what the function of the Edit filters button is.

When you select Edit Filters, the current filters are shown. You can now add rows, remove rows (using the ellipses next to the row) or group rows by applying either AND or OR logic in the group.

When selecting ‘Add related entity’, make sure you select the right field/table combination that you would like to filter on. You’ll then be asked to choose the field on this related table that is to be filtered.

Against the field you can do exact matches or fuzzy logic – this list is dependent on the data type.

For instance, on a date, you can filter for before/after/on a particular day.

Below is an example of a filter that shows:

• active Accounts
• owned by the current user
• where there is a Primary Contact
• who is in either UK or USA

Creating a Personal View

When a view has been amended, the result is displayed with a little * against the view’s name, as illustrated in the image below.

To create a personal view, simply select the down arrow and click on:

• Save as new view
• Save to existing view (if you are amending a personal view)

Organising your Views

You can now de-activate or hide your personal views with a further option to sort your views alphabetically, System before Personal or Personal before System, as shown in the image below.

The major benefit behind this change is the ability to manage your views more effectively.

Additional Information

Use this link to find a series of pages on the Microsoft site regarding this topic

Further Information

If you have any questions about this or need assistance, then please contact the GCC Group Support Team on 0345 260 1151 or servicedesk@gccgroup.co.uk

Microsoft Dynamics 365 CRM

Microsoft Dynamics 365 CRM is a comprehensive customer relationship management software, used by small medium & enterprise sized businesses, to give you and your team the power to drive sales growth.

Connect your sales, marketing, and service teams with Microsoft Dynamics 365 CRM – breaking down any data silos.

Dynamics 365 CRM offers a choice of role-based CRM modules: sales, marketing, customer service & field service – simply choose which modules are needed for your business.

Speak to us today to find out which Microsoft 365 applications could be deployed in your business.