Skip to main content

JavaScript to Allow Updating Specific Fields Post Record complete.

 Recently for a client I was given the requirement that they needed to update a custom field on activity records whether it was a completed record or not.  The problem when a record is completed, it is in read only status and users can't update the record easily, with minimal clicks.  To solve this business requirement, I wrote two JavaScript libraries.

1) UnlockFieldsOnLoad - This is the function you should list any field that you want to unlock if the record is in complete (read only status).  This function should run on load of the form and will unlock the fields so they can be updated.

2) OnChangeUnlockedFields - This function is what will do the save when the field(s) are updated.  What it does it check to see if the record is in a read only status.  If if it is, it will make the record active again.  After it makes the record activate again, it will write the change to the database, change the status back to the original status and save that change.

 function UnlockFieldsOnLoad(executionContext)  
 {  
   var formContext = executionContext.getFormContext();   
   formContext.getControl("fieldname").setDisabled(false);  
 }  
 //Saves field value if form is read only.  
 function OnChangeUnlockedFields(executionContext)  
 {  
   var formContext = executionContext.getFormContext();  
   var stateCodeValue = formContext.getAttribute("statecode").getValue()  
   //We only want this JS to run if the record is in read only mode. 1=Completed, 2=Canceled  
   if(stateCodeValue === 1 || stateCodeValue === 2)  
   {  
     //Reactivate the record  
     formContext.getAttribute("statecode").setValue(0);   
     formContext.data.save(6).then(function ()  
     {  
       //Complete Record again  
       formContext.getAttribute("statecode").setValue(stateCodeValue);   
       formContext.data.save();  
     });  
   }  
 }  

Comments

  1. Harrah's Cherokee Casino - Mapyro
    Find the best 삼척 출장안마 Harrah's 충청남도 출장마사지 Cherokee Casino Hotels 안성 출장안마 and Casinos in Cherokee, NC. MapYRO users can now compare rates and 전라남도 출장샵 choose the best hotels 세종특별자치 출장마사지 and

    ReplyDelete
  2. I am thankful to this blog giving unique and helpful knowledge about this topic.
    DP-060T00: Migrate NoSQL workloads to Azure Cosmos DB

    ReplyDelete
  3. This article contains a great deal of significant data. I'm stunned by the nature of the data and furthermore it is a helpful article for us, Thanks for share it.dynamics crm configuration service provider USA

    ReplyDelete

Post a Comment

Popular posts from this blog

Validating User Input In CRM Portals With JavaScript

When we are setting up CRM Portals to allow customers to update their information, open cases, fill out an applications, etc. We want to make sure that we are validating their input before it is committed to CRM.  This way we ensure that our data is clean and meaningful to us and the customer. CRM Portals already has a lot validation checks built into it. But, on occasion we need to add our own.  To do this we will use JavaScript to run the validation and also to output a message to the user to tell them there is an issue they need to fix. Before we can do any JavaScript, we need to check and see if we are using JavaScript on an Entity Form or Web Page.  This is because the JavaScript, while similar, will be different.  First, we will go over the JavaScript for Entity Forms.  Then, we will go over the JavaScript for Web Pages.  Finally, we will look at the notification JavaScript. Entity Form: if (window.jQuery) { (function ($) { if (typeof (entityFormClientVali

Dynamics Set IFrame URL - D365 v8 vs. D365 v9

While doing client work, I came across a problem with setting an IFrame URL dynamically.  The underlying issue was that the sandbox instance is on v8 of Dynamics 365 and production is on v9 of Dynamics 365.  The reason for this was because this client was setup around the time that Microsoft rolled out v9.  Anyways, JavaScript that I wrote to dynamically set the URL of the IFrame wasn't working in the v9 instance.  This was because of changes that Microsoft made to how IFrames are loaded on the form and also changes to JavaScript. Here is my v8 setup: JavaScript runs OnLoad of contact form.  This works because of how IFrames are loaded in v8.  You can also run it on either a tab change (hide / show) or OnReadyStateComplete event of the IFrame.  Depending on your setup you will need to choose which is best for you.  For me in this case it was the OnLoad event. Here is the JavaScript: function OnLoad() { //Get memberid var value = Xrm.Page.data.entity.attri

Report Authoring Extension Updated To Support Visual Studio 2019

 FINALLY, Microsoft has pushed an update to the Report Authoring Extension for Dynamics 365 to allow for use of Visual Studio 2019.  This update went live on 12/18/2020 and can be found here .  Installing won't be straight forward into Visual Studio 2019, even if you install everything when you first installed it.  This is because SSDT (SQL Server Data Tools) is installed but, SSAS, SSIS and SSRS are all separate modules for SSDT that you have to install separately.  While you should be fine with just installing SSRS to make this work, I would recommend just installing all 3 parts.   All of these can be found in Microsoft documentation .  In the "Install SSDT with Visual Studio 2019" section, you will see a link to the marketplace where you can download the extensions and install them.  Once that is done, download the Report Authoring Extension and run the installer.  That is it, you can now work on SSRS within Visual Studio 2019 for Microsoft Dynamics.