In a custpage sublist that is added on a record in...
# suitescriptw
Watz
07/01/2022, 5:33 PMIn a custpage sublist that is added on a record in beforeLoad, how can I get the values from in that table through Client SuiteScript?
I thought I'd get away with currentRecord.get().getSublistValue({sublistId: 'custpage_id', fieldId: 'myFieldId', line: 0). But it gives me "SSS_INVALID_SUBLIST_OPERATION".
Does it have to be a specific type of list? list/staticlist/editor/inlineeditor? Or isn't sublists added in before load available in clientscripts?
Watz
07/01/2022, 5:41 PMhmm... "A required argument is invalid or the sublist is not editable."
Watz
07/01/2022, 5:47 PMI'm guessing you can't add editable sublists on something other than wizards and suitelets
e
Eric B
07/01/2022, 6:23 PMYou have to use the DOM on client scripts for sublists created on the UE beforeLoad.
Eric B
07/01/2022, 6:24 PMvar table = document.getElementById('custpage_sublist_addresses_splits');
w
Watz
07/01/2022, 6:38 PMhmm, ok. I abandoned that route and created a hidden field with the values in a json-string.
Then I convert that field's value to a CSV and download it with a button.
However, the next hurdle is the 100000 char limit. I guess I have to split it up in multiple fields and concat them in the client function.
I really don't want to create a suitelet to download the csv 😄
Watz
07/01/2022, 6:39 PMOr do you have any other suggestion? Maybe it's easier to convert the DOM into a json.
Watz
07/01/2022, 6:43 PMInteresting, I could call the &xml=T and extract the data from the xml. https://stackoverflow.com/questions/72364706/is-is-possible-to-get-the-sublist-data-by-manipulating-dom-if-the-sublist-is-no
e
Eric B
07/01/2022, 6:53 PMyes I use the &xml=T trick to load the page and JSON.parse the XML to get the data I need that way.
w
Watz
07/01/2022, 6:54 PMJSON.parse the xml? Can you run JSON.parse xml? mindblown
e
Eric B
07/01/2022, 6:54 PMso are you just wanting to populate the custom sublist created on beforeLoad with data from NS? on the client script you can use the standard N/record functionality and just use the DOM to display the data.
Eric B
07/01/2022, 6:55 PMvar xmlDoc = jQuery.parseXML(xmlString);
💯 1
w
Watz
07/01/2022, 6:55 PMI want to add a sublist to a custom record in beforeLoad. Then I want a button to press to download the information in that sublist as CSV
e
Eric B
07/01/2022, 7:18 PMso it's a custom record form where you need to add the sublist on the UE beforeLoad event and you need to populate the custom/dynamic sublist with data coming from some record or a saved search and download that data in CSV format via a button click on the custom record form?
w
Watz
07/01/2022, 7:19 PMexactly
Watz
07/01/2022, 7:19 PMThe data comes from a fixed field length file that is linked to the custom record and is converted in the beforeLoad
e
Eric B
07/01/2022, 7:20 PMok so the data is not child data of the custom record?
w
Watz
07/01/2022, 7:20 PMnope
e
Eric B
07/01/2022, 7:21 PMis the fixed field length file stored in the file cabinet and are you displaying all the fields/columns from that file on the sublist?
w
Watz
07/01/2022, 7:21 PMyup
Watz
07/01/2022, 7:22 PMIt looks like your first suggestion with using the DOM might be the most compact
e
Eric B
07/01/2022, 7:22 PMso to display the data on the dynamic sublist created on the beforeLoad you just need that DOM code i sent you and then loop through the fixed length data although you won't be able to load the file using a client script
w
Watz
07/01/2022, 7:23 PMSorry, I'm populating the sublist in beforeLoad. So I just need to extract the data into a csv
Watz
07/01/2022, 7:24 PMJust need to get the headers as well.
Watz
07/01/2022, 7:40 PMThanks for the help @Eric B
👍 1
Watz
07/01/2022, 7:45 PM