Forum Discussion

Qrew Trainee

3 years ago

Button to download attachments from a separate app

We have a EOTI app "Procurement Portal" and a seperate app "Procurement Manager" and use a pipeline to copy some data from the second app to the first however pipelines doesn't allow the the copying o...

Buttons

Formulas and functions

TimEgerton

Qrew Trainee

Hi Mark,

Thanks for the reply.

The attachment is uploaded to the Manager app first but we want an EOTI user to be able to download the attachment from the Portal app.

We can get the "attachment" to the Portal using your "Text" field solution but when we try and download it using a Button it says, rightly enough, field is not an attachment.

So we need to copy the Manager attachment to the Portal or download it from the Manager app with a Button on the Portal app.

------------------------------
Tim Egerton
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

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
Qrew Trainee
3 years ago
Hi Mark,

They are two separate apps (for security reasons, one being EOTI), no relationship.

------------------------------
Tim Egerton
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  Do the EOTI app records know the Record ID of the corresponding record in Manager?
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
  - TimEgerton
    Qrew Trainee
    3 years ago
    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
    ------------------------------