Sunday, 10 November 2013

Set a lookup field on another form to null using oData using subgrid

When you a have a N:1 subgrid on a form you cannot simply remove the record as CRM only shows a delete button ('x'). Instead, add a subgrid button to the entity referenced in the subgrid that will run a script that uses oData and jSon to set the referenced lookup to null. How you do this is to set the object reference of the lookup field to null as follows; CRMObject.= {Id: null , LogicalName: null, Name: null}; Ensure all three Id, LogicalName, and Name are set to null otherwise it won't work per Microsoft's SDK reference below... In order to set Microsoft CRM Complex Types to null, you must explicitly set each primitive type within them to null. For example, to set an EntityReference type to null, you must set the Id, the LogicalName, and the Name properties to null. The same is true for OptionSetValue, Money, and BooleanManagedProperty.

3 comments:


  1. Thanks for your extraordinary blog. Your idea for this was so brilliant. This would provide people with an excellent tally resource from someone who has experienced such issues. You would be coming at the subject from a different angle and people would appreciate your honesty and frankness. Good luck for your next blog!
    Tally ERP 9 Training
    tally classes
    Tally Training institute in Chennai
    Tally course in Chennai
    seo training classes
    seo training course
    seo training institute in chennai
    seo training institutes
    seo courses in chennai
    seo institutes in chennai
    seo classes in chennai
    seo training center in chennai

    ReplyDelete
  2. Great blog.you put Good stuff.All the topics were explained briefly.so quickly understand for me.I am waiting for your next fantastic blog.Thanks for sharing.Any coures related details learn...
    CRM Software
    Business Management Software

    ReplyDelete