Forum Discussion
MarkShnier__You
Qrew Champion
Ok, right, we don't need a Pipeline as you have a Relationship.
Create a Rich Text formula field on the record which has the attachment. In my example the file attachment field is called [Spec Sheet] and it is fid 12. So change e12 to your field ie like e99
var text Words = [Spec Sheet];
var text URL = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e12/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
Then, lookup that field down to the child and it will be a clickable link to open the file.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
TimEgerton
2 years agoQrew Trainee
Hi Mark,
They are two separate apps (for security reasons, one being EOTI), no relationship.
------------------------------
Tim Egerton
------------------------------
They are two separate apps (for security reasons, one being EOTI), no relationship.
------------------------------
Tim Egerton
------------------------------
- MarkShnier__You2 years agoQrew ChampionDo the EOTI app records know the Record ID of the corresponding record in Manager?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- TimEgerton2 years agoQrew TraineeHi 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
------------------------------- 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
------------------------------