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.
Formulatext column is causing duplicate results
I'm performing a search on all customers. I have a custom field on customer records that holds the id of a chosen contact. I've formatted the search columns like so to get the chosen contact's info:
var contactName = new nlobjSearchColumn('formulatext');
contactName.setFormula("CASE WHEN {contact.internalid} = {custentity_customcontact.ID} THEN {contact.entityid} END");
columns.push(contactName);
For testing I filter the search on my test customer ID. Without the formulatext column, I get one response object. With the formulatext column pushed onto my columns, I get two response objects. One with the entityid of the desired contact. The other response object has the entityid column blank, or a default value. For example when I include "...THEN {contact.entityid} ELSE 'default value' END", a second object is returned with "default value" in the contactName column.