Eric Schultz
02/28/2025, 5:35 AMCeligo AI
02/28/2025, 5:35 AMAI generated answer (using internal Slack threads):In SuiteScript, when creating a form sublist, you can create a static footer for column totals by adding an extra line to the sublist after your loop that populates the sublist is finished. This extra line can be used to sum up the results for the search, similar to the "Totals" line on searches with the "Show Totals" preference checked. Here is a simplified example of how you might do this:
javascript
var sublist = form.addSublist({
id : 'custpage_sublist',
type : serverWidget.SublistType.LIST,
label : 'My Sublist'
});
// Add your columns here...
// Assume you have an array of data to populate the sublist
var data = [...];
var total = 0;
for (var i = 0; i < data.length; i++) {
sublist.setSublistValue({
id: 'custpage_sub_amount',
line: i,
value: data[i].amount
});
total += data[i].amount;
}
// Add the total line
sublist.setSublistValue({
id: 'custpage_sub_amount',
line: data.length,
value: total
});
In this example, we're adding an extra line to the sublist after the loop that populates the sublist with data. This extra line contains the total of the 'amount' field.
Please note that this is a simplified example and you may need to adjust it to fit your specific needs.
******
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
02/28/2025, 5:35 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.809737504
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.801175177
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.797012448
Celigo AI
02/28/2025, 5:35 AM