Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Saved Search - 'Has Keywords' not appear when setting up criteria for a Formula (Text) Field
Hi,
I'm building a search that allows us to look up keywords in a Formula (Text) field. This field concatenates multiple strings and separates them with commas - so now, technically, what's contained in this Formula (Text) field is a one big string.
Eg: The Formula (Text) field concatenates elements in column A,B,C and separates them with commas.
| Order No. | A | B | C | Formula (Text) |
|---|---|---|---|---|
| 1 | Apple | Banana | Cherry | Apple,Banana,Cherry |
| 2 | Cherry | Cherry | Apple | Cherry,Cherry,Apple |
| 3 | Cherry | Apple | Banana | Cherry,Apple,Banana |
| ... |
My goal is to set up a filter that allows users to look up records (Order No.) whose Formula (Text) field contains the keywords that they are looking for. For example:
6