Forum Discussion
TimEgerton
Qrew Trainee
Hi Mark,
Here's the code but it is saying Site can't be reached.
// Procurement document name (Formula Rich Text)
var text Words = [Procurement Document];
// dbid is from the Procurement Manager App, Procurements table. PM Related Record ID# is from Procurement Manager App, Procurements table.
var text URL = URLRoot() & "up/" & "_DBID_PROCUREMENTS" & "/a/r" & [PM Related Record ID#] & "/e12/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Tim Egerton
------------------------------
Here's the code but it is saying Site can't be reached.
// Procurement document name (Formula Rich Text)
var text Words = [Procurement Document];
// dbid is from the Procurement Manager App, Procurements table. PM Related Record ID# is from Procurement Manager App, Procurements table.
var text URL = URLRoot() & "up/" & "_DBID_PROCUREMENTS" & "/a/r" & [PM Related Record ID#] & "/e12/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Tim Egerton
------------------------------
MarkShnier__You
2 years agoQrew Legend
Two issues.
Replace the bq5m8kxxx with the similar looking characters form the URL from the Procurements table. It will be the string you see in the URL after the db/
Also is your field that holds the file attachment field ID#12? if not change to 12 to the correct field ID that holds the attachment.
var text URL = URLRoot() & "up/" & "bq5m8kxxx" & "/a/r" & [PM Related Record ID#] & "/e12/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Replace the bq5m8kxxx with the similar looking characters form the URL from the Procurements table. It will be the string you see in the URL after the db/
Also is your field that holds the file attachment field ID#12? if not change to 12 to the correct field ID that holds the attachment.
var text URL = URLRoot() & "up/" & "bq5m8kxxx" & "/a/r" & [PM Related Record ID#] & "/e12/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------