Forum Discussion

PriscilaCavalca's avatar
PriscilaCavalca
Qrew Trainee
8 years ago

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

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's avatar
ChrisChris
Qrew Assistant Captain

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.



PriscilaCavalca's avatar
PriscilaCavalca
Qrew Trainee
8 years ago
Thanks Chris... if I do it this way, will the image in the [Company Logo] automatically be updates if new images are added?