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?

10 Replies

Related Content

delete field attachments

How to add list of attachments on child record from parent record

Outlook Pipeline attachments

Deleting Attachments

Multiple Attachments

Recent Discussions

Question about relationships

Reports & Charts - Managing Client-Specific Name Visibility

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?