How to get logged-in user Id and name in Dynamic CRM using JavaScript.

Description:

In this example, we explain that how to get users name of logged in user role in Dynamic 365 CRM using JavaScript. Alternatively, how to get current logged in user name using JavaScript in Dynamic CRM.or how to get the Logged in user id from JavaScript in dynamic CRM.

So here in this example we explain that how to get current user ID and Name in Dynamic CRM using JavaScript. Alternatively, how to retrieve current user info using JavaScript in Dynamic 365 CRM.below is the JavaScript code that will helpful you to get user name and id of the current logged in user in Dynamic CRM.

Getting Security Role Name for logged-in user in Dynamics using Xrm.

Description:

In this example, we explain that how to get logged in user role in Dynamic 365 CRM.or how to get security role name for logged-in user in Dynamic CRM using XRM.or how to retrieving login user security roles in Dynamic CRM.or how to get role name of current user in Dynamic CRM using JavaScript. Alternatively, get current logged in user’s security role using JavaScript.so below is the JavaScript code with XRM will used to get or retrieve current logged in user role in Dynamic CRM.

filter with parent opportunity id using Odata query Dynamic CRM.

Description:

In this example, we explain that how to filter with parent opportunity is using OData service in Dynamic CRM.or how to get or filter record based on parent opportunity using OData in Dynamic CRM.or OData query to get some parent field in Dynamic CRM.or using OData query to determine whether specific entity has children or not in Dynamic CRM.

So below is the JavaScript code with OData query to fetch or filter record with parent opportunity in Dynamic CRM.

Prefiltering in SSRS report on selected(current) record in Dynamic CRM.

Description:

In this example, we explain that how to run the SSRS report based on specific entity record using FetchXML in Dynamic 365 CRM.or prefiltering in SSRS report on current or selected record in Dynamic CRM using FetchXML. Alternatively, working with SSRS report pre-filtering or related entities record using FetchXML in Dynamic CRM.or how to display current record on SSRS report using FetchXML in Dynamic CRM.

So below is the FetchXML to prefiltering record in SSRS in Dynamic CRM.

Retrieving the last record in each group - SQL Server.

Description:

In this example we explain that how to get Last Record of each group using SQL Server. Alternatively, SQL query to retrieve Last record of each product or group using SQL Server. Alternatively, how to get last record of each group in every month of specific range using SQL query. Alternatively, how do I get latest record of each group using SQL Server query. Alternatively, how to select Last record of each group using SQL Server.

So below is the SQL query that will help you to select or retrieve last record of each group in each month.

Add/Insert New Value into OPTIONSET - Microsoft Dynamics CRM.

Description:

In this example, we explain that how to get or set Option Set item dynamically in Dynamic CRM using JavaScript. Alternatively, how to Add/Insert new value into Option Set in Dynamic CRM using JavaScript. Here in this example we explain that how to add New Items in Option Set control in Dynamic CRM using JavaScript. Or dynamically add or remove Option to an Option Set using JavaScript in Dynamic CRM.or add new Option Set to an Option in Dynamic CRM using JavaScript.in below example ="example-enableFiltering" is the id of the Select.

How to open confirmation dialog in Dynamic CRM.

Description:

In this example we explain that how to open Confirmation Dialog Box in Dynamic CRM using JavaScript. Alternatively, how to open Confirmation Dialog Box in Dynamic CRM and perform action when click on the button using JavaScript.

In Dynamic CRM Xrm.Utility library are used to display Confirm and alert Dialog Box in a form. Here in this example we explain that how to open confirmation dialog box and when click on ok button then perform some action or when click on cancel at that time close the dialog box.

So below is the JavaScript code to open Confirmation Dialog Box in Dynamic 365 CRM.

How to Get Opportunity Won or Lost via JavaScript in Dynamic CRM.

Description:

In this example we explain that how to get Opportunity is Won or lost using JavaScript in Dynamic CRM.or how to get the Status of the Opportunity using JavaScript in Dynamic 365 CRM.or How to track Opportunity closed as won using JavaScript in Dynamic CRM.

In our requirement like when any Opportunity is open by user at that time we have to get the status of the Opportunity like it is Won Opportunity or Lost Opportunity so we have used one JavaScript function on Form Load of Opportunity and get the status of the Opportunity when Opportunity is open by end user.

So below is the JavaScript code that are used to get the Opportunity status like Won or Lost in Dynamic CRM.

Retrieve Option set value from web API in Dynamic CRM

Description:

In this example, we explain that how to get the Option Set Value and Text in jQuery Ajax call success method result in Dynamic CRM.or how to retrieve Option set value from web api in Dynamic CRM.or retrieve the option set values for collection attribute in Dynamic CRM.

So here we explain that how to get option set text and value from OData query in Dynamic CRM web api.so below is the OData query that are useful to get the Option set value in Dynamic CRM.

Display Pie Chart in Dynamics CRM using Web Resource.

Description:
In this example, we explain that how to display pie chart in Dynamic CRM using HTML Web Resource. Alternatively, how to display revenue vs cost of particular opportunity in pie chart using HTML web Resource and Canvas JS chart in Dynamic CRM.or how to display pie chart in Dynamic CRM entity form using JavaScript and Web Resource.

So here we explain that how to get data of the Opportunity entity and display it in Pie Chart dynamically using HTML Web Resource and JavaScript in Dynamic CRM.

how to avoid image getting loaded from the cache in Asp.Net

Description:

In this example, we explain that how to remove images from browser cache when image is changed in Asp.Net.or how to avoid image getting loaded from the cache. Alternatively, image are loaded from cache so how can I load new images instead of old image in Asp.net.

Therefore, there are many questions raised like how to load new, image every time when image is changed instead of loading image from cache in browser in Asp.Net.or by default browser load image from cache when image is changed.

Now since it is not possible to clear cache of user’s browser from server side. We can use the following trick

Retrieve another entity record by using GUID of that record in Javascript.

Description:
In this example, we explain that how to get all the record based on GUID in Dynamic CRM using JavaScript or jQuery. Or filter the records based on guid in Dynamic 365 CRM using JavaScript Ajax call. Or retrieve another entity record by using GUID of that record in JavaScript in Dynamic CRM.

So here, we explain that how to retrieved record by GUID in dynamic CRM using OData using JavaScript.

For Nvarchar(Max) I am only getting 4000 characters in SQL Server?

Description:
In this example we explain that how to use SQL string variable larger than 4000 character in SQL Server Stored procedure because we all know that SQL will not execute Query parameter contains more than 4000 character so to overcome this problem we have to use the while loop and assign the string in a variable.

There are many questions are raised from user like nvarchar max after 4000 character not working. Or trouble printing out long varchar max string.so below is the query that will help you when you SQL Query size more than 4000 character.

set parent case lookup in quick create form using JavaScript in Dynamic CRM

Description:
In this example we explain that how to populate Quick create from with data from parent form in Dynamic CRM using JavaScript. Or how to set Parent Case Lookup in Quick Create case form in Dynamic CRM using JavaScript. Or how to pre-fill fields in a quick create form from the parent form using JavaScript in Dynamic CRM.

Here we demonstrate that how to populate a parent form lookup field value in a child form using JavaScript in Dynamic 365.so how to fill-up the Parent Case Lookup in Child case form using JavaScript in Dynamic CRM.

Open new activity form with ‘Regarding’ field prefilled in Dynamic CRM

Description:

In this example we explain that how to open new activity form with “Regarding” field prefilled in Dynamic CRM using JavaScript. Or how to open Phone Call or Task Activity form with fill-up Regarding filed using JavaScript in Dynamic CRM.or open New Activity form with regarding and Party List field prefilled using JavaScript in Dynamic CRM.

So here we explain that how to use Xrm.Utility. openEntityForm with Regarding field in Dynamic CRM using JavaScript.

Open and fill new form using JavaScript in Dynamic CRM

Description:
In this example we explain that how to open and fill new form in Dynamic CRM using JavaScript. Or how to open new form with fill up data in Dynamic CRM using JavaScript and XRM. Or fill relationship data in new form entity using JavaScript in Dynamic CRM. Or set field value using parameters passed to form in Dynamic CRM using JavaScript.

Here we demonstrate that how to populate field on form load using JavaScript in Dynamic 365.so first we open child entity form and fill up the data by passed by parameters using JavaScript in Dynamic CRM.So below is the JavaScript code to set field values using parameters passed to a form in Dynamic CRM.

How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server

Description:

In this example we explain that how to get Time, Hour, Minute, Second and Millisecond from DateTime in SQLServer.or SQL Query to get Time, Hour, Minute, Second part from DateTime Field in SQL Server.

In our requirement we have to display only those record has time was after 5:30 so we have to first get the Hours and Minutes from the DateTime Field and then we have to check the condition that it is greater than that then it will be listed in select query.

So below the list of the SQL Query that will be helpful to you to get the all that Date and Time part from date using SQL Query.

How to set a default form depending on attribute value in Dynamic CRM using JavaScript

Description:
In this example we explain that how to set desired form as default form in Dynamic CRM using JavaScript. Or how to set Default Form in Dynamic CRM based on some condition using JavaScript. Or how to set Default form in Dynamic CRM at run time using JavaScript. Or how to set a default form depending on attribute value in Dynamic CRM using JavaScript.

In our requirement we have multiple Account form in our Dynamic CRM and we have to set default form based on some condition, so to achieve this solution we have created some JavaScript code to set the Default desired form in Dynamic CRM using JavaScript.

How to Disabling controls in a section in Dynamic CRM using JavaScript

Description:
In this example we explain that how to enable/disable controls in a section in Dynamic CRM using JavaScript. In previous example we already explain that how to enable/disable control or field using JavaScript in Dynamic CRM. but now in this post we will explain that how to disabling controls in a section using JavaScript.

We already know that we can’t disable a section using “SetDisable(false)” same like field because section is the container of the controls so we can’t disable them.so to overcome this problem we have to create another JavaScript code like below.

Enabling/Disabling Fields using JavaScript in Dynamic CRM

Description:
In this example we explain that ow to disabling control in Dynamic CRM using JavaScript. Or how to disable controls in a section of Dynamic CRM form using JavaScript. Or how to set read only field in Dynamic CRM programmatically using JavaScript. Or how to disabling control dynamically using JavaScript in Dynamic CRM.

So here we demonstrate that how to disable control in Dynamic CRM using JavaScript. Or disable/enable fields in Dynamic CRM using JavaScript. Below is the JavaScript code that will help you to disable and enable control in Dynamic CRM dynamically.

Read and Parse XML web resource in Dynamic CRM using JavaScript.

Description:
In this example we explain that how to Read and Parse XML Web Resource in Dynamic CRM using JavaScript. Or how to Read and Parse XML Web Resource using XRM in Dynamic CRM.Or how to read XML file in Dynamic CRM using JavaScript and XRM.

So here we demonstrate that how to read XML web Resource and Parse using JavaScript in Dynamic 365.below is the XML Web Resource file and JavaScript code that will read and parse XML file using JavaScript and XRM in Dynamic CRM.

How to change display text of a Lookup field in Dynamics CRM using JavaScript

Description:
In this example we explain that ow to change display text of a Lookup field in Dynamic CRM using JavaScript. Or how to display Lookup Text instead of Default Field using JavaScript in Dynamic 365.or how to display related entity field in Lookup instead of the primary entity field in Dynamic CRM using JavaScript.

Generally, in Lookup when we open it displayed the primary field in Text after selection but our requirement was that to display other field in Lookup which is not PrimaryNameField.

Here we explain the Account lookup field that will by default display Account Name in Lookup because it is Primary Field Name now we want to display Account Number instead of the Account Name.

How to show Filtered Lookup Dialog in Dynamics CRM through JavaScript

Description:
In this example we explain that how to open filtered Lookup Dialog in Dynamic CRM using JavaScript. Or how to display Filtered Lookup Popup in Dynamic 365 using JavaScript. Or how to show Filtered Lookup Dialog box using JavaScript in Dynamic CRM.

Here we demonstrate that how to apply custom filter on Lookup and display on Modal Popup Dialog Box in Dynamic CRM using JavaScript. Or Filtered Lookup view on pre-selected value on Dynamic CRM form using JavaScript. Or selecting Lookup Value Dynamically using JavaScript.

prevent record when active/inactive in Dynamic CRM

Description:

In this example we explain that how to prevent record’s when Active/Deactivate in Dynamic CRM using JavaScript. Or how to display confirmation Dialog Box when user Active or Deactivate the form Record in Dynamic CRM using JavaScript. Or how we can apply validation logic to prevent Activate/Deactivate of a record from Form in Dynamic CRM using JavaScript.or prevent record deactivation if child record are active using JavaScript.

So here we demonstrate that how to prevent record or display confirmation dialog when Activate/Deactivate record in Dynamic CRM using JavaScript. Below is the JavaScript code that you have to call on Save method of the Form in Dynamic CRM.

Switch Business Process Flow using JavaScript based on CRM Form’s field value

Description:
In this example we explain that how to switch business process in Dynamic CRM using JavaScript. Or change the business process flow using JavaScript in Dynamic CRM.or JavaScript code to change or switch business process in Dynamic CRM.

Here we demonstrate that how to switch Business Process Flow using JavaScript based on Dynamic CRM form’s field value. We have requirement to switch the business process on Case Origin like if Case Origin Equal Website then set Business Process like Website to Case, if Case Origin Equal Email the set Business Process like Email to Case.

So below is the JavaScript code that demonstrate that how to change or switch Business Process in Dynamic CRM.

Open Look up as dialog in Dynamic CRM

Description:
In this example we explain that how to open Lookup as dialog in Dynamic CRM using HTML Web Resource. Or how to open Lookup as Popup or Dialog in custom HTML using HTML Web Resource and JavaScript in Dynamic CRM.or how to open Dynamic CRM Lookup as Dialog Box using XRM.

Here we demonstrate that how to open Lookup in Dynamic CRM using JavaScript. Or how to show Lookup as Dialog programmatically using Xrm Utility in Dynamic CRM.below is the JavaScript code with XRM to open or show Lookup as Dialog or Modal Popup in Dynamic CRM.

How to create a custom Lookup control using web resource in Microsoft Dynamic CRM

Description:
In this example we explain that how to create a custom Lookup control using HTML Web Resource in Dynamic CRM. Or how to create custom Lookup in Dynamic 365 using HTML Web resource and JavaScript. Or how to add Lookup field in HTML Web Resource in Dynamic CRM. Or how to display Lookup in HTML Web Resource using JavaScript in Dynamic CRM.

So here we demonstrate that how to display Account Lookup using Web Resource in Dynamic CRM.we simply display same account lookup as we have in dynamic CRM with all functionality like search and add new Account using Web Resource.

How to get language id in Dynamic CRM using custom workflow

Description:

In this example we explain that how to get user language in Dynamic CRM using custom workflow. Or how to find the CRM user language Id(LCID) from within C# custom code using custom workflow or plugin. Or how to get the language id of the current user using custom workflow in Dynamic CRM.

So here we demonstrate that how to get the userId and based on UserId we find the Language Id of the user using custom workflow or plugin in Dynamic 365.below is the code to get the Language Id of the current user and based on the Language you can perform the different activities as per your requirements.

below code will require two parameter that you have to pass when you call custom workflow from your workflow and based on that parameter it will get the Language ID of the current user of the Dynamic CRM and display on alert box.

custom workflow to change Lead data to another language in Dynamic CRM

Description:
In this example we explain that how to translate Lead Data from one Language to another Language in Dynamic CRM using Custom Workflow. Or translate lead data in Dynamic CRM using plugin or custom workflow. Or how to translate record from one language to another language using custom workflow in Dynamic CRM.

So here we demonstrate that how to change Lead Record from English to other language like Spanish, Dutch etc. when Lead is created in Dynamic CRM at that that custom workflow will be called in back end and it will translate all field of the Lead to another Language.

So when English user enter Lead data in English and when same Lead is open by Dutch user then these Lead data are shown in Dutch Language based on user language you can setup.

Below is the custom workflow code that will be helpful to translate the Lead Record to another language.

create route map with multiple locations on Bing map.

Description:
In this example we explain that how to create route map with multiple locations on Bing Map using JavaScript. Or plotting multiple routes in Google/Bing Maps in our web application or in Dynamic CRM Web Resource. Or Directions using Bing maps with multiple locations on Bing Map using JavaScript.

So here we demonstrate that how to get directions in Bing Map with multiple location. Or how to get direction from one source to multiple destination on Bing Map. Or create route with one source to multiple destination on Bing Map using JavaScript.

calculate distance between two points on map using JavaScript

Description:
In this example we explain that how to calculate distance between two points on Bing Map or Google Map using JavaScript. Or how to measure distance between points on Map using JavaScript.or JavaScript to calculate distance between two points on Map. Or how to calculate kilometers or miles between two points on Maps using JavaScript. Or how to calculate kilometer or miles between two pin point or two pushpins on maps using JavaScript.

So here we demonstrate that how to calculate distance or measure between two routes points using JavaScript. Or routines calculate the distance between two points (using Latitude and Longitude of those points) using JavaScript.so how to calculate distance between two location or two cities or two addresses using JavaScript.

Get Latitude and Longitude from address JavaScript

Description:
In this example we explain that how to get Latitude and Longitude from Address using JavaScript. Or how to get Latitude and Longitude of the Map using JavaScript. Or how to find Latitude and Longitude based on address enter by user in dynamic CRM using JavaScript.

So here we demonstrate that how to get or find Latitude and Longitude form address using JavaScript. We used Geocoding service to get Latitude and Longitude from address using JavaScript.

how to get Current Location in Dynamic CRM using Bing Map.

Description:
In this example we explain that how to get Current Location in Dynamic CRM using Bing Map. Or how to fetch current user Location in Bing Map in Dynamic CRM.or HTML web resource to get current Location in Dynamic CRM using Bing Map. Or how to display Bing Map in Dynamic CRM with User’s current Location using Html Web Resource.

So here we demonstrate that how to show current location in Bing Map in Dynamic CRM.or how to display pin point of the current location in Dynamic CRM using Bing Map. Or get current Location from the device in Dynamic 365 and display on Bing Map using web resource.

Below is the html web resource code that are used to display user current location on Bing map in Dynamic CRM.

how to change the user language in Dynamic 365 using Custom Workflow

Description:

In this example we explain that how to change the user setting in Dynamic CRM using custom workflow. Or how to change the Language of the Dynamic CRM using custom workflow. Or how to update the CRM user UILanguage and HelpLanguage using custom workflow in Dynamic 365.or how to change user setting based on the Language of the CRM user using custom workflow or plugin in Dynamic 365.

Here we demonstrate that how to change regional and language option using custom workflow. Or how to change language in Dynamic CRM dynamically based on user language change using custom workflow.

Getting vlaue/Id/Name of lookup field in a form using CRM custom workflow or plugin

Description:
In this example we explain that how to get Lookup field Text and value using Custom workflow in Dynamic CRM or Dynamic 365.or how to get or set the Lookup Text and Value in Dynamic CRM using custom workflow activity. Or getting Lookup value in custom workflow using dynamic crm. or get Lookup Id in custom workflow.

So here we demonstrate that how to retrieve the Name/value of the selected Lookup field and display it in text field using custom workflow in dynamic crm. Below is the code to get the Text and value of the Lookup field in Dynamic CRM using custom workflow.

Get OptionSet Text and value using custom workflow in Dynamic CRM

Description:
In this example we explain that how to get OptionSet value using Custom workflow in Dynamic CRM or Dynamic 365.or how to get or set the OptionSet Text and Value in Dynamic CRM using custom workflow activity. Or getting optionset value in custom workflow using dynamic crm. or get option set value and set option set value in custom workflow.

So here we demonstrate that how to retrieve the value of the selected oprionset field and display it in text field using custom workflow in dynamic crm. Below is the code to get the Text and value of the optionset field in Dynamic CRM using custom workflow.

Scrollable GridView with Responsive Fixed Headers in ASP.Net using JavaScript

Description:
In this example we explain that how to create scrollable Grid View with Fixed header in asp.net using JavaScript and CSS.or Grid View with Fixed Header and scrollbar in asp.net using JavaScript. Or Fixed Grid view header with horizontal and vertical scrolling in asp.net using CSS.

Previously we already explain that fixed header when scrolling in grid view in asp.net but here we demonstrate same thing using JavaScript and also it responsive also.so responsive fixed header when scrolling grid view in asp.net using JavaScript.

Remove Last Character from a String in SQL Server

Description:

In this example we explain that how to remove last character from string in SQL Server. Or how to truncate or remove Last character from string in SQL Server. Or SQL Query to remove last character from string using SQL Server. There are many ways to remove last character from string in SQL Server we have used one of the below query that will helpful to all users.

How to append one DataTable to another DataTable

Description:
In this example we explain that how to append data to DataTable in Asp.Net using C#. or how to append data to Dataset using C#. or how to append or merge data to DataTable using C#. or how to append dataset or data table to a session variable using C#. or how to append one DataTable to another DataTable using C#.

So here we demonstrate that how to merge DataTable in C#. below is the code to merge two data table and assign it to session variable using C#.

clear all checkbox in multiselect dropdown using jquery

Description:

In this example we explain that how to clear all checkbox in multiselect dropdown using jQuery in asp.net. or quick way to clear all selections on a multiselect using jQuery in asp.net. or jQuery-bootstrap multiselect –De-Select /Uncheck all option. Or how to Uncheck all the option of multiselect dropdown using jQuery. Or how to clear selected checkbox value in bootstrap multiselect dropdown using jQuery.

So below is the code for the how to clear values from multiple select dropdown using jQuery. You can use both line as you wish

Order by not working when insert in temp table

Description:

In this example we explain that order by in temp table is not worked in SQL Server. Or how to create or perform order by in temp table in SQL Server. Or SQL query to perform order by in temp table in SQL Server.

There are many questions are raised from many developers like order by not working when insert in temp table so to overcome this problem we have created below query that would be helpful for all to perform order by in temp table in SQL Server.

Formatting number in European format with two decimals using JavaScript.

Description:

In this example we explain that how to set Euro culture in JavaScript. Or how to display number in euro culture format using JavaScript. Or how to convert number into euro culture format in JavaScript. Or how to convert number into euro format currency using JavaScript. Or formatting currency for a culture in JavaScript.

So here we demonstrate that how to formatting number in European format with two decimal places using JavaScript.

How To Create An Animated Scroll To Top Button With jQuery

Description:
In this example we explain that how to scroll to top on click using jQuery bootstrap. Or how to create a scroll back to top button in asp.net using jQuery bootstrap. Or bootstrap snippets link to top page using HTML CSS and jQuery. Or implement bootstrap snippets scroll top scroll bottom using jQuery. Or create smooth page scroll to top using jQuery bootstrap.

So here we demonstrate that how to create an animated scroll to top button with jQuery bootstrap in asp.net.so how to add a scroll to top button in your website or blog with responsive bootstrap snippets using jQuery.

Bootstrap accordion prevent collapse on postback in asp.net

Description:

In this example we explain that how to prevent bootstrap collapse toggle after postback in asp.net. or jQuery toggle disappearing after postback on button click event. Or how to maintain bootstrap accordion current pane state after postback in asp.net using JavaScript. Or how to retain bootstrap collapse state on page refresh/Navigation using jQuery. Or bootstrap accordion prevent collapse on postback in asp.net.

In general, we used HiddenField to store the value of the accordion toggle when postback and then again set HiddenField value to accordion toggle.