Quick View forms are a great way to view information from different entities while remaining on a single record. Quick view forms enable you to surface data from associated entities and display the data in read only mode on the form. This is done through linking the two different entitles together using a lookup field. Below you’ll learn how you can setup your own quick view form in just 3 easy steps.
1. Create a Lookup field
The first step in setting up a quick view form is to ensure you have a lookup field to the entity where the data is stored. If you do not already have a lookup field created, you will need to create one. To do so, go to Settings > Customizations on the navigation bar and select Customize the System.
Next navigate to the entity you wish to add the lookup field to, and thereby surface the Quick View form on. Click the Fields node, and create a new field.
Once you click new, the following pop up window will appear. Indicate a display name and change the data type to Lookup and select the entity you wish to associate to. Once that is done, click save and close.
2. Create a Quick View form
Next, we need to go to the entity the lookup was created for and create the quick view form. Navigate to the entity and go to the form section. Once there click the new button and pick Quick View Form.
This will open the quick form editor window. Here simply drag and drop the fields you wish to display to the form body on the left.
Once the desired fields have been added, click save and then publish.
3. Add the Lookup and Quick View form to a Form
Now that the lookup field and the quick view form have been created, it is now time to add them to a form where you want the associated data displayed. Go to the form you wish to display the quick view form on.
Open the form editor, drag the lookup field onto the form then switch to the insert tab. Here click Quick View form.
This will open the quick view control. From here, give your quick view form a name, select the lookup field you created earlier, pick the related entity, as well as the quick view form you created. Once done click OK.
This will create a field on the form. To apply these changes click Save and Publish on the Home tab.
Below is a preview of the result.
You can now brand your Dynamics 365 environment! Themes allow you to apply your distinct logo and color scheme to your Dynamics 365 environment. Three simple clicks and you are well on your way to a D365 environment with a look all your own.
1. From the Navigation Bar, select Settings
2. Select Customizations
3. Select Themes
Upon navigating to Themes, a few out of the box themes will be available to select and set as the default theme. The default themes cannot be modified, but can be cloned, should you want a head start on designing your theme. Otherwise, you can put your designing skills to the test and get theming.
Start by selecting an out of the box theme and cloning it, or create a new theme record.
Theme colors are defined using hexadecimal codes. You will need to either know the hexadecimal codes you want to use or find a good online resource, such as http://www.color-hex.com.
A fascinating feature is the ability to take a test drive of the User Interface with the newly defined color scheme before it gets released to your organization.
When you are ready to release the new theme, thereby making it the default, you can either select the theme from the Theme view and select Publish Theme, or do the same from within the theme record.
Wouldn’t it simplify things if you could go to one record and see everything you need to see? Ever find yourself heading into a meeting, and wish you could quickly “ramp up” on all interactions with the Customer? Getting the total picture in one place, enabling you to see every touchpoint, this is the benefit that sub-grids afford you.
One of the great things about Dynamics 365 is that it allows you to customize entity forms to display the information most relevant to your business. You will quickly find that providing your users with the ability to see, at a glance, a subset of related records when viewing a lead, contact or account record provides immeasurable value.
For example, your salespeople may benefit from seeing all tasks related to an account directly on the account record. Instead of having to navigate to a separate page or running an advanced find query, you can easily set this up by adding a task sub-grid to the account form.
To add a sub-grid to your account form, open the D365 form editor directly from the account record’s ribbon menu or by opening the general customizations menu, navigating to the account entity forms, and selecting the account main form.
Once you’re in the form editor, select the section that you want to add the sub-grid to, switch to the form editor’s Insert tab, and click the Sub-Grid button.
This will open the sub-grid properties window. The most important part of this window is the data source section, in which you select the records that are to be included in the sub-grid.
In the screenshot below I selected to populate the sub-grid with the account’s related task records, but you can choose any of the account’s related entities. In the data source section, you can also specify the default view that will be used to populate this sub-grid, while the additional options section lets you choose any additional views which will be available, as well as whether or a not a search bar will be included.
When you are satisfied with your settings, click the OK button to insert the sub-grid on your account form. Now, all you need to do is click the Save and Publish buttons in the form editor to confirm the changes to the form. Once this has been completed, you will see the sub-grid displayed on account records.
Ever have the problem of scrolling down a long list of options only to miss what you were looking for? What if there was a way to limit your option choices based on values previously selected? Well now there is!
Dependent options in Dynamics 356 gives users the ability to filter down a long list of option values to just a handful of choices based on previously selected parent fields. This feature dynamically updates the options users see based on pre-set business logic.
Take the following transpiration data model as an example.
Traditional Option Set
Traditional option sets simply display all the options for each field without any consideration for previously selected option values. This method is cumbersome when it comes to long lists and can feel very redundant when looking through lists where some of the options obviously shouldn’t be there based on previous values selected.
In the example below, you will notice that regardless of which Transport Class you pick, you will still be shown the entire list of Transport Type options.
Dependent Option Set
With dependent option sets, Dynamics 365 will automatically exclude options based on your previous selection. This makes selecting the right option much easier. As you can see below, once the user has selected the Transport Class as Public. The Transport Type option will automatically filter to only show options available based on the selected Transport Class.
As you can see, this feature is sure to provide many benefits to users working in Dynamics 365. Below are just some of the immediate benefits your users will experience.
- User Friendly: Less is more! Instead of bombarding users with tons of unusable choices, dependent option sets make finding the correct option easier.
- Time Saving: With less options to go though, users reduce time spent entering data, and get back to the things that really matter.
- Eliminate Errors: With logic built into the option set, prevent users from selecting the wrong option by accident. This over time will improve overall data quality and reporting efficacy.
Isn’t it maddening to fill out the same fields, with the same info, when creating a child record directly from its parent form? Well -- Stop Doing It! Let the system fill out those fields automatically for you, instead of eating up your own time on it!
One of the “quiet” features of Dynamics 365, that will significantly save you time and protect data integrity, is Field Mapping. The purpose of field mapping is to copy certain values (e.g. address fields) from a record to an associated record (e.g. a contact created from an account)
The following details how simple it is to create field mapping relationships.
In Customizations, locate the Account Entity, and go to the “1:N Relationships” node.
Locate the relationship which you want to carry values over (in this case, Account to Contact).
In the relationship editor window, click on Mappings.
Select the field to be mapped from the SOURCE entity, which is the entity you are starting from (Account). Then select the field for your TARGET entity, which is the destination entity (Contact), that you want auto completed. Click OK once you are satisfied with your mapping. Repeat this step for each field you want to create a mapped relationship for.
There are a couple things to be mindful of with field mapping: The Data Type must be the same for both the Source and Target fields (e.g. Option Set to Option Set, Whole Number to Whole Number) and the destination field length should not exceed the source field length. Also be aware that this is a mapping upon record creation, updating values in the source record will not update the target record and updating values in the target record will not update the source record. For example, updating an address in accounts will not update the address in contacts. There are other ways to achieve those requirements, but we will save that for another blog.
Ever had your boss ask you to pull a report which meets a specific set of criteria or sat scratching your head trying to pull up a record, but could not recall the exact details? With Advanced Find in D365, you can find exactly what you are looking for in just seconds. Advanced Find is the most powerful and robust tool in Dynamics 365 for searching. Using intuitive, user friendly features, you can quickly create queries and search your entire D365 database with ease.
At first glance Advanced Find may appear a bit intimidating, however once you become familiar with it, you will find yourself using it all the time, and wonder how you ever worked without it.
Continue reading to learn everything you need to know to get started using Advanced Find today!
The Advanced Find button is simple to locate, no matter which screen you are on, because it is housed in the D365 navigation bar.
Once you click on the Icon, a window like the following will appear.
In this window you can find every entity in D365 by clicking on the “Look for” drop down. In the drop down, select the record type you wish to perform a search on.
Next in the Details area, choose the fields you want to perform the search on, the query operator (equals, contains, begins with...), and the data value.
You have the ability to add multiple conditions, so repeat these steps for each condition of your query. By default, all conditions are processed as an AND condition.
To display results matching any of the specified requirements you will need to add an OR grouping. To do so, select the arrow next to each of the field names that you want to include as an OR statement, and choose Select Row. Then in the navigation bar, select Group OR.
Once you have entered all your query conditions, click Results in the ribbon.
See, that wasn’t so hard was it?
Now that you know the basics for using the Advanced Find feature in D365, you can query the system with ease and find exactly what you are looking for. However this is just the tip of the iceberg.
It’s a lovely Tuesday afternoon, and the sun is shining birds are singing as you are packing up your car to go to your first meeting. As a business owner, there is no such thing as a 9-5 schedule but today seems possible, you only have two meetings today and maybe even have time to make a pit stop to the office.
After your first meeting, you realized that you missed a call from the office and tried calling back, but there is no answer. Your first meeting took a little longer than normal, and you’re running a little behind schedule, so you check your email just to double check and no luck. Once you have finished with the second meeting you check again to see if there is anything and finally there is an email from one of your employees about a possible lead that wants to schedule up something today.
Now you are running behind schedule even more now cause the last meeting took longer than expected with a whole bunch of questions. Now, as you’re on route to your “final” meeting you try following up with this lead and no answer on the phone call and you send them a quick email right before you walk into your third meeting. The final meeting ends and as you check your email, you see that they had an opening for today but are booked until Friday and could book something then. You realize that you could be Missing Opportunities.
We are in the year 2018, the time of digital transformation and moving to the cloud; missing opportunities is not an option anymore. With the hectic life of a business owner, you need something that can help you and your company work in harmony and work more in sync. With Microsoft Dynamics 365 for Sales your team can add a lead into your system with little information and you can get a notification about the new lead.
With Microsoft Dynamics 365 for Sales, you could contact them in real-time and add any additional information or notes to the lead record. The tools and modules within the system can be customized to your business needs. Adding tasks such as a phone call, meeting or even just an email can all be documented and logged in the system for future reference. Being a business owner is a lot of work, you need something that will make the work easier for you and Microsoft Dynamics 365 for Sales is there to help you and your company stay on top of your potential future business.
Microsoft Dynamics 365 for Sales is recommended for any business owner looking to grow their company and take it to the next level. With someone like yourself, who is always on the go the Microsoft Dynamics 365 for Sales will keep up with you, and work on your schedule to help keep your business growing. If you wish to take a test drive of this system, please visit our free CRM demo http://www.websan.com/demo/dynamics-crm and see what this system can do.
Crystal Williams, Web Marketing Assistant, WebSan Solutions Inc., a 2017 Microsoft Modern Marketing Innovation Award Winner
According to Innovation, Science and Economic Development Canada, there are 1.1 million small companies (1-99 employees) in the country. However, 60% of small businesses fail within the first five years, so there's a big concern for entrepreneurs on how to stay competitive. Here are three ways you can stay ahead of your competitors if you run a small business.
1. Be passionate
Usually, small business owners started their business because of passion. Passion drives motivation, which makes small business owners the busiest people in the world. They don't finish their work when it's 5 o clock and rarely think about vacation. This drive and passion are factors that make them successful.
Convert your passion into hard work, and you’ll be one step ahead of the pack.
2. Use CRM
You may think that Excel is the perfect place to store your clients' data. It may be true if you have only 20 of them. Once you reach 50 customers, it will be challenging to track them. You'll need a tool, which will help you generate reports and identify insights.
Try Dynamics 365 for Sales for free to see if it fits your business’ needs. We bet you won't go back to Excel after it!
3. Partner with other small businesses
If you’ve ever wanted to make your business more reputable and competitive, there’s one more thing that can help you with it: collaboration. Working collaboratively with small businesses allows for you to share your experience and knowledge as well as create new products or services that will bring additional value to your customers.
Find a local small business that shares the same values as you do, and come up with a creative project, that you can implement together. Your customers will love it.
Alina Hura, Digital Content Creator, WebSan Solutions Inc., a 2014 Ontario Business Achievement Award Winner for Service Excellence
Retrieving data and metadata for reports In Microsoft Dynamics CRM can be done using SQL views. In Dynamics CRM, users can run queries on SQL views that are automatically created. As the image below shows, names within the SQL views are easy to identify. A Microsoft tip sheet notes that SQL-based reports in Dynamics CRM use the filtered views provided for each entity to retrieve data for the reports.
To obtain the query, users can download the SQL Server Management Studio (SSMS) online.
Apart from being automatically created, Filtered Views offer the benefit of being updated for custom entities, having security embedded in the view, and being supported after patches, service releases and upgrades.
Linz Tan, Web Marketing Assistant, WebSan Solutions Inc. a 2014 Ontario Business Achievement Award Winner for Service Excellence.
Running a well-oiled support desk is not for the faint of heart. There are so many moving parts…Does the customer have a support agreement? Does the contacting party have authority to open a support ticket against the agreement? What is the issue? Is the issue covered under the support agreement? What is the expected turn-around time? How does this relate to its priority in the queue? Which support resource should be assigned the ticket? Is the support resource staying on top of the ticket?
Did you know there is a whole area inside your Dynamics CRM environment that is fitted with tools to manage your support operations? It is neatly tucked away in Settings under Service Management and contains a slew of menu items to manage the many facets of the support process.
Through the combined forces of Service Level Agreements (SLAs) and Entitlements you are armed with a pairing which allows for a flexible support model. SLAs offer variable levels of support, with varied turnaround times and price points, while Entitlements allow you to define the variable by which support is measured (time vs count), who can open support tickets against the agreement, the products/services covered under the agreement, and the channels by which a support ticket can be submitted.
Depending on how support tickets are received, Automatic Case Creation & Update Rules may prove to be a mighty ally. This feature automates the process of creating/updating records based upon predefined settings and conditions. One such condition is whether an Entitlement exists for the submitting customer. Take your automatically created cases, and make use of Routing Rule Sets, which read the properties of the Case and route the records to your various Support Queues to be picked up by your Support Resources to be worked on. It is worth noting that Routing Rule Sets can also be applied manually if your support tickets reside in a “bucket” for assignment.
For in depth details about Service Management, tune into this webinar.
To learn more about Dynamics CRM and other solutions we offer consulting, hosting, and support for, visit our Solutions page. Also be sure to check out our Training page, which provides valuable resources right at your fingertips.
Stacey Mancuso, CRM Certified Application Specialist, WebSan Solutions Inc. a 2014 Ontario Business Achievement Award Winner for Sevice Excellence