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
Dashboard formula search
I have a custom field 18 characters long that need to search through. Users want to be able to search by last 6 chars of the field.
The following will correctly display only the last 6 characters in search results when used in a Formula (Text) field:
SUBSTR({fieldname},12,6)
I'm having trouble incorporating this into a dashboard search that will allow users to enter in the 6-char value and search through the records by it pulling up ones with last 6chars matching what the user searched for.
It's possible to enter the formula into criteria.. but the only way it will pull up a result is if the 6-character value is entered into the criteria. When attempting to search from the dashboard it consistently produces "no results found"....