Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
8 years ago

Has anyone used the the Actions feature to copy a file attachment from one table to another.

Has anyone used the the Actions feature to copy a file attachment from one table to another. That is the only field that does not seem to transfer.

I have created an app to house customer approval responses. I am using Actions to create a new record in that cross link app table so that I can set up the email as Public and embed the Accept/Decline response and feed it back to the parent app and record. I can get everything to transfer except the actual attachment..it does not even create a link. Trying to keep this simple for the simple mind

Thanks for any help!
File attachments

7 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Well here is a work-a-round.  In the source table create this formula URL field

    URLRoot() & "up/" & dbid() & "/a/r" & [Record ID#] & "/e30/v0"

     and change the e30 to eXX where XX is the fid of the field with the file attachment.

    You can then test that in the source app.  It should download the file when clicked.

    Set the field properties for that file attachment field to check the box to allow public access (ie to view).

    Then copy across that link with your Action.
    • HemaRajendran1's avatar
      HemaRajendran1
      Qrew Trainee
      4 years ago
      Hi Mark, I tried using this formula in my Source table(Table 1) to copy the attachment document from Table 1 to Table 2. Quickbase Action is creating a record in Table 2 but the URL/Attachment is not copied. Can you please help me with this.

      TIA

      ------------------------------
      Hema
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago

        Hema,

        I think you misunderstood my post. That code will allow you give the user a link to display the file attachment by clicking a link on a different table from where the file attachment was loaded. 

        It will not copy the actual file to another table. 



        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------
  • ZintJoseph's avatar
    ZintJoseph
    Qrew Captain
    8 years ago

    Thanks Mark...that was the ticket....it worked great

    By the way, how did you know that the filed was actually 30....did you hack my app!

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    No hack. Dumb Luck.  I have that formula saved in my Tips app and I just used it "as is".