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

I have a saved search that has a column

`search.createColumn({`
`name: "displayname",
join: "item"})`

How can I retrieve the value with

`result.getValue`?

I tried `result.getValue("displayname"}`
but it's null.

```result.getValue({
    name: "displayname",
    join: "item"
})```

if with join, or summary, you gotta include that in your get value!

basically aside from label, just mimic the exact column and you wont fail

also never forget to return true, but thats a different story :slightly_smiling_face:

It might be easier to create an array of your columns, pass that array to your search creation and reference that array when processing results.  `result.getValue()` has 2 ways, like `result.getValue(columns[i])` or object form as used above.

If you have formulas (especially long ones), the column index method is much more convenient