This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

clientscript populate sublist on pageInit

Hi, I was trying to populate a sublist during page init. But however, it seems I can only get the first 2 field correct. Which is the "check" and "account" column. Also, I can only add one row, I was hoping that if the linecount is greater than 1, I can also create a new line item.

image.png

nvm I found the solution :slightly_smiling_face:

Here is a snippet, if you want to initially set field values on your sublist using client script and search

```var accountLength = accounts.length;// nlapiGetLineItemCount("itembudgetsublists");

if (accountLength &amp;&amp; accountLength &gt; 0) {
    for (var i = 0; i &lt; accountLength; i++) {

        // console.log('accounts[i]=' + accounts[i] + ' accountTypes[i]=' + accountTypes[i] + ' monthlyavg[i]=' + monthlyavg[i]);
        nlapiSetCurrentLineItemValue("inputsublist", "check", true);
        nlapiSetCurrentLineItemValue("inputsublist", "custpage_account", accounts[i]);
        nlapiSetCurrentLineItemValue("inputsublist", "custpage_account_type", accountTypes[i], false, true);
        nlapiSetCurrentLineItemValue("inputsublist", "custpage_monthly_avg", parseFloat(monthlyavg[i]), false, true);
        nlapiCommitLineItem('inputsublist');

    }
}```
