NetSuite multiple select field types allow you to include multiple values in a single field. The image below shows a multiple select custom field (Copy Employee) that pulls from the employee records list.
You can select multiple items to include in the custom field. Two employees are selected in the following image.
The field includes all selected items after you save your selection.
Export a multiple select field from a scheduled flow
In a scheduled flow that uses a saved search, integrator.io exports the multiple select field as a string with each value separated by a comma.
Export a multiple select field from a real-time flow
In a real-time flow, integrator.io exports a multiple select field as an array of objects, and each object contains a selection from the list on the export record. If the field’s source list is a list of records, then each object has an internal ID property and a name property. Continuing from the previous example, the Copy Employee field’s internal ID is custbody17, so it exports as property custbody17 with an array of objects as the value type.
Import mapping for multiple select fields
To map multiple values to a multiple select field, use either an array of the values (name or internal ID) or a string of comma-separated values without spaces. The following image is an example of a string of name values separated by commas without spaces mapped to the Copy Employee field.
The following image is an example of a string of internal ID values for employee records mapped to the Copy Employee field. The internal IDs are separated by commas without spaces. The NetSuite field is Copy Employee (Internalid) instead of Copy Employee (Name) as shown in the previous image.
The following image is an example of an array of values mapped to the Copy Employees multiple select field. The Copy Employee (Name) property is mapped to the multiple select field.
You can use the same strategy with internal IDs. In the below image, the Copy Employee property is an array of internal ID numbers. The property is mapped to the Copy Employee (Internalid) field.