NetSuite Tech Tip: Including Preview or Thumbnail Images in a Saved Search

Introduction

During a recent demonstration of our eXtendFiles SuiteApp, the prospect to whom we were presenting was blown away by a simple saved search that we shared. Having learned the prospect had been running on the NetSuite platform for some time, we were taken aback at their amazement to something that we commonly utilize in our daily work. She was dying to know… “How did you do that?!”

The Deets

The saved search that we presented included thumbnail images within the results. The images included thumbnails of various types of files including PDF, TIF, JPG, GIF and PNG. The results also included thumbnail images for some heavy weight file types such as AI, EPS, PSD, DST and EMB formats. In order to present thumbnails for these type of files, the eXtendFiles SuiteApp was configured to run those files through a lightweight image converter to generate preview and/or thumbnail images which are written back onto the custom record as JPGs for viewing within a web browser. Of course, all of the underlying files themselves are stored in an external cloud storage repository.

Below is an example of our saved search results.

The ‘Secret Formula’

The ‘magic’, as our prospect referred to it, was a simple solution to leverage a Formula (Text) type of field containing a case statement with embedded HTML code. Below is an example of the snippet.

If you’d like to be able to more clearly see and copy the actual code snippet, here it is:

CASE WHEN {custrecord_extend_files_thmbnail} IS NOT NULL THEN ‘<div style=”max-width: 200px; background-color: #fff; padding: 5px; border: 1px solid #EAEAEA; text-align: center;”><image style=”max-height: 200px; max-width: 200px;” src=’ || {custrecord_extend_files_thmbnail} || ‘><h1 style=”background-color: #EAEAEA; color: #666666; word-break: break-all; padding:5px; text-align: left;”>’ || {name} || ‘</h1></div>’ ELSE null END

For the non-programming readers, the formula checking for the existence of a thumbnail image on the custom record. If a thumbnail image is present, the image is sized accordingly and presented within the search results.

Conclusion

They say that a picture is worth a thousand words, but a picture within the results of a NetSuite saved search is pretty darn cool too!

If you are running NetSuite and are looking for applications to improve efficiencies within the platform, or maybe are just looking for some tips & tricks, please be sure to follow us on social media and/or connect with us.

eXtendTech is a NetSuite solution partner that develops applications to improve efficiency, productivity, and savings within the NetSuite platform.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Writing RawSQL in Ecto Phoenix

How to Migrate Data from Insightly to HubSpot: An Intuitive Switch

Finally! PVS-Studio Supports .NET 5 Projects

How to Become an Expert Programmer

HONEYPOTS — AN EXAMPLE WITH LARAVEL

Gym workout for beginners

Cartesi is Collaborating with Gather to Expand CTSI Utility

Speed, quality, or cheap software?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
eXtendTech Team

eXtendTech Team

eXtendTech is a NetSuite solution partner that develops applications to improve efficiency, productivity, and savings within the NetSuite platform.

More from Medium

System setup for Forlinx Embedded iMX8MP Platform

REJOICING IN REVERSE

Bioconcrete Technology and Neglected Biotoxicity | Biomedgrid llc

#Jen Network: Open Source Food Recovery Network