ANS-0138 · SAVED SEARCHES & FORMULAS
Can a NetSuite Saved Search Column with a URL Link Be Sorted?
NetSuite users often seek to display customer numbers as sortable, unique hyperlinks within saved search results.
Short answer
Directly sorting a NetSuite Saved Search column that displays customer numbers as clickable URL links, while also ensuring no duplicate values and stable sorting behavior, is not fully achievable. NetSuite's current functionality presents limitations for sorting formula fields containing hyperlinks, necessitating a compromise in design.
Scenario
A common requirement in NetSuite involves creating a saved search column that displays customer numbers as clickable hyperlinks. Users often need this column to be directly sortable, contain no duplicate values, and maintain stable sorting behavior without disruption when interacting with the formula field. Fulfilling all these combined specifications simultaneously presents a challenge within NetSuite's saved search capabilities.
Solution
Based on the specified requirements, it is not possible to fully achieve all objectives simultaneously within NetSuite's saved search functionality. While it is technically feasible to create a saved search column that displays customer numbers as clickable URL links (preferably utilizing a Formula (HTML) field type for enhanced security and functionality), directly sorting by such a formula field remains a significant limitation. Current NetSuite documentation and community discussions confirm that formula fields containing hyperlinks often do not support reliable sorting. Furthermore, ensuring no duplicate values and preventing sorting disruptions when interacting with the linked column adds further complexity that cannot be fully resolved with standard saved search configurations. Therefore, a compromise approach is necessary, and the optimal solution will depend on prioritizing specific requirements.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support
