How to add an image with hyper link to the table

I am playing with Form design and I
could not figure out to manipulate the UI.  I would like to display an image
with a hyper link inside the table data instead of displaying raw data.    If the
fiel_id is null, I would like to display nothing.

Thanks,

yasushi

 

<a
href="/speed/web/hdwn/html/blank.html?mode=attach&file_id=xxx" title="View
Report"><img src="httpd://webserver/imgs/icons/excel.png" border="0"
align="top"></a>

 

IJC version: 5.5.1

Hi Yasushi,

Could I ask how this is to work, so that we have a better understanding of what you are looking for.

You are wanting to generate a URL (using a URL field?), but not have it disaplyed as the hyperlink text, but instead have an icon (excel.png) that acts as a hyperlink? This was the icon will be displayed on the form, and when you click on it the URL is opened in a web broweser?

If so then I don't think there is any direct way of doing this, but some ways that come quite close. We can look into how to get this working.

Please could you confirm the details.

Tim

Hi,

Here is what I would like to do but could not figure out yet.

I would like to create a column in which I could add data, in an image format (.png) which is then hyperlinked to our server where we keep all theses images either as separate image documents or as an image in an excel document.

Is this possible?

Many thanks

MC

 

Hi, if I understand correctly, you want to show images from a URL? It can be done by creating a URL field and setting renderer to Browser renderer on that field. Then simply copy the URLs (can be over http or on local HDD - more in the docs) to that field.

Please refer to the documentation for URL fields: http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/editing_database/fields_url.html

A basic overview of different renderers can be found: http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/managing_data/renderers.html

I'm attaching a screenshot showing Browser Renderer settings on URL field in Table widget settings.

Please let us know if this is what do you want to achieve and if it helps...

Filip

Hi Filip,

Yes it helps thanks.

But I am not quite where I want to be. So here is what I succeeded: I created a new URL field  (Static, type.jpg) And modified the widgets settings to Browser Renderer. Then I am able to add the link to a file by witing file:///C:.... then the image is diplayed in the box and I can open the image when I click and press Crtl.

So that´s great, but what I then tried was to link a .xlsx document which contains some data and the image that I would like to see displayed. So I added the file location, and when I click on the link it is actually able to open the Excel file but it does not display anything. Is there a way I could display an image (which could be a .jpg file for example) but keep my link to the actual document (as an Excel file)?

MC

This is unfortunatelly not possible as I know and honestly can't imagine, how it would work. For example what image to load if there is more images in the xlsx file?
I'm afraid that the only way how to show the images in IJC is to extract them from excel files.

Images can be also stored in the database in form of binary fields.

Regards,
Filip

In this case I think what I will do is probably have 2 columns. One with the image and the other with the link to find the document where the image is storred.

Many thanks for your help!

MC