This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How to get multiple formula column using search.load ? is there a way to get using name instead of column number ?

you get a column using the same parameters used to create it

so figure out how to create the formula column using script, then use that same column for result.getValue

but i don't want to create a new column in the script, there are already 3 formula text in the saved search that i'm loading, i want to get value of those 3. I want to try to eliminate the changes on the script if users want to change formula

how do you plan on identifying the different columns

hmm that's my question, maybe using label ?

then iterate through all the columns on the search and find the column with the label you are looking for

hmm alright, thanks for the direction given