how to displaying image URL into image thumbnail on netsuite saved search

I made a search, not a search of files. ( I was searching for support cases )

in the results, I made a formula text field and put this as the formula.  ‘<img height=”200″ length=”200″ src=”‘|| {file.url} ||'” alt=”no img”>’

make sure to include all of the ‘  . you need the starting and ending ones

This will show a record for each file attached to the record.

So if you are just trying to show the image file make sure to make your filters appropriately

I used ‘<img height=”200″ length=”200″ src=”‘|| ’{item.imageurl} ||’” alt=”no img”> but the result still showing ERROR: Invalid Expression

I attached the SS

Can you check please

Hi

Not sure if it is a typo error but it seems that on your reply  (I used ‘<img height=”200″ length=”200″ src=”‘|| ’{item.imageurl} ||’” alt=”no img”> but the result still showing ERROR: Invalid Expression)  it is missing the ‘ at the end of the expression. It should be ‘<img height=”200″ length=”200″ src=”‘|| ’{item.imageurl} ||’” alt=”no img”>’

Thanks

Edo

Hi  Edo,

Thanks for your quick response, I follow exactly the same formula, but still, the result shows “ERROR: Invalid Expression”

Please see below

Thanks,

Uchi

Hi Uchi

The formula should be: ‘<img height=”200″ length=”200″ src=”‘|| {item.custitem3} ||’” alt=”no img”>’

In your screenshot I can see a ‘ before the first curly bracket.

I hope this helps

Edo

Hi Edo,

Hope you are doing well,

I think now the formula is working, the  invalid expressions did not appear anymore, but I don’t know why the image is still not displayed on  the saved search, please see below

when I click on the URL, the image easily appear in a new tab, but does not pull out into the saved search even if the formula is correct?

could you advise please,

Regards,

Uchi

Hi Uchi

I think you need to store your images in the file cabinet and use the relative URL in the source property.

Thanks

Edo

Hi Edo,

We put our weblink product on the item page as below, can it be pulled up to the save search?

Thanks,

Uchi