Hi all, does anyone know a formula to display the image from a url in a saved search?

Have you tried: formula (text) : ‘<img src=“image url”>’

would i replace "image url" with our field that contains the url?

Yup!

gotcha! unfortunately, im getting an ERROR: Invalid Expression

Try ‘<img src= “{custitem_image_url}”>’

'<div><img src="link_to_photo.png" width="75px" /></div>'

used in conjunction with a case statement in a text formula field. per this blog https://www.callawaycoffee.com/case-when-statements-in-netsuite/

thank you! i was able to get this to appear:

looks like your link is broken?

CASE WHEN {includechildren} = 'T' THEN '<div><img src="“{custitem_image_url}" width="100px" /></div>' ELSE '<div> </div>' END

Do you have “Disable HTML in Seach Formula (Text)” enabled in Setup> General preferences? 🤔

nope, we do not!

Based on that formula, your image link will be the string

{custitem_image_url}

, not the value of the field with that ID.

Change your formula to this CASE WHEN {includechildren} = 'T' THEN '<div><img src="’|| {custitem_image_url} ||’" width="100px" /></div>' ELSE '<div> </div>' END Note there is a double quote then single quote after img src=