Forum Discussion
ChrisChris
8 years agoQrew 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.
- ChrisChris8 years agoQrew Assistant Captain
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.
- PriscilaCavalca8 years agoQrew TraineeThanks Chris... if I do it this way, will the image in the [Company Logo] automatically be updates if new images are added?
- ChrisChris8 years agoQrew Assistant CaptainYes, it will capture the latest update.