Forum Discussion
Would you mind posting your solution? Might help others if they come across your question. You could then mark your response as the solution.
If you wanted to have a field which looks like the file attachment field, that just downloads the file you can make this Rich Text formula field. It's also a great way to "lookup" a file attachment to a child table. Of course this is not really looking up the actual file attachment field but instead it's looking up a link that when you click, it will behave as a file attachment field and download the attachment.
There is also also slightly different syntax if the file attachment is is an image, and you want to display the image directly on the form or be able to look up the image down to a child table.
In this example the file attachment field is [Spec Sheet] and it is field ID# 12.
var text Words = [Spec Sheet];
var text URL = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e12/v0"; // replace the 12 with the field ID#.
"<a href=" & $URL & ">" & $Words & "</a>"