Forum Discussion
MarkShnier__You
Qrew Champion
Do the EOTI app records know the Record ID of the corresponding record in Manager?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
TimEgerton
2 years agoQrew Trainee
Hi Mark,
Yes it does we are passing the Manager app Record ID# over to the newly created record in the Portal app in the pipeline that creates the new record.
------------------------------
Tim Egerton
------------------------------
Yes it does we are passing the Manager app Record ID# over to the newly created record in the Portal app in the pipeline that creates the new record.
------------------------------
Tim Egerton
------------------------------
- MarkShnier__You2 years agoQrew ChampionOK, 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
------------------------------- TimEgerton2 years agoQrew TraineeHi 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
------------------------------- 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
------------------------------