Java script to update fields from related table

[Jimju83]

I am working on an Ordering model-driven app for physical products.  On the OrderDetail table, there is a lookup column Product Code linked to a ProductCode table.  The ProductCode table contains crucial order info such as Package Type, Package Net Qty, and UoM.  I would like the Order Detail form to look up those fields based on the selected Product Code and update the fields in the Order Detail table.

After digging around the web and forums, it seems that a Javascript web resource may be my best solution.  I am not a dev, but I pieced together the following code and am running into errors.

function onProductChanged(executionContext){
    // get the form context from the execution context
    var formContext = executionContext.getFormContext();

    // get selected Product Code records Package, Net Qty, UoM
    var selectedProductCodeRef = formContext.getAttribute("id_ProductCodeName").getValue()[0];

    var selectedProductCode = await Xrm.WebApi.retrieveRecord(
        selectedProductCodeRef.entityType,
        selectedProductCodeRef.id,
        "?$select=id_PCPackageType,id_PCPkgNetQty,id_ProductCodeUoM"
    );

    var selectedPackageType = selectedProductCode.id_PCPackageType;
    var selectedPackageNetQty = selectedProductCode.id_PCPkgNetQty;
    var selectedUom = selectedProductCode.id_ProductCodeUoM;

    formContext.getAttribute("id_Package").setValue(selectedPackageType);
    formContext.getAttribute("id_PackageNetWt").setValue(selectedPackageNetQty);
    formContext.getAttribute("id_UoM").setValue(selectedUom);
}

Here are some screenshots of the tables and the error.  As you can see in the screenshot below, I created an event for the Product Code field in the form.  I'm wondering if I used the wrong context using getFormContext in a field?  

Here is the Log File:

ReferenceError: Web resource method does not exist: onProductChanged
    at y._handleMethodNotExistError (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:14:1232960)
    at y.execute (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:14:1231548)
    at https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:4:155346
    at i (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:14:95798)
    at ne._executeIndividualEvent (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:4:155320)
    at ne._executeEventHandler (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:4:152138)
    at Object.execute (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:4:151528)
    at w._executeSyncAction (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:14:592280)
    at w._executeSync (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:14:592007)
    at w.executeAction (https://content.powerapps.com/resource/uci-infra/scripts/app.1211c8178aed6627efd7620b582acf2d.js:14:591789)

Error Details:
Event Name: onchange
Function Name: onProductChanged
Web Resource Name: id_customerOrderJS
Solution Name: Active
Publisher Name: DefaultPublisherorg6f65da87

[ShawnDante]

Hello @Jimju83, can you please open the event handler and post the screenshot.

Make sure while uploading webresource type you have selected as Javascript. Also check in the form there is form library section make sure the Javascript is visible.

[Jimju83]

@ShawnDante Thanks for the quick response.  Please see screenshots attached.

[Jimju83]

It turns out I was using schema name instead of logical name.  I updated the code but am now getting an error with column format.

One of the selected columns, Package Net Wt is type Decimal.  Please see a screen shot of the error.

async function onProductChanged(executionContext){
    // get the form context from the execution context
    formContext = executionContext.getFormContext();

    // get selected Product Code records Package, Net Qty, UoM
    var selectedProductCodeRef = formContext.getAttribute("id_isomericproductcode").getValue()[0];

    var selectedProductCode = await Xrm.WebApi.retrieveRecord(
        selectedProductCodeRef.entityType,
        selectedProductCodeRef.id,
        "?$select=id_pcpackagetype,id_pcpkgnetqty,id_productcodeuom"
    );

    var selectedPackageType = selectedProductCode.id_pcpackagetype;
    var selectedPackageNetQty = selectedProductCode.id_pcpkgnetqty;
    var selectedUom = selectedProductCode.id_productcodeuom;

    formContext.getAttribute("id_package").setValue(selectedPackageType);
    formContext.getAttribute("id_packagenetwt").setValue(selectedPackageNetQty);
    formContext.getAttribute("id_uom").setValue(selectedUom);
}

[ShawnDante]

Hey @Jimju83 you can debug to check where your code is breaking 

Debugger  . Let me know if the issue gets resolved.

Thanks

[ShawnDante · Accepted solution]

id_isomericproductcode

Is the mentioned field a lookup if yes then

// Get Lookup// Getting Form Context
var formContext = executionContext.getFormContext();
// Getting the value of Lookup
var LookupId = formContext.getAttribute("new_lookup").getValue();
// Getting the GUID of the lookup record
var Id = LookupId[0].id;// Getting Name of the lookup record
Id = Id.replace(",", "").replace("}", "").replace("{","");var Name = LookupId[0].name;
// Getting Entity Name of the lookup which entity, the lookup record is belonging to.
var EntityType = LookupId[0].entityType;

 check the guid you are using in xrm.webapi

as you mentioned 

id_packagenetwt

 Is decimal you then while setting the field use parseInt(selectedPackageNetQty)

[Jimju83]

@ShawnDante It's working now, thank you very much.  Thanks for the tutorial resource too, gave you a like and subscribe 😀