Contact Us
Three netsuite consultants working on Laptop.

The Problem: Saved Search Shows Internal File URLs

A client wanted to create a search to catalog all product image files in the File Cabinet used on their webstore, meaning files with external URLs.

They ran into an issue: in a Document saved search, the URL field displayed only the internal NetSuite URL, even though the File record had an external URL.

In the image below, three URLs appear on the File record:

  • Green: External live-site URL
  • Yellow: Staging-site URL
  • Red: Internal NetSuite URL

The saved search could display only the third URL natively.

So, how could we display the external URL instead?

fd124eb2-e6b2-4929-8525-9bde9da76954.png

The Solution: Build the External URL with a Saved Search Formula

At first, I thought a Suitelet would be needed to drill into the File record and act as a proprietary saved search, preserving the results page and export features. That approach would have taken too much time and money, so I looked for another solution.

Could a workflow capture the correct external URL in a custom field shown in the saved search results? Unfortunately, custom fields and workflows couldn't be applied to File records for this approach.

Then I noticed the external URL followed a fixed format, with the hosted file name included.

Could I build a saved search formula to append the file name to the URL?

Yes! Since the file name was always in the URL, I could dynamically append it to the fixed URL using the CONCAT function, joining two strings into one.

ef64f929-2001-4bfb-879d-416b1b6aa32a.png

The Result

This fixed the issue by replacing the {url} field and incorrect URL with a dynamic formula that displayed the external image URLs.

Digging a bit deeper and brainstorming different solutions saved the client up to 15 hours!

Related Articles

NetSuite Saved Searches: How to Create, Customize & Schedule Reports

NetSuite saved searches are one of the most useful no-code reporting tools in NetSuite. They let you pull real-time data from transactions, customers, items, vendors, employees, and custom records using filters, result columns, formulas, and scheduled delivery. A well-built saved search can replace recurring manual reporting, support workflows, and surface live operational data on dashboards. If standard NetSuite reports do not give you the exact view you need, saved searches usually fill the gap. You can build searches for overdue invoices, inactive customers, inventory below reorder point, purchase orders past due, pending approvals, and many other use cases without writing code. This guide explains how to create a NetSuite saved search, customize it with formulas and joins, schedule it for email delivery, add it to a dashboard, and avoid common performance and configuration mistakes.

Read the Article Two netsuite consultants seated at a table, reviewing a notebook, with a closed laptop and papers laid out in front of them.

Tagged with Troubleshooting