I hope you are doing well. I am setting up a NetSuite mass update to update email addresses for quotes with particular quote numbers. The "Quote Number" field is a text field. I've discovered that the "anyof" operator isn't available for this field within the mass update criteria. My current solution involves adding an "OR" condition in a mass update criteria for each individual quote number I need to include, which seems inefficient. Could you suggest a more concise way or a formula to filter by multiple text values in this "Quote Number" field within the mass update criteria, avoiding the need for multiple "OR" statements?
( Quote Number (Custom Body) is 10022549 Or Quote Number (Custom Body) is 10014047 Or Quote Number (Custom Body) is 15001530 Or Quote Number (Custom Body) is 10022520 Or Quote Number (Custom Body) is 10022283 Or Quote Number (Custom Body) is 10030577 Or Quote Number (Custom Body) is 10023842 Or Quote Number (Custom Body) is 10024114 Or Quote Number (Custom Body) is 10024115 Or Quote Number (Custom Body) is 10024374 Or Quote Number (Custom Body) is 10024982 )
I'd use formula numeric and "IN"
CASE WHEN {yourfield} IN ('123','999') THEN 1 ELSE 0 END
With the condition of "equal to 1".
I'd probably prepare it in excel with a formula
=CONCAT("'",A1,"',")
And just drag down and remove final comma.
Here's some documentation, it's for transact sql but it should be close enough: https://learn.microsoft.com/en-us/sql/t-sql/language-elements/in-transact-sql?view=sql-server-ver16
As a note, there is a limit for the amount of text you can put in those formula inputs, but if you're blowing that limit I think you probably need to rethink how you're looking for this info.