Welcome back to SuiteTip, your ultimate guide to mastering NetSuite's capabilities! In this edition, we'll explore the art of incorporating hyperlinks into your Saved Search Results using Formula (HTML), taking your data presentation to the next level.
Enhancing Saved Searches with Hyperlinks
NetSuite's Saved Search feature is a powerful tool for creating custom reports and analyzing data. By adding hyperlinks to your search results, you can provide quick access to related records, web pages, or even external resources, making your reports more interactive and informative.
Adding Hyperlinks to Saved Search Results:
- Navigate to Lists > Search > Saved Searches.
- Create a new search or edit an existing one.
- Go to the Results tab, and select the 'Formula (HTML)' in the field list.
- Give your column a label (example: "Link", "Print", "View Related Record", etc.)
- In the Formula box, use the following HTML format: <a href="URL">Link Text</a>
- Replace URL with the actual URL you want to link to.
- Link Text is the visible text users will click on.
- Preview and then Save your search.
Sample Scenario:
Problem: You have a Saved Search for Work Orders. You want to be able to easily print the Picking Ticket from the related Sales Order without having to open each Work Order or Sales Order record. (see thread: printing picking ticket from a saved search)
Solution: Add this formula in a Formula (HTML) field in the Results tab of the Search:
'<a href="https://XXXX.app.netsuite.com/app/accounting/print/hotprint.nl?regular=T&sethotprinter=T&id='||{createdfrom.internalid}||'&label=Picking+Ticket&printtype=pickingticket&trantype=salesord&whence=&print=T" target="_blank">Print</a>'
Notes:
- Replace XXXX with your NetSuite account number.
- Used double pipe symbols to concatenate the URL and the Internal ID of the Sales Order related to the Work Order.
- Including the target="_blank" attribute means that left-clicking the link will automatically open it in a new tab.
By utilizing Formula (HTML) fields, you can transform static reports into dynamic, interactive dashboards, empowering your team with actionable insights.
---
Stay tuned for our next SuiteTip, where we’ll explore more tips and best practices for navigating NetSuite Reports and Saved Searches!
We encourage you to share your own tips, ask questions, and engage with fellow community members. Your experiences can help others on their journey to becoming NetSuite analytics experts!