URL Formula to open file attachment
Ok - I may be missing something easy here, but I need help. I have a file attachement field that may or may not have a pdf attached. Is it possible to have a URL Formula (so I can have a button...
Forum Discussion
try this....assuming the name of the file attachment field is Document
create a new field, type should be formula text - check off "allow html"
if ([Document]>"", "<a href=\"" &URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#]& "/e999\"target=_blank\">" & [Document]& "</a>","")
change the 999 in e999 to be the field id of the Document field
Keith
create a new field, type should be formula text - check off "allow html"
if ([Document]>"", "<a href=\"" &URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#]& "/e999\"target=_blank\">" & [Document]& "</a>","")
change the 999 in e999 to be the field id of the Document field
Keith
- Hi Keith,
When I do this, the document downloads and the user still has to click the downloaded file on the bottom left of their screen in order to view the document.
Functionality-wise, there is no difference between this approach and the link that Quick Base creates when adding a field of type "File Attachment" .
Is there no way to make it so that the document opens instantly when clicking the link, therefore eliminating that second click?
Thanks in advance. - Hi Keith,
This works perfect when is empty, but when I have a file the link shows but with the formula. Is there any way for the formula not to show?
