Forum Discussion
MarkShnier__You
Qrew Champion
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
------------------------------
TimEgerton
2 years agoQrew Trainee
Hi Mark,
It still can't find the site.
// Procurement document name (Formula Rich Text) in Portal app. Created by pipeline.
var text Words = [Procurement Document];
// bskpdh396 is from the Procurement Manager app, Procurements table. PM Related Record ID# is from Procurement Manager app, Procurements table (created in Portal by pipeline) e27 is attachment field in Procurement Manager app.
var text URL = URLRoot() & "up/" & "bskpdh396" & "/a/r" & [PM Related Record ID#] & "/e27/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Tim Egerton
------------------------------
It still can't find the site.
// Procurement document name (Formula Rich Text) in Portal app. Created by pipeline.
var text Words = [Procurement Document];
// bskpdh396 is from the Procurement Manager app, Procurements table. PM Related Record ID# is from Procurement Manager app, Procurements table (created in Portal by pipeline) e27 is attachment field in Procurement Manager app.
var text URL = URLRoot() & "up/" & "bskpdh396" & "/a/r" & [PM Related Record ID#] & "/e27/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Tim Egerton
------------------------------
- MarkShnier__You2 years agoQrew ChampionFor the record you are testing on, is there a valid value in the field
[PM Related Record ID#]
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - TimEgerton2 years agoQrew TraineeHi Mark,
------------------------------
Tim Egerton
------------------------------ - MarkShnier__You2 years agoQrew ChampionThe field type needs to be Formula Rich Text. I believe the field you have is type Formula Text.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - TimEgerton2 years agoQrew TraineeHi Mark.
Aaaha!!
Works perfectly, thanks.
------------------------------
Tim Egerton
------------------------------ - MarkShnier__You2 years agoQrew ChampionGlad we got there on the end!
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------