Restrict inserting a new sales team line using insert, when existing line has a specific employee

 function validateInsert(scriptContext) {

      try {

        let currentSublist = scriptContext.sublistId

        if (currentSublist == ‘salesteam’) {

          let rec = scriptContext.currentRecord;

          let lineCount = rec.getLineCount({ sublistId: ‘salesteam’ });

          for (let i = 0; i < lineCount; i++) {

            let employeeId = rec.getSublistValue({

              sublistId: ‘salesteam’,

              fieldId: ’employee’,

              line: i

            });

            if (employeeId && employeeId.toString() === TARGET_EMPLOYEE_ID && checkForParameter(role) && !Object.values(SALES_ORDER_SALESTEAM_LOCK).includes(role) && mode == ‘edit’ ) {

              alert(‘Lines cannot be inserted as the Sales Team contains employee 9049 PDC-Hayward Warehouse’);

              return false;

            }

          }

          return performValidateDeleteOperation_AHAP1378(currentSublist)

        }

        return true

      }

      catch (err) {

        console.error(‘error@validateInsert’, err)

      }

    }

Leave a comment

Your email address will not be published. Required fields are marked *