Concatenating All Names of Records in Subgrids Using JavaScript in Dynamics 365

| Editorial Team

Dynamics 365 is a powerful platform that enables businesses to manage their data and processes effectively. In this blog post, we will look at how to concatenate all names of records in a sub-grid using JavaScript.

Subgrids in Dynamics 365 are a powerful way to display related records on a form. They allow you to show multiple records in a grid format within a form, providing a quick and easy way to view related data. However, sometimes it is helpful to be able to display all the names of the records in a sub-grid as a single string. For example, you may want to display all the names of the contacts associated with an account on the account form. This can be achieved using JavaScript.

Here are the steps to concatenate all names of records in a subgrid in Dynamics 365 using JavaScript:

Step 1: Identify the Subgrid Control

The first step is to identify the subgrid control that you want to work with. You can do this by opening the form editor, selecting the subgrid, and looking at the properties of the control. Take note of the name of the subgrid control.

Step 2: Retrieve the Subgrid Records

Once you have identified the subgrid control, you need to retrieve the records that are displayed in the subgrid. You can do this using the following code:

var subgrid = Xrm.Page.getControl(“subgrid_name”);

var records = subgrid.getGrid().getRows().getLength();

In this code, “subgrid_name” is the name of the subgrid control that you want to retrieve records from. This code retrieves all the records in the subgrid and stores them in the “records” variable.

Step 3: Loop through the Subgrid Records

Next, you need to loop through the records in the subgrid and retrieve the name of each record. You can do this using the following code:

var names = “”;

for (var i = 0; i < records; i++) {

var recordName = subgrid.getGrid().getRows().get(i).getData().getEntity().getPrimaryAttributeValue();

names += recordName + “,”;

}

This code loops through all the records in the subgrid, retrieves the name of each record, and appends it to a string called “names”. The names are separated by a comma.

Step 4: Display the Concatenated Names

Finally, you can display the concatenated names in a field on the form using the following code:

Xrm.Page.getAttribute(“new_names”).setValue(names);

In this code, “new_names” is the logical name of the field where you want to display the concatenated names. The concatenated names are set as the value of the field using the setValue() method.

Conclusion:

In this blog post, we looked at how to concatenate all names of records in a subgrid in Dynamics 365 using JavaScript. By following these simple steps, you can display all the names of the records in a subgrid as a single string, making it easier to view related data on a form. This is just one example of the many powerful capabilities of Dynamics 365 and the customization options available to tailor the platform to your business needs.


M
Chief Architect, Founder, and CEO - a Microsoft recognized Power Platform solution architect.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.


More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting