URL for File Attachment
We have a table that is setup to allow a file attachment (PDF) to the record created (no separate table for attachments in this case). We would like to be able to directly link to the uploaded file s...
Forum Discussion
Can you post your current formula and also the resulting URL that you see?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sure Mark.
------------------------------
Jason Hartwig
------------------------------
- Maybe we should just try to answer your real question. Are you trying to create a link to the file?
"<a href='"& URLRoot() & "up/" &Dbid() & "/a/r" & [Record ID#] & "/e7/v0' target='_blank' >" & [File] & "</a>"
Replace e7 with the exx where xx is the field ID of the file attachment.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- That worked perfectly. Thanks Mark!
------------------------------
Jason Hartwig
------------------------------- Mark, I have a similar issue which works great if there's a file. However, not all of the records have a file attachment. What's the code if the field is empty? This is what I'm using: URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e16/v0"
------------------------------
Mike McCartney
------------------------------
