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,
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?
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?