Sourcing URL Component in a Transaction Column Field through Script

 

Sourcing URL Component from the Item record > Web Store tab > Search Engine and Feeds field group.

The field is only available if the 'Descriptive URLs' feature is enabled in Setup > Company > Enable Features > Web Presence

 

I. Create a Custom Field

 

1. Navigate to  Customization > Lists, Records, & Fields > Transaction Column Field > New.

2. Add a Label for the field.

3. Store Value is checked.

4. Select Text Area for Type.

5. Check Sales Item in the Applies To tab.

6. Save the field.

 

II. Create a Client Side Script

 

1. Create a script with the following code

 

function clientValidateLine(type) {

 

var item = nlapiGetCurrentLineItemValue('item', 'item'); // Get the item ID of the selected line item

var url = nlapiLookupField('item', item, 'urlcomponent'); //Get the value URL Component of the item

 

var itemurl = nlapiSetCurrentLineItemValue('item','custcol_one', url); // item , internal ID of the ustom transaction column field, url

 

return true;

}

2. Save as SourceURLComponent.js.

3. Upload the script to NetSuite's File Cabinet under Documents > Files > SuiteScript. Click Add File.

4. Once the Open window has appeared, select SourceURLComponent.js.

5. Click Open to save the file in the File Cabinet.

6. Navigate to  Customization > Scripting > Scripts > New.

7. Select Client in the selection.

8. In the New Script window, add a Name.

9. Select the SourceURLComponent.js under Script File.

10. Add the 'clientValidateLine' under the Validate Line Function

11. Click Save and Deploy.

12. Select your Estimates under the Applies To tab. 

13. Set status to Release.

14. Add an audience.

15. Click Save.

 

Note: Since the script is set to a Validate Line Function, users need to add a line item on the transaction for it to trigger.