Forum Discussion
Hey Savi,
I presume this link code is in a rich text field. If the doc is not in an attachment field what are you trying to share? A record? I think we need a bit more context before we can help on this. While I'm not sure exactly what's happening, I can share some formulas that have worked for me in the past:
Rich Text Clickable File Name:
var text URL=
URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e108/v0";
var text Name=
ToText([File Attachment]);
"<a href=" & $URL & ">" & $Name & "</a>"
Formula URL to show attachment address:
URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e7/v0"
*Note: Replace the e7 above with field ID of attachment, e43, or whatever it is.
This example assumes the attachment field is field ID 7. To make this work in your app you will need to replace the e7 in this string of characters with the field ID of your attachment field. So if in your app the attachment field is field ID 12, your formula would look like this: URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e12/v0'
Display attached image:
"<img src =" & URLRoot() &"/up/" & Dbid () & "/a/r" & [Record ID#] & "/e6/v0\" height=\"300\" width=\"375\" target=_blank />"
*Note: The same note applies to this formula. e6 should identify the field where your file resides, in this case Field ID 6
Thanks for all the information!
My goal is, when I create a new employee in our system, certain files are always available without me having to upload a new attachment. I want to upload it once and then have a formula display my uploaded file across all employees as part of the form.
This code worked in the old style form and still does when I go to the old form.