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
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.