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 need a saved search formula for checking something like if values 1 is in [2,3,4,5,.. 10].

In sql, I'd just do a where 1 in (2,3,4...10). Is this possible with a saved search formula?

`REGEX_*` functions are also good for simplifying complexity like that down .  they are  going to be less performant but you might not notice

So I have this formula, but it's making me type out the text of the list. Is there a way to have it look at the internal id?

case when {custcol_mhi_ad_line_intgrtn_status} = 'Success' then 1 else 0 end

nvm. apparently adding .id returns it

Thanks everyone!