Displaying a small image of an attachment.
I have a File Attachment field named Picture 1 which is used to attach pictures of the equipment being serviced. Right next to the attachment field, I want to display a small image of the picture...
Forum Discussion
Got it... I removed the "If([Picture]" and it is working perfectly... thanks for the rich text suggestion. For reference for others that might stumble upon this... the final definition that works is:
Have your file attachment field.
create a new formula Rich Text field.
define the formula for new field:
"<a href=\"" & URLRoot() & "/up/"& Dbid () & "/a/r"&
[Record ID#] &"/e36/v0\" /> "&
"<img src=\"" & URLRoot() & "/up/"& Dbid () &"/a/r"&
[Record ID#] &"/e36/v0\" height=\"200\"alt='' />" & "</a>"
Where the 36 in e36 is the fid of the file attachment field.
Have your file attachment field.
create a new formula Rich Text field.
define the formula for new field:
"<a href=\"" & URLRoot() & "/up/"& Dbid () & "/a/r"&
[Record ID#] &"/e36/v0\" /> "&
"<img src=\"" & URLRoot() & "/up/"& Dbid () &"/a/r"&
[Record ID#] &"/e36/v0\" height=\"200\"alt='' />" & "</a>"
Where the 36 in e36 is the fid of the file attachment field.