Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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: