Java Script Task 10: Create a html page and show the accounts mark red color font for city equal to dallas show in left navigation form?

 User Story: if you click on the html page in the left navigation then show only which accounts with red color font which account having the city name as Dallas.

1)      Open CRM Rest Builder and Retrieve the Account entity details such as choose fields as Name and Address1-city

2)      Write Java script code and add that code into to Html by using script tag

3)      Add This Html code in to web resource  

o   Here choose Web Resource type as Web Page (HTML)

4)      Go to Default solution and choose Client Extension Component

o      Under Client Extension choose Site Map

o      Open Site Map and choose Area and click on Add button and choose sub area and in URL field choose html web resource name.

1)      Open CRM Rest Builder choose conditions and click on Create Request


After Click on Create Request below code is generated


Code:

<html>

    <head>

        hello

    </head>

    <body>

        <div id="groupOfRecords"></div>

        <script>

            var groupOfRecords=document.getElementById("groupOfRecords");

 

            parent.Xrm.WebApi.online.retrieveMultipleRecords("account", "?$select=address1_city,name").then(

            function success(results)

            {

              for(var i = 0; i < results.entities.length; i++)

            {

            var address1_city = results.entities[i]["address1_city"];

            var name = results.entities[i]["name"];

            //Creating Paragraph element

            var groupItem=document.createElement("p");

            groupItem.textContent=name;

            if(address1_city!=null)

            {

                if(address1_city.toLowerCase()=="dallas")

            {

                groupItem.style.color = "red";

                 }

             }

            groupOfRecords.appendChild(groupItem);

            }

          },

            function(error)

            {

                Xrm.Utility.alertDialog(error.message);

            }

            );

        </script>

    </body>

</html>

 

Open web resource and click on New Button


In Type section area choose webpage (HTML) and click on Text editor


After clicking on Text Editor below window will open

Here choose Source and Paste the above code, click on Ok and Publish


Go to Default solution and choose Client Extensionsà SiteMap


If you click on site map below window will open

Here choose area and click on Add button and choose Type as Web Resource

Url: Choose web resource name

Title: Enter user defined name

Click on save and publish

Output:


Comments

Post a Comment

Popular posts from this blog

SSRS User Story-7: Create a SSRS report group by Case, retrieve all work orders and make work orders as sub group, retrieve all bookable resource bookings based on work order. If booking is completed then show the row color as green.

Image
Entities: ·          Cases ·          Wok Order ·          Bookable Resource Booking Fetch xml for retrieving cases which does not contains Work Orders (or) choose contain work Orders data: If you choose contains data then in fetch xml in link entity, link type shown as Inner If you choose does not contain data then in fetch xml in link entity, link type shown as Outer . In this scenario we need all work Orders that’s why choose link type as Outer In this below fetch xml code need to remove filter condition Here also need to remove filter condition   Final Fetch xml: Here am writing one link entity data into another link entity Need to pass a from as attribute from link entity < fetch version = " 1.0 " output-format = " xml-platform " mapping = " logical " distinct = " true " >      ...
Read more

SSRS User Story 2: Generate a report on individual student, if I click on the payment details report in student record. It need to show all the transactions done in current year along with sum. (it should show for each student separately)

Image
  Entities: ·          Student ·          Transaction Fields :             Transaction: o    Student Name (Lookup of student entity) o    Amount   Report Creation : Right click on Project à Add à New item Here enter the Report Name and click ok Add Right click on the Data Sources choose Type as Microsoft Dynamics 365 Fetch Connection String : Enter your CRM URL and click on ok Click on the Credentials Enter User name and Password click on Ok Then Data Source is created Right click on the Data Source and choose Add Data Set      Fetch xml for all Transactions in current from linked from student:     Double click on data set name (Transaction) Then below window will be opened. choose Data Source. Choose Query type as Text. Here Ente...
Read more

SSRS User Story-8: Create a SSRS report on the Opportunity entity, show the source lead and campaign details.

Image
  Entities: ·          Opportunity ·          Lead ·          Campaign ·          Need to Create Run Report Button in Opportunity entity Create Campaign Record: Create Lead record: Create a lead record and choose Source campaign as above created campaign. Click on lead qualify button then lead is converted into opportunity.     Opportunity record: Note : Run report button is not available in Opportunity entity form. Need to Create Run Report Button Need to create one solution and add account entity and opportunity entity Solution creation: Adding entities into solution: Open XRM Tool box and create Button: Here copy the Run Report Button from account entity Paste the Run report button on Opportunity entity Fetch Xml for retrieving lead and campaign details f...
Read more