Manipulate the data returned by the CRM 2013 grid.

Posted by on Jan 15, 2015 in CRM 2013 |

Using a CRM plugin you can manipulate the data returned by CRM before the data is returned to the user in the grid/sub-grid.

Some examples would be:

  • Deny the user access to specific data in a specific field based on a security role
  • Get data from a lookup record on a related entity and display it dynamically on the grid.

Create your new plugin class and register it on the RetrieveMultiple message, select your entity and keep the stage of execution as Post operation

Get your entity collection:

 You can run your own queries and add your own logic, then to set the column value for the grid use:

You will need to have a ‘dummy’ field on your entity to be used to display the data however this field will always be empty.

The field will also need to exist in the view or in the columnset retrieval.

This does not update the value in the database rather just a dynamic way of displaying data from another entity.

Read More

Add a double click event handler to a Subgrid in CRM 2013

Posted by on Jan 13, 2015 in CRM 2013 |

Had an interesting problem we had a middle entity that linked two other entities together however we didn’t really want people to get to that entity when double clicking on the row in the grid.

Use the following function and you can override the double click event.

 

Read More

Filtering a Grid in a CRM 2013 Dashboard based off another Grid’s selected row

Posted by on Jan 8, 2015 in CRM 2013 |

G’day Folks,

Had a requirement for a few grids on a new dashboard to be pre-filtered based off the selected row the main grid. My solution was to create a WebResource HTML page which looked at it’s parent window and set the click events on the Grid i wanted and within that click event i’d set the new FetchXml criteria to filter the second grid.

Example:

Entities

Client Entity – N:1 Outlet

Create a HTML webresource with the following:

Note:

Replace “OutletsGrid” with Grid 1 Component Name

Replace “ClientGrid” with the Grid 2 Component Name

I have a base fetchxml  (which you need to fill in) if you want to show all data before you click on any row in Grid 1

Add the Webresource to the Dashboard and Publish

Grid

 

My Outlet Clients Grid (Grid 2) should now filter based on the Selected Outlet (Grid 1)

 

 

Read More

Launching a Modal Dialog from a CRM 2013 Record Window

Posted by on Oct 14, 2014 in CRM 2013 |

In particular situation you may want to launch a modal url fortunately CRM 2013 has an internal function to launch the modal dialogs.

The helper function:

Result:

modalPopUp

Read More

Setting the List in ReadOnly mode to disable most buttons on the ribbon

Posted by on Jul 4, 2014 in SharePoint 2013 |

Another requirement from the customer is at the Archive Centre no one should be able to upload/delete any documents through the UI.

There is a property that can be set on the list to disable the Ribbon bar and commands.

 

Read More

SharePoint feature not appearing in UI

Posted by on Jun 29, 2014 in SharePoint 2013 |

If you’ve deployed a new feature as part of your solution and for whatever reason it doesn’t show in the UI (Web Features or Site Collection features). You can run the following powershell commands:

This will show you any features that are available in the SharePoint Root but have not been installed. Then to install the missing features:

More information: http://technet.microsoft.com/en-us/library/ff607825(v=office.14).aspx

Read More
%d bloggers like this: