NSC | SuiteScript: Validate if a Field’s Value Already Exists in Another Custom Record

In some instances, we use identifiers other than the internal or external IDs of the records. This could be a concatenation of multiple fields, or auto-generated number from another system that is integrated with the current.

The script below will run a search that finds the value of the field and returns an error when it detects a duplicate.

/**
 * @NApiVersion 2.1
 * @NScriptType UserEventScript
 */
define(['N/search','N/error'],
    
    (search,error) => {

        /**
         * Defines the function definition that is executed before record is submitted.
         * @param {Object} scriptContext
         * @param {Record} scriptContext.newRecord - New record
         * @param {Record} scriptContext.oldRecord - Old record
         * @param {string} scriptContext.type - Trigger type; use values from the context.UserEventType enum