Since this is a MRVS Variable set, you can't create a catalog client script on the item. You will have to create the client script on the variable set itself.
But there is one problem, you can't access the variables outside MRVS from client script of MRVS variable set.
i.e.,
g_form.getValue('total_estimated_amount')
OR
g_form.getValue('total_estimated_amount', totalCalculatedAmount)
isn't going to work.
My suggestion here would be, create a UI Macro with a button to Calculate Total Amount, and set the value to the total estimated amount field. But this will need an onSubmit validation as well, to see if the total amount was calculated before submission.
You will need to associate that macro variable with a UI Macro as well as a Widget (for service portal)
UI Macro Sample Code:
<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<script>
function calculateTotal() {
try {
//Replace mrvs with your variable set name
var jsonStr = g_form.getValue("mrvs");
var objList = JSON.parse(jsonStr);
var result = 0;
for (var i = 0; i < objList.length; i++) {
//Replace variable_name with your variable's name
result += parseFloat(objList[i]["variable_name"]);
}
//Replace variable_to_set with the name of variable where you want to set the value
g_form.setValue("variable_to_set", result);
} catch (e) {
console.log("Error in the UI Macro Client Script");
}
}
</script>
<button type="button" class="btn btn-primary" onclick="calculateTotal()">Calculate</button>
</j:jelly>
Widget Sample Code:
HTML Template
<div>
<button type="button" class="btn btn-primary" onclick="calculateTotal()">Calculate Total Amount</button>
</div>
Client Script
function($scope) {
/* widget controller */
var c = this;
calculateTotal = function() {
try {
//Replace mrvs with your variable set name
var jsonStr = $scope.page.g_form.getValue("mrvs");
var objList = JSON.parse(jsonStr);
var result = 0;
for (var i = 0; i < objList.length; i++) {
//Replace variable_name with your variable's name
result += parseFloat(objList[i].variable_name);
}
//Replace variable_to_set with the name of variable where you want to set the value
$scope.page.g_form.setValue("variable_to_set", result);
} catch (e) {
console.log("Error in the UI Macro Client Script");
}
}
}
Hope this helps!
Cheers,
Manish
