Any tricks to add multiple lines to a sublist quick in client script? The sublist doesn't have any sourcing or other client scripts. It's just annoying to wait a couple of seconds for all the selectnewline and commit line to execute.

no, but make sure you’re setting ‘`forcesyncsourcing: true`’ on

setValue()

I guess you mean on setCurrentSublistValue(). Would it speed up anything?

You can try SS 1.0, nlapiSetLineItemValue. You don't need to select new line and commit line. P.S. SS 1.0 code can be executed in SS 2.x based client script

I've used that when I want to update existing sublist lines with new values. But when I want to add lines I can't get that to work.

console.time('loopy')
//const queryResult = [
//    {fieldId1: value, fieldId2: value}
//]
queryResult.forEach((result, index) => {
//currentRecord.selectNewLine({ sublistId });
    Object.entries(result).forEach(([fieldId, value]) => {
        nlapiSetLineItemValue(sublistId, fieldId, index+1, value)
        //currentRecord.setCurrentSublistValue({ sublistId, fieldId, value, ignoreFieldChange: true });
    });
 //currentRecord.commitLine({ sublistId });
});
console.timeEnd('loopy')

Where does index come from?

from the queryResult.forEach-loop on line 5.

I suggested to use nlapiSetLineItemValue without the select new line and commit line.

Yes, notice that the selectNewLine and commitLine is commented out.

Sorry, on my phone it is not displaying correctly.

For the adventurous of you... from 3 seconds -> 50ms

const recmach = getMachine(sublistId)
        recmach.insertdata([[...the_data].join(String.fromCharCode(1))].join(String.fromCharCode(2)),0)
        recmach.recalc()
        recmach.buildtable()

You can get how

the_data

should look like with recmach.getLineArray()

nlapiSetLineItemValue(sublistId, fieldId, index+1, value)

See if this works independently - if you still want to use this.

Can also get the order of the fields with

recmach.getFieldIdxMap()

Did you pass in the values?

🙂 yes

That's weird..

It works to update an existing line, but I cannot add more lines.

which record are you on?

It's a custom record that has a child record.

and how are you getting the index?

I run a query to get what values I need to fill in. That query returns an array of objects. The index is the array-index that I loop through.

No, I mean when you ran it in the console.

ah, then I tested on line "1" and "2".

Yeah, I tried it on the sales order right now. You are right, it's not adding a new line. May be I have used it with existing line.

unless going the hackery route. 🙂

Yeah, thanks for this:

const recmach = getMachine(sublistId)
        recmach.insertdata([[...the_data].join(String.fromCharCode(1))].join(String.fromCharCode(2)),0)
        recmach.recalc()
        recmach.buildtable()

haha, you shouldn't thank. It will probably cause some serious problems some time. 😈

I've had issues with setting values in client scripts when forcesyncsourcing wasn't used.

Can I get the complete code on this one 😅 I am having the same issue, but this time I cannot enter a new line and the other column can't be populated

I didn't have any issues, just that it wasn't as fast as I wanted it.

Ah I for some reason I thought there has been an issue on setting an initial value..