how do I access a custom lists' value column? I found from stackoverflow that the abbreviations can be accessed with search.create, but this script errors out when I try to pull the value column:

search.create({
    type: 'customlistmxapparelcolors',
    columns: [
      search.createColumn({name: 'abbreviation', label: 'abbreviation'}),
      search.createColumn({name: 'internalid', label: 'internalid'}),
      // search.createColumn({name: 'value', label: 'value'}),
    ]  
});

Thank you for any help!

create the search in the ui first, ids dont need to match between searches and records

how do I create the search in the ui first? are you saying there's a way I can create a customlist search by going thru Reports -> New Search, and that will lead me to being able to script a solution to get the values column on custom lists?

Whats the internal id number of the list

customlistmxapparelcolors

, it's a custom list created thru the Matrix Item Assistant, and I had to manually change its id, if that matters at all, but I think a custom list is just a custom list in NS?

what the url used to edit the custom list

it's https://acctwhatever.app.netsuite.com/app/common/custom/custlist.nl?id=312&e=T&ord=T

the internal id is 312

oh wow that's really cool, I wish there was a way to access a custom list without having to save a search thru ui (spent a lot of time experimenting with both

N/search

and

N/query

libraries with no dice), but you have given me something I can at least automate off of, thank you for your genius advice battk!!!

you can also load your custom list as a custom record using

customlist

as the type and the internal id as the id