Irina Mitrova
11/06/2024, 11:03 AMCeligo AI
11/06/2024, 11:03 AMAI generated answer (using internal Slack threads):****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To create a sublist in the customer record with all available subsidiaries as rows and another custom column which is manually set, you can follow these steps: 1. Create a new custom record. This custom record will serve as the sublist in your customer record. 2. In your custom record, create a field that will serve as a foreign key to the customer record. This field should be marked as the "parent" in the custom record definition. 3. Add the subsidiaries as rows in your custom record. You can do this programmatically using SuiteScript. Here's a sample code snippet on how to do this:
javascript
recObjLoaded.selectNewLine({sublistId: 'submachine'});
recObjLoaded.setCurrentSublistValue({ sublistId: 'submachine', fieldId: 'subsidiary', value: subsidiariesArray[x] });
recObjLoaded.commitLine({ sublistId: 'submachine' });
4. Create another custom field in your custom record. This field will serve as the custom column that you can manually set.
5. Add this custom record as a sublist to your customer record. You can do this by adding it to a subtab on the customer record form.
Remember, you need to have the appropriate permissions to create and modify custom records and forms in NetSuite.Celigo AI
11/06/2024, 11:03 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.849158406
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846398234
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844810605
Celigo AI
11/06/2024, 11:03 AM