Forum Discussion
MarkShnier__You
Qrew Champion
OK, so we can create the same field but on the child table.
var text Words = [Spec Sheet]; // you will need to populate a field in the EOTI app with the file name with the file name
// change the "xxxxxxxx" below to the dbid characters you see in the URL of the Manager Table.
var text URL = URLRoot() & "up/" & "xxxxxxxxxxxx" & "/a/r" & [Record ID# of the Manager Record] & "/e12/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
// Be sure to remember to locate the checkbox on the properties of the file attachment field on the Manager table and enable the file to be viewed without logging in.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var text Words = [Spec Sheet]; // you will need to populate a field in the EOTI app with the file name with the file name
// change the "xxxxxxxx" below to the dbid characters you see in the URL of the Manager Table.
var text URL = URLRoot() & "up/" & "xxxxxxxxxxxx" & "/a/r" & [Record ID# of the Manager Record] & "/e12/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
// Be sure to remember to locate the checkbox on the properties of the file attachment field on the Manager table and enable the file to be viewed without logging in.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
TimEgerton
2 years agoQrew 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__You2 years agoQrew ChampionTwo 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
------------------------------ - TimEgerton2 years agoQrew TraineeHi 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
------------------------------ - 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
------------------------------