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 ...
File attachments
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
      ------------------------------
      • HemaRajendran1's avatar
        HemaRajendran1
        Qrew Trainee
        4 years ago
        Got you! Thank you for the clarification.
        I'm trying to move a set of file Attachments from Table 1 to its own (New) table( Document table). Is there a way to do it without downloading and attaching the Documents multiple times?

        TIA

        ------------------------------
        Hema
        ------------------------------