Tiina Böös
06/04/2025, 8:04 AMCeligo AI
06/04/2025, 8:04 AMAI generated answer (using internal Slack threads):In the fieldChanged function, after changing the value of the item sublist's rate field, you can calculate the new total manually based on the new rate and the quantity by multiplying the new rate with the quantity. Here is a sample code snippet that demonstrates this:
javascript
function fieldChanged(context) {
if (context.fieldId === 'rate') {
var newRate = context.currentRecord.getCurrentSublistValue({
sublistId: 'item',
fieldId: 'rate'
});
var quantity = context.currentRecord.getCurrentSublistValue({
sublistId: 'item',
fieldId: 'quantity'
});
var newTotal = newRate * quantity;
// Now you can use newTotal as needed
}
}
In this code snippet, we first check if the field that changed is the 'rate' field. If it is, we get the new rate value and the quantity from the current record. We then calculate the new total by multiplying the new rate with the quantity.
Please note that this code snippet assumes that you are working with a sublist named 'item' and that the 'quantity' field is available in the same sublist. If your sublist or field names are different, you will need to adjust the code accordingly.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
06/04/2025, 8:04 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.831007659
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830386519
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825178742
Celigo AI
06/04/2025, 8:04 AM