Table level script not working for me.
I have a table level script on the orders table that is intended to assign a "Dispatcher" to the order based on the Order's "Region". This assignment is intended to automatically populate once the order stage (orde_stage) is "Approved". Regions are associated with the Price List. Dispatchers are assigned by Region. If you get the value of the Price List field, the "name" of the Price List will be equal to the name of the Region. Therefore, the system can match the Price List name to the Region name and then get the Dispatcher associated with the Region.
Based on this, I came up with the following table level script. However, it does not appear to be working and I do not know why. I have a feeling I am doing something stupid and I just cannot see it or I just don't understand how to apply table level scripts.
I walked through this theory in SQL and I came up with the correct value for the dispatcher. Therefore, what am I doing wrong in this table level script?? I don't get any errors and I don't see anything in the logs.
Any assistance is greatly appreciated.
function UpdateRecord()
{
//Get values from updated record
var priceListID = Values("orde_PricingListID");
var orderStage = Values("orde_stage");
//if state is Approved, assign dispatcher based on Region
if (orderStage == 'Approved'){
//Find Price List record and name
var plrecord = CRM.FindRecord("PricingList","prli_PricingListID="+priceListID);
var plName = plrecord.prli_name;
//Find Region based on priceList name
var myRegion = CRM.FindRecord("Regions", "regi_name="+plName);
//Assign Dispatcher associated with Region
Values("orde_dispatcher") = myRegion.regi_dispatcherid;
}
}
