Making a Field Mandatory Based on Forms via JavaScript in Dynamics 365

Hello Readers!

Entity Forms now come with security roles. You can select security roles and who should be allowed to see the form. This is helpful in scenarios where we have multiple forms for different departments. Let’s say we have two departments: Customer Service and Sales

Customer Service deals with people, while Sales deals with organizations.

Issue: Sales Dept. wants ‘Account/Company Name’ to be mandatory on “CONTACT” form , while Customer Service wants it to be non-mandatory. Both the departments do not want any change in the form design as it suits both.

Solution: Create/Copy a new contact form for either of the department. I am creating a new form for Sales department and naming it ‘Contact Sales Form’ (this form will be a copy of main information form).

Mandatory 1

Go to form properties.

Create a web resource and add it on load.

Mandatory2

Here’s the JavaScript I used:

function getFormName()

{

var Form = Xrm.Page.ui.formSelector.getCurrentItem().getLabel();

if (Form == ‘Sales Contact Form’)

{

Xrm.Page.getAttribute(“smsmt_accountname”).setRequiredLevel(“required”);

}

else

{

Xrm.Page.getAttribute(“smsmt_accountname”).setRequiredLevel(“none”);

}

}

 

Hope you find it helpful!

Happy CRM’ing!

Dynamics CRM Tips and Tricks

Hello Readers! The following Dynamics CRM tips and tricks might help you to save some time.

Hide Time on Email Templates

Use the following formula, assuming you want to place ‘Created on’ of Case on Email Template:

‘{!incident:createdon/@date;}’

Reduce Number of Clicks

Use recently viewed ‘Views’ and ‘Records’.

reduce number of clicks - Dynamics CRM Tips and tricks

 

Use up and down arrows (top right) on records to move to the next/previous record.

use up and down arrows

 

Use Alphabet bar on the bottom of the page to filter.

use alphabet bar

Increase Export to Excel Limit in Dynamics CRM Online

Use OrgDBorgsettings Dynamics CRM Organization Settings Editor (works well on Dynamics CRM 2013, 2015 & 2016 Online).

increase export to excel

Save Your Time & Use Keyboard Shortcuts

CTRL+S-Saves the record/form.

Esc- Close the Dialog box.

CTRL+D- Delete a record.

AL+S- Save & Close.

Shift+ALT+T- Insert a Template on Email.

Workflow Utilities for Dynamics 365

Check out and use Dynamics 365 Workflow Tools.

Auto-Generate Documents – Quotes, Invoices, etc.

Use Document Templates by Going to settings > Templates.

Auto Generate Word Template in Dynamics CRM 2016 and attach in Email

Customize Field Service Mobile App

Use Resco Mobile Woodford Solution for customization. See: Install the Field Service mobile app

Add Members of a Marketing List to Another List (One Click Solution)

Check out this blog post: Adding A Member from One Marketing List to Another

Business Process Flows Limitations

(Technet: Business process flows)

  • There can be no more than 10 activated business process flow processes per entity.
  • Each process can contain no more than 30 stages.
  • Multi-entity processes can contain no more than five entities.

Use Business Rules (Get rid of JavaScripts)

Use Business Rules to get rid of simple JavaScripts:

Understanding Business Rules in MS Dynamics CRM

Calculated & Rollup fields (Avoid plugins)

This is the best thing ever happened. 🙂  link below

Calculated and rollup attributes

Test the Performance/Diagnostics

Add this tools/diagnostics/diag.aspx to your CRM URL (Suffix) and click run.

Testing Performance on Forms CTRL+SHIFT+Q

 

Hope this helps.

Happy CRM’ing!

 

Interactive Service Hub- No Results When Searching KB/Articles

Hello Readers

With the launch of Dynamics 365, there seems to be a problem with ISH List and Global Search. When you try to search a Knowledge Article by Keyword or Title or any other field; you get ‘No Results Found’. This is what you see:

1

Why is this happening?

Apparently, Microsoft Product Team forgot to add any search columns in the ‘Quick Find View’. J

Resolution

Go to settings>>customization>>Entities>>Knowledge Article>>Views>>Quick Find Views>> Add Find Columns like Keywords, Title etc.

Save & Close, now publish all customization

Refresh your ISH and wait until all customizations are downloaded

Now your search will work

Following Screenshots might help:

2

3

Hope you find this helpful.

Happy CRMing !

 

Field Service- Tips & Tricks

Hello Readers

This blog of mine, will certainly take few of your confusions away, on Field Service. I have tried to keep it simple, but you can ask questions to me any time J

Change Colour of Statuses on Schedule Board

Many a times, you have this requirement to match the colours with your organization’s colour theme and you wonder, how to change colours on the schedule board. Well, it’s really simple to fix, follow the screenshots below:

1

Go to Field Service>>Administration>>Booking Statuses

23

Open any of the statuses and pick your preferred colour from the ‘colour picker’

4

Save the changes.

How to make work order visible on Schedule Board?

First things first, technically, it’s not the work order on Schedule Board. it’s related records to a work order, which gets generated automatically by an OOB Plugin. These records are:

  • Bookable Resource Booking (What you see in the calendar)

5

  • Resource Requirement (What you see in the bottom of Schedule Board under ‘Unscheduled Work Orders’)

6

In order to schedule a work order, you must configure a territory in the system by going to Field Service>>Administration>>Territories

Now as highlighted below, click on the ‘settings’ button on SCHEDULE BOARD and apply territory filter.

8

This will enable you to see work orders (Bookable Resource Bookings/Resource Requirements) on Schedule Board.

**This will also narrow down your map to your territory instead of the world map J 😀

9

How to differentiate between the Push Pins on the Map?

if this has confused you a lot, here’s the answer:

S.No. Type Detail Image
1 Full Colour filled Pins This is actually a resource; all resources are randomly given a colour by the system. it can’t be configured.      10
2 Red colour Pin with Question Mark These are your unscheduled Work Orders.     11
3 Coloured Circumference Pins These are your scheduled work Orders; the colour tells you about the status of work order. once completed, it will not be visible on the map.     12

Using Schedule Assistant

I am not sure about everyone, but every time I tried to use ‘Schedule Assistant’ to schedule my work order, it never worked. So here’s a tip:

13

When you click on that button, you reach this page:

14

You need to checkmark ‘Ignore Duration’ and then click on search again. if you’re not very particular about ‘Characteristic Rating’, you can set it to ‘Any Rating’. if you still can’t find resources, select the ‘territory’.

15

Can I have multiple work orders for a single case?

Yes, you can. OOB system has this Business Process Flow -Case to Work Order, which allows you to create a work order only when you have ‘Resolved’ a case. But your clients may have scenarios to have multiple work orders against a case, here’s a trick:

After you have done this, you might receive a query builder error, read this for resolution: https://community.dynamics.com/crm/f/117/t/227184

How to manage Billing/Service Account lookup of work order? (if, you have a B2C scenario)

Your client can be a Government organization, providing support to the residents FOC and they do not need Billing or Service Account. But, its mandatory to have them to create a work order. Here’s a trick:

Case to Work Order (1:N Mapping): I have mapped Case Customer to Work Order Service Account

16

Now ‘Billing Account’ is defaulted equal to ‘Service Account’, its OOB and then I have make those field ‘Visible by Default’ as No. J

Configuring the mobile app for Field Service

it is very important to know, that a lot of things can be customized for Field Service Mobile App. You need to download RESCO Mobile -WOODFORD Solution for that. its free for 30 days and then you can buy a plan. You can configure, what should be visible on Mobile App, you can even design the mobile forms. But its quiet simple to configure and does not need much explanation.

Download WOODFORD here http://www.resco.net/mobilecrm/woodford.html

Import the managed solution to your MS CRM by going to Settings>>Solutions>>Import

Once done, open WOODFORD configuration and follow instructions here https://www.microsoft.com/en-us/dynamics/crm-customer-center/install-the-field-service-mobile-app.aspx

Hope you find the post helpful!

Happy CRMing !!

Query Builder Error on Case Form

Hello Readers

—Quick One—

With the launch of Dynamics 365, there seems to be a problem with case form. This issue comes up when you:

  • Install Field Service and try to link cases & work orders or
  • You change something in the Case Business Process Flow

There can be other’s as well, but I have experienced it by doing the above two.

So, you see a ‘Query Builder Error’; people like me would think ‘I don’t even know, how to build a query?’ 🙂 Why am I getting this error?

1

 

In most cases, you will be able to download the log file, which will show you “‘Incident entity doesn’t contain attribute with Name = ‘CaseResearch_LinkControl” or similar message about another field.

Solution: Go to settings>>Processes>> Business Process Flows (Case)>>Check all the flows and see if there is a field called ‘Resolved'(Yes , this has been added in Dynamics 365). Remove it and you will no more receive query builder error.

You might still face difficulty to resolve it, if you have installed ‘Field Service’; do let me know about it.

Hope you find this helpful.

Happy CRMing !

#Dynamics365 #MSCRM #FieldService #Case #Incident

Project Service Automation- Form Load Issues

Hello Readers

——Quick One—-

As we all know, Project Service Automation module is one of the best add on for MS CRM, for any IT/ITES or Project based organization, in order to deal with Project Contract and Quotations etc. However, with the launch of Dynamics 365, there are some issues currently going on with it.

Issue1: When you add quote to an opportunity, Quote form- Project information changes to the default quote form, which makes it difficult to enter/view Project Details. Project Information form is loaded for few seconds and then quote default form is loaded back.

Issue 2: Moreover, Quote-Project Information page has ‘Project Based Lines’ hidden, so you can’t edit them on the quote form

Solution 1 for Issue 1: When on opportunity form, make sure that you switch to/default Opportunity-Project Information form and not others. Now when you add a quote, it will jump to Quote-Project information form. It works for me, but for many it might not work and they need to check Solution 2 for Issue 1.

Solution 2 for Issue 1: Make a copy of both default Quote form and Quote-Project information form. Now, deactivate earlier versions of both the forms. Set the Project information form as default and do rearrange the order of the form.

1

Solution for Issue 2: Set visible as default for Project based lines sub grid. Go to settings>>customization>>customize the system>>Entity>>Quote>>Forms>>New Quote-Project information form>>Double Click- Quote Lines Tab and set visible as default; Hide the Product based lines sub grid.

2

Hope it resolves your issue…

Happy CRMing !

Deal with Dynamics CRM Online Like a Pro

Hello Readers,

In this blog, I have tried to include useful tips for MS CRM Online. Most of the times, we are not aware of them and we end up raising a ticket to Microsoft.

You can download the tool here: https://orgdborgsettings.codeplex.com/

It is on codeplex and is supported by Microsoft.

Tested Version: MS CRM 2011, 2013, 2015 & 2016 (not Dynamics 365)

keep-calm-and-do-it-like-a-pro-5

Increase Export to Excel Record limit

For MS CRM Online the OOB limit is 10,000 records. You can increase it to any number but my personal opinion is don’t set it over 50,000 as it then starts throwing SQL Timeout error. Go to OrgDBOrgSettings and set MaxRecordsExporttoExcel and change the limit to 50,000 or less

Do not create contacts on email tracking

We know how easy it is to achieve but on an individual user level. But when it comes to MS CRM Online, we just get short of ideas on How to bulk update all users personal options. Well it’s much more easy than we thought. Go to OrgDBOrgSettings and set AutoCreateContactOnPromote as FALSE

Select your error notification preference

Go to OrgDBOrgSettings and set ClientUEIPDisabled as FALSE, this will disable the ‘send error report’ pop up which annoys all the users J

Sharepoint Folder Nomenclature

When you integrate MS CRM & MS Sharepoint, the folder name for each record of CRM in Sharepoint will have a nomenclature like Name+GUID, but to our users it does not look good. Here’s a simple trick to make your folders appear just by Name and not Name+GUID. Go to OrgDBOrgSettings and set CreateSPFoldersUsingNameandGuid as FALSE

Implicit Sharing

Read more about it here: http://blog.dorrekens.com/index.php/list/165-on-implicit-sharing-team-ownership-and-reparenting

You can disable it by changing DisableImplicitSharingOfCommunicationActivities to TRUE

Customise the Alphabet filter on any Grid/List view

It is linked to JumpBarAlphabetOverride; Read https://support.microsoft.com/en-gb/help/2494984/how-to-customize-the-alphabet-bar-for-the-crm-application-grids-for-microsoft-dynamics-crm-4.0 for more information

Change default entity for Regarding Lookup

Change SetRegardingLookupDefaultEntityType to contact and now Regarding will default to Contacts Lookup view. Here: https://bhattketan.wordpress.com/2015/12/07/change-default-lookup-setregardinglookupdefaultentitytype/

Sort Email on Social Pane

Currently, Emails are sorted by Modified on (Descending), you can change it Received on (Descending) by SortEmailByReceivedOn to TRUE

Get information about related KBs here https://support.microsoft.com/en-gb/help/2691237/orgdborgsettings-tool-for-microsoft-dynamics-crm

Hope you find it helpful..

Happy CRMing !

%d bloggers like this: