Adding hyperlink in saved search column

Requirement

Add a hyperlink in saved search to open the particular purchase order.

Solution

Following code snippet is a saved search code having hyperlink that open up a purchase order.

 var purchaseorderSearchObj = search.create({
                type: "purchaseorder",
                filters:
                    [
                        ["type", "anyof", "PurchOrd"],
                        "AND",
                        ["status", "noneof", "PurchOrd:G", "PurchOrd:H", "PurchOrd:F"],
                       
                       
                    ],
                columns:
                    [
                        search.createColumn({
                            name: "ordertype",
                            sort: search.Sort.ASC,
                            label: "Order Type"
                        }),
                        search.createColumn({name: "internalid", label: "Internal Id"}),
                        search.createColumn({name: "trandate", label: "Date"}),
                        search.createColumn({name: "tranid", label: "Document Number"}),
                       
                        search.createColumn({
                            name: "formulatext",
                            formula: "'<a href=\"https://6753382-rp.app.netsuite.com/app/accounting/transactions/purchord.nl?id='||{internalid}||'\" target=\"_blank\">'||{tranid}||'</a>'",
                            label: "PO"
                        }),
                        search.createColumn({
                            name: "entityid",
                            join: "vendor",
                            label: "Name"
                        }),
                        search.createColumn({
                            name: "location",
                            join: "item",
                            label: "Location"
                        }),
                        search.createColumn({
                            name: "quantityavailable",
                            join: "item",
                            label: "Available"
                        }),
                       

                    ]
            });
            var searchResult = purchaseorderSearchObj.run().getRange({
                start: 0,
                end: 1000
            });

            return searchResult;
        }