would anyone know how to retrieve sublist data fro...
# general
u
would anyone know how to retrieve sublist data from a record and apply it onto an email template? I'm using Netsuite's default editor and it doesn't seem to work 1:1 with the Freemarker system. For context, I'm trying to retrieve a custom column from a Sales Order's
item
sublist, to no avail.
i
I guess the first thing to try is the currentRecord.getSublist(‘sublistId’: ‘item’). However, I have noticed that sometimes accessing the info of each of the item in the sublist is a bit tricky. If that’s what you need, then you will have to (1) get the LineCount of the sublist, (2) loop through each of the item to getFiledValue or getFieldText of each line. Hope it helps!