how to remove item sublist lines in a workflow

AI generated answer (using internal Slack threads):

To remove item sublist lines in a workflow, you can use SuiteScript's

removeLine

method. However, you need to be careful with the order of deletion. If you delete from top to bottom, the sublist line count changes and your loop index may exceed the available sublist lines. Therefore, it's recommended to loop from bottom to top. Here is a sample code snippet that demonstrates this:

javascript
for (var i = fulfillTransform.getLineCount({ sublistId: 'item' }) - 1; i >= 0; i--) {
  var lineItem = fulfillTransform.getSublistValue({
    sublistId: 'item',
    fieldId: 'item',
    line: i
  });
  var lineBillingType = fulfillTransform.getSublistText({
    sublistId: 'item',
    fieldId: 'custcol_billing_type',
    line: i
  });
  if (soArray[a].items.indexOf(lineItem) === -1 || lineBillingType !== "One Time") {
    fulfillTransform.removeLine({
      sublistId: 'item',
      line: i
    });
  }
}

In this example, we're looping through the 'item' sublist from bottom to top. For each line, we're getting the value of the 'item' field and the text of the 'custcol_billing_type' field. If the item is not in our array of items (

soArray[a].items

) or if the billing type is not "One Time", we remove the line from the sublist. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******