Forum Discussion

Qrew Trainee

2 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...

Formulas and functions

MarkShnier__You

Qrew Champion

2 years ago

In fact there is a Pipeline step under QuickBase called "Attachments" which can upload an Attachments. It was the old Automations that could not do that.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

TimEgerton
Qrew Trainee
2 years ago
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 Champion
  2 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
    2 years ago
    Hi Mark,
    
    They are two separate apps (for security reasons, one being EOTI), no relationship.
    
    ------------------------------
    Tim Egerton
    ------------------------------