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

Custom record with only a 'name' column. Want to map the name to the internal id without running a search on each name value. Can't do any anyof with an array because it's text.

Custom record with a single name column. If I want a filter in a search based on a list field sourced from that custom record need to use internal ids not names.

Still not clear what you're trying to accomplish. You have a custom record that only has a `name` field. You want to make the internal ID of each instance match its `name`?

I want to create a search filter using 'anyof' and pass it an array of 'names'. Only works with internal ids though.

Wondering simplest way to get the internalid for each 'name'

Oh, yeah you won't be able to search text that way

Seems silly to do a single search for each name first

just to get the ids for the main anyof search

Seems like I run across this periodically

Well, you can search for multiple text values, you just can't do it as simply

You're doing this in code? Or in a saved search?

Basically instead of
```
['name', 'anyOf', listOfNames]
```

you need to do:
```
[
  ['name', 'is', "name1"],
  "OR",
  ['name', 'is', 'name2'],
  'OR',
  // ...
]
```

But that's the format you'll need your filters to be in