When can you execute a search filter on a non-store value formula field with suitescript?

AI generated answer (using internal Slack threads):

In NetSuite SuiteScript, you can execute a search filter on a non-stored value formula field by setting up the

Formula (Text)

field as a criteria. This can be done by placing the field as the first field under the Results and Available Filters subtabs. However, it's important to note that the filter will only see the first formula in the criteria to filter with. For example, if you have a custom multi-select field and you want to use it as an available filter on saved searches, you can use a formula text field in the criteria with the custom field selected and the criteria set to % (wildcard). Then put the formula text on the available filters. Users will have to type in the value they want to filter on. However, this method will also give partial matches. For instance, if you have "San" and "Sans Serif" in your list, both would be pulled in if you searched for "San". To reduce this, you can use a formula like

{field}||','

and then search

%desired result,

. This forces a comma at the end, but it means someone has to remember to type in the % at the start and the , at the end every time. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******