Forum Discussion

TimEgerton's avatar
TimEgerton
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's avatar
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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew 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's avatar
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      OK, 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
      ------------------------------
      • TimEgerton's avatar
        TimEgerton
        Qrew Trainee
        3 years ago
        Hi Mark,

        Here's the code but it is saying Site can't be reached.

        // Procurement document name (Formula Rich Text)
        var text Words = [Procurement Document];

        // dbid is from the Procurement Manager App, Procurements table. PM Related Record ID# is from Procurement Manager App, Procurements table.

        var text URL = URLRoot() & "up/" & "_DBID_PROCUREMENTS" & "/a/r" & [PM Related Record ID#] & "/e12/v0";

        "<a href=" & $URL & ">" & $Words & "</a>"

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