Forum Discussion

TimEgerton's avatar
TimEgerton
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 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
------------------------------
Buttons
Formulas and functions

15 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    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's avatar
      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's avatar
        MarkShnier__You
        Qrew #1 Challenger
        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
        ------------------------------