File Link -> URL with Path
"https://core.federatedservice.com/apps/downloads/dynamic_workorder.php?"
& "clientid=Q1752"
& "&appid=bhv9szun5"
& "&tpdbid=" & [_DBID_DOCUMENT_TEMPLATES]
& "&tpid=1"
& "&fn=WorkOrd...
Forum Discussion
Appendix B: Managing files
https://target_domain.quickbase.com/up/DBID/a/rRID/eFID/vVID
Is that helpful at all for this?
The part you mention "rb33r" or similar is the record id encoded with QB32Encode(), they also have a decoding function. I checked and QB32Encode(59183) = b33r, the r is added on to the front by Quick Base as well. I pulled the record id from your screenshot.
This is something else I've seen done too. You might be able to just insert the record id instead of the encoded one.
"https://team.quickbase.com/up/bdb5rjd6h/a/r"; & [Record ID#] & "/e8/v0"
https://target_domain.quickbase.com/up/DBID/a/rRID/eFID/vVID
Is that helpful at all for this?
The part you mention "rb33r" or similar is the record id encoded with QB32Encode(), they also have a decoding function. I checked and QB32Encode(59183) = b33r, the r is added on to the front by Quick Base as well. I pulled the record id from your screenshot.
This is something else I've seen done too. You might be able to just insert the record id instead of the encoded one.
"https://team.quickbase.com/up/bdb5rjd6h/a/r"; & [Record ID#] & "/e8/v0"
Greatly appreciate all the replies. This is much more information than we started with.
Thanks again everyone for sharing your knowledge.Earl
------------------------------
Earl Adkins
------------------------------- MarkShnier__You
Qrew Legend
Earl,
Austin has the right approach. if you just want to create a link to a file that can be used on a child table, then the folual is
"https://team.quickbase.com/up/bdb5rjd6h/a/r" & [Record ID#] & "/e8/v0"
(there was an errant semicolon in Austin's post).
if you need a formula for a hyperlink so that the user sees a file name, then the formula would be
var text Words = totext([my file attachment field])
var text URL = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e7/v0"
//where you replace the 7 with the field ID of the file attachment field
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Many thanks Mark, I will be utilizing the knowledge gained through the insight provided here in the Community.
------------------------------
Earl Adkins
------------------------------
