ANS-0015 · SAVED SEARCHES & FORMULAS
How to Export Images from NetSuite Saved Searches for Reporting?
Display images from NetSuite saved searches in reports using a simple Google Sheets integration.
Short answer
To export and display images from NetSuite saved searches, add a formula column in your search to generate image URLs. Export the search results as a CSV, then open the file in Google Sheets. Google Sheets' IMAGE function will render the images directly from the provided URLs.
Scenario
Users often need to include images from NetSuite records within their saved search reports. Standard NetSuite export options do not directly render images, presenting a challenge for visual reporting requirements. This guide outlines a method to effectively display these images using external tools.
Solution
Two primary approaches exist for exporting images within a NetSuite saved search for reporting purposes:1. Utilizing SuiteScript 2.0 with a FreeMarker template to generate the report.2. Leveraging Google Sheets for image display.The recommended solution involves using Google Sheets. To display images, the =IMAGE("") function within Google Sheets is employed.Follow these steps to implement this solution:1. Add a column field to the NetSuite saved search with the following formula:'=IMAGE("https://system.sandbox.netsuite.com' || || '";1)'2. Export the saved search results via CSV format (not XLS).3. Open the exported CSV file in Google Sheets. The IMAGE function will then render the images based on the URLs provided in the formula.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support