How do I get an Image (file attachment field) to appear on the list report of main table page?

Question

How do I get an Image, which is currently a field in a form as a "file attachment",  to appear as a much smaller version on a list report pertaining to that table?

chrischris · Answer

You can use this code to capture the URL of the object in the file attachment field::

Below is a URL field. Call it [Company Logo URL]

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0/" & [Image]

[image] is the file attachment field.

===

Then....

Create a formula text field. Call it [Company Logo]

"<img src='" &[Company Logo URL]& "' width='148px' alt='"&[text field with text]&"' title='"&[text field with text]&"'>"

Put [Company Logo] in your report.

mcfneil · Answer

Or you can just go straight to the formula text field for the image, and use something like this:

"<img height=\"80\" src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e41/v0\" />"

changing the "41" to the field ID of your file attachment field.

chrischris · Answer

Pricilla,

I should have pointed out that the "6" in the code for [Company Logo URL] is the Field ID of the [Image] file attachment field. You'd probably need to edit that accordingly for your needs. Sorry about that oversight.

priscilacavalca · Answer

Thanks Chris... if I do it this way, will the image in the [Company Logo] automatically be updates if new images are added?&nbsp;

priscilacavalca · Answer

Hi Matthew, this worked out perfectly. However, if I update the [image] field the new field which we called [display image] does not update with the current image. Is there something that can be done automatically or manually every time a new image is uploaded so that it can be reflected in the main table page?&nbsp;

Forum Discussion

How do I get an Image (file attachment field) to appear on the list report of main table page?

Related Content

Attachment - file name

PDF Document Generator, automatically attached to a record

Find and Replace Field Values

IF Statement based on a file being attached

Mass download of file attachment fields