How can I multiply 'Unit Price' and 'Quantity' then display it on 'Price' Field and then display the sum in 'total cost'.
1 ACCEPTED SOLUTION
Hi
You can follow the community reply by
Please find step by step solution below:
- Create a Widget and add the below-provided script:
api.controller = function($scope) { /* widget controller */ var c = this; $scope.$watch(function() { //Internal Name of Variable Set 'item_details' return $scope.page.g_form.getValue('item_details'); }, function(value) { if (value) { var mrvsData = JSON.parse(value.replace(/'/g, '')); console.log(value); var totalCost = 0; for (var i = 0; i < mrvsData.length; i++) { var mrvs = mrvsData[i]; totalCost += parseInt(mrvs.price); alert('Calculating: ' + totalCost + ' for --> ' + mrvs.price); } //Set Value in the Total Cost alert(totalCost); $scope.page.g_form.setValue('total_cost', totalCost); } }); }; - Create a Variable of type Custom and add the Widget created in Step 1
- Variable details are provided below:
- item_details: Internal Name of the MRVS Variable Set
- total_cost: Variable on the Catalog Item (not inside MRVS variable Set)
Please follow the above steps and import the Update set provided in the attachment.
Please mark my answer as correct if this solves your issues!
If it helped you in any way then please mark helpful!
Thanks and regards,
Kartik
