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 of attachments from the Manager to the Portal.Is it possible to have a Button in the Portal app that downloads a related attachment in the Manager app?------------------------------Tim Egerton------------------------------

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

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

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 e99var 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------------------------------

Hi Mark,They are two separate apps (for security reasons, one being EOTI), no relationship.------------------------------Tim Egerton------------------------------

Do the EOTI app records know the Record ID of the corresponding record in Manager?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Button to download attachments from a separate app

MarkShnier__You
Qrew Legend
3 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
  3 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 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
    ------------------------------

Forum Discussion

Button to download attachments from a separate app