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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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"....