I’ve created and populated a sublist on a sales or...
# suitescripte
Eric B
02/20/2021, 5:53 PMI’ve created and populated a sublist on a sales order form and I’m trying to update the sublist based on a field change event on the customer dropdown list on a client-side script. The standard setCurrentSublistValue method isn’t working as expected. Anyone have a secret formula? It looks to me that behind the scenes, the sublist rows and being updated BUT the sublist grid on the page isn’t being refreshed.
b
battk
02/20/2021, 9:43 PMWhat does the code look like
e
Eric B
02/20/2021, 10:30 PMThis is the code on the populateSublist function. There doesn’t seem to be a way to access the form using context.form like I can on the UE script so I’m using thisRecord to access the sublist.
b
battk
02/21/2021, 12:13 AMe
Eric B
02/21/2021, 5:04 PMI just added forceSyncSourcing and it’s still not working as expected.
b
battk
02/22/2021, 12:15 AMWhat does the code that creates the sublist look like
e
Eric B
02/22/2021, 1:59 AMwhere form = context.form on the UE beforeLoad function triggered on the user interface context.
b
battk
02/22/2021, 2:17 AMwrong sublist type for the code you have
battk
02/22/2021, 2:17 AMpick a sublist type that supports adding lines
battk
02/22/2021, 2:32 AMif you still want a list, then you need to add all your lines in your user event
battk
02/22/2021, 2:34 AMif you want to change list values client side, then use Field.updateDisplayType to set the entry display type
e
Eric B
02/22/2021, 2:46 AMI tried both INLINEEDITOR and EDITOR sublist types too. The sublist is populated on the UE based on the selected customer on the dropdown list.
b
battk
02/22/2021, 2:54 AMshare your inline editor version then
battk
02/22/2021, 2:55 AMpreferably with hard coded data
battk
02/22/2021, 2:56 AMyour client script looks like it should run normally on an inline editor
e
Eric B
02/23/2021, 9:10 PMThanks @battk I solved it using the DOM since no matter what I tried, Netsuite could not be coaxed with providing a "native solution"
j
Jars
03/05/2021, 6:27 PMHi @Eric B I'm trying to do the same thing. Would you mind sharing your code snippet using DOM? Thanks!
e
Eric B
03/05/2021, 6:38 PMHi @Jars did you run into the same "limitations" that I described where no matter what approach you took using sublist.setCurrentSublistValue or record.setCurrentSublistValue that it looked like it did what it needed to do but it actually wouldn't update/refresh the sublist?
j
Jars
03/05/2021, 7:04 PMYes! Same thing happened. I'm trying for both static and dynamic, and it's in inlineeditor sublist type. My current thought on this is, since I'm setting the value of scripted sublist field on beforeSubmit, it might really be a limitation since scripted sublist fields are not meant to store data... @Eric B
Jars
03/05/2021, 7:34 PMIt worked for me now. It turned out that setSublistValue params for sublist and record obj are different. It solved my issue.
e
Eric B
03/05/2021, 7:57 PMAh ok so you're using an inlineeditor sublist type which won't work in my use case since it's a display only sublist that lives on the sales order form under the shipping tab.
j
Jars
03/05/2021, 7:59 PMI was able to make it work with LIST which is non-editable as well.
3 Views