Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Enter Multiple Values in Text Filter
I have a need to check specific transactions in a saved search. I have a saved search setup to give me the results I want, but I'm looking for an easy way to narrow the results to a list of specific sales orders, and I want to do this quickly and easily. Going into the criteria, and setting the transaction number to "any of" and searching for each order isn't a great option for me.
I'd like to use the "Transaction Number (text)" or a similar free text field as a filter, but I want to be able to paste a list of SOs in there, with some sort of delimiter. Can anyone think of a way to do this? Obviously the "Transaction Number (text)" field won't work as a filter, as it'll only look for one order at a time. I'm not sure if there's a way to structure a formula criteria that would allow me to paste these in, or really any way that I'm not thinking of.