ANS-0762 · CUSTOM FIELDS, RECORDS & FORMS
How NetSuite UI Field Suggestions Filter Results
NetSuite's user interface fields utilize a 'starts with' filter for displaying suggestions, which impacts search results differently than a 'contains' filter.
Short answer
NetSuite's UI field suggestions operate on a 'starts with' logic, not 'contains.' This means that when typing into a field like 'Customer' on a sales order, suggestions will only appear if the entered text matches the beginning of a record's name. Searching for a word in the middle of a name will not yield results.
Scenario
Users may observe that when typing into certain NetSuite UI fields, such as the Customer field on a sales order, the system provides suggestions. However, if the search term does not begin with the exact sequence of characters in the record's name, no suggestions are displayed, leading to confusion about the filtering mechanism.
Solution
NetSuite's UI field suggestion functionality employs a 'starts with' filter rather than a 'contains' filter. This behavior dictates how records are presented as suggestions when a user inputs text into a field.For example:If a user inputs 'test' into the customer field on a sales order, NetSuite will suggest records like 'test vendor' because 'test' is at the beginning of the record name.Conversely, if a user attempts to search for 'vendor' when the record name is 'test vendor,' NetSuite will not suggest anything, as 'vendor' does not appear at the beginning of the record name.This filtering logic is consistent across standard UI fields that offer suggestions.
Expert NetSuite Support
Need help with this NetSuite issue?
Custom Fields, Records & Forms consulting and configuration support