How to disable the column

if (scriptContext.sublistId == ‘item’) {

          let lineNum = currentRec.getCurrentSublistValue({ sublistId: scriptContext.sublistId, fieldId: ‘line’ })?.toString()?.trim();

          let lineKey = currentRec.getCurrentSublistValue({ sublistId: scriptContext.sublistId, fieldId: ‘lineuniquekey’ })?.toString()?.trim();

          let lineIndex = currentRec.getCurrentSublistIndex({ sublistId: ‘item’ });

          if (lineNum && lineKey) {

            let lineValue = Number(currentRec.getCurrentSublistValue({ sublistId: scriptContext.sublistId, fieldId: ‘quantitybilled’ })?.toString()?.trim() || 0);

            if (lineValue) {

              let sublistObj = currentRec.getSublist({ sublistId: scriptContext.sublistId });

              for (let field of fieldIdsToMonitor) {

                if (field) {

                  let columnObj = sublistObj.getColumn({ fieldId: field });

                  if (columnObj) {

                    columnObj.isDisabled = true;

                    let fieldObj = currentRec.getSublistField({

                      sublistId: ‘item’,

                      fieldId: field,

                      line: lineIndex

                    });

                    if (fieldObj) {

                      fieldObj.isDisabled = true;

                    }

                  }

                }

              }

            }

            else {

              let fieldObj = currentRec.getSublistField({

                sublistId: ‘item’,

                fieldId: ‘price’,

                line: lineIndex

              });

              if (fieldObj) {

                fieldObj.isDisabled = false;

              }

            }

Leave a comment

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