June 13, 2017

Lookups and Multiselect Fields

Multi-select fields are notoriously troublesome to work with in SuiteScript, and the way they behave in a Lookup is no different.

Lookups will return any Select or Multi-select field value as an Array. The Array will contain Objects, and each Object will contain both a value and a text property.

The value property contains the internal ID of the selected value, while the text contains the name displayed for the selected value.

If nothing is selected in either a Select or a Multi-select field, then an empty Array is returned.

Perhaps it’s best shown with an example. Here I’m looking up the Supervisor (a Select field), Skills (custom multi-select field), and Interests (custom multi-select field) on an Employee record. I’ve selected multiple Skills for the Employee, but I’ve selected none of the Interests.

var empData = s.lookupFields({
    type: s.Type.EMPLOYEE,
    id: employeeId,
    columns: [
        "supervisor", // a Select field
        "custentity_skills", // a Multi-select field
        "custentity_interests" // a Multi-select field

var supervisorId = empData.supervisor[0].value; // "12345"
var supervisorName = empData.supervisor[0].text; // "Eric T Grubaugh"

var firstSkillId = empData.custentity_skills[0].value; // "3"
var secondSkillName = empData.custentity_skills[1].text // "SuiteScript 2.0"

var noInterests = empData.custentity_interests; // []
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Related posts

March 3, 2021

Does the physical location of a competent employee change the amount of value they can deliver for your organization? If it does, I’d be keen to hear your story. If it does not, why ...

Read More

March 2, 2021

Today a friend and former colleague of mine – who happens to now be in a development leadership role for a NetSuite partner – was lamenting the extreme difficulty of finding and hiring NetSuite ...

Read More

March 1, 2021

Software is never finished; clients are always changing and re-prioritizing. NetSuite is ever a moving target – always updating and evolving. Market forces are always shifting and shoving, forcing new demands on your business. ...

Read More