Forum Discussion
TimEgerton
Qrew 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__You
2 years agoQrew Legend
For 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
------------------------------
[PM Related Record ID#]
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- TimEgerton2 years agoQrew TraineeHi Mark,
------------------------------
Tim Egerton
------------------------------ - MarkShnier__You2 years agoQrew LegendThe 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 LegendGlad we got there on the end!
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------