Hi, So My requirement is that upon creating a new item, and selecting an item group, a couple fields should get updated with values. I already have a setup form made which had item group and respective field mappings as well. Below is my current code.
[FormControlEventHandler(formControlStr(EcoResProductCreate, ItemGroupId), FormControlEventType::Modified)]
public static void ItemGroupId_OnModified(FormControl sender, FormControlEventArgs e)
{
ItemCreation_GroupSetupTable buffer;
EcoResTrackingDimensionGroup track;
EcoResStorageDimensionGroup storage;
str ItemGroupId = sender.valueStr();
select * from buffer where buffer.ItemGroup == ItemGroupId;
select * from track where track.Name == buffer.TrackingDimensionGroup;
select * from storage where storage.Name == buffer.StorageDimension;
FormStringControl itemModelGroup = sender.formRun().design().controlName("ModelGroupId");
//FormReferenceGroupControl storageDimension = sender.formRun().design().controlName("StorageDimensionGroup");
//FormReferenceGroupControl trackingDimensionGroup = sender.formRun().design().controlName("TrackingDimensionGroup");
//FormStringControl storageDimension = sender.formRun().design().controlName("StorageDimensionGroup_Name");
//FormStringControl trackingDimensionGroup = sender.formRun().design().controlName("TrackingDimensionGroup_Name");
FormStringControl inventoryUnit = sender.formRun().design().controlName("InventUnitId");
FormStringControl purchaseUnit = sender.formRun().design().controlName("PurchUnitId");
FormStringControl saleUnit = sender.formRun().design().controlName("SalesUnitId");
FormStringControl bomUnit = sender.formRun().design().controlName("BOMUnitId");
FormStringControl salesTaxation = sender.formRun().design().controlName("SalesTaxItemGroupId");
FormStringControl purchaseTaxation = sender.formRun().design().controlName("PurchTaxItemGroupId");
itemModelGroup.text(buffer.ItemModelGroup);
//storageDimension.value(storage.RecId);
//trackingDimensionGroup.value(track.RecId);
//storageDimension.text(buffer.StorageDimension);
//trackingDimensionGroup.text(buffer.TrackingDimensionGroup);
inventoryUnit.text(buffer.InventoryUnit);
purchaseUnit.text(buffer.PurchaseUnit);
saleUnit.text(buffer.SaleUnit);
bomUnit.text(buffer.BOMUnit);
salesTaxation.text(buffer.SalesTaxation);
purchaseTaxation.text(buffer.PurchaseTaxation);
}
In the form design, both dimension groups are reference groups control, inside which is a sibling string control.
ive tried updating it by getting ite FormReferenceGroupControl, getting the FormStringControl, but the value isnt updating no matter what i try (The commented out code). and the form doesnt have a data source either.
Please help.
